python-logo

Python: Basic Questions – Functions & If Statements

Question 1: Using Functions Using a function to allow a “block of code” to take in arguments/values and returns a result. Task: Print 2*(n+1) to m using the double and increment functions provided. ‘2’ -> ‘6’ ‘0’ -> ‘2’ ‘-3’ -> ‘-4’ When given the functions: def increment(x): “”” Increment the argument (ie, return the […]

Continue Reading 0
python-logo

Python: Intro – Basic Questions

*Please note that the comments in the code, started by the hashtag, are for educational purposes and do not change the code. Question 1: Introduction: Hello, World! Printing text (e.g. Hello World) Task: Output the string ‘Hello, World!’ Answer: Explanation: Quotations are required because we want to print a string. However, if the task required […]

Continue Reading 0

Happy New Year and Goals for 2017

Like all New Years, everyone will have numerous New Years resolutions they want to fulfil, and for me, I want to continue delivering useful tips and tricks for free to everyone. 2016 was an enjoyable year and I hope there is more to come in 2017. There will be many exciting posts and projects ahead […]

Continue Reading 1
microsoft_excel_2013_logo-svg

Mastering Data Analysis: Central Limit Theorem (Part 5)

This post in the tutorial set is more thereotical, rather than practical, so Excel will not be required in this post. Central Limit Theorem states that “for a sufficiently large sample size from a population with a finite level of variance, the mean of all samples from the same population will be approximately equal to […]

Continue Reading 0
microsoft_excel_2013_logo-svg

Mastering Data Analysis: Variance and Standard Deviation (Part 4)

Variance and standard deviation are useful statistical information that will give an indication of the how distributed the data is. Variance is how distribution/ “varied” the data is, and standard deviation of how much the members of a group differ from the mean value for the group. Variance VAR.P : Calculate variance based on entire […]

Continue Reading 0
firefox

Firefox: Disabling Pocket plugin

In the recent updates of Firefox, a service – Pocket (saves pages for reading later) was installed. You can either hide this functionality or disable it entirely. To hide the Pocket plugin, navigate to the toolbar, right-click the Pocket icon  and select Remove from Toolbar.   To unhide the Pocket plugin, navigate to the Open Menu icon […]

Continue Reading 0
Microsoft_Excel_2013_logo.svg

Mastering PivotTables: Part 14 (Conditional Formatting in PivotTables)

Conditional formatting helps you visually explore and analyse data, detect critical issues/problems, and allows you to identify pattern and trends in the data. It is important to understand the differences when using conditional formatting on a PivotTable. There are three methods for scoping the conditional format of fields in the Values area: by selection, by […]

Continue Reading 0

Powered by WordPress. Designed by WooThemes

Free WordPress Themes