Archive | Excel Tips: Mastering Data Analysis

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
Microsoft_Excel_2013_logo.svg

Mastering Data Analysis: Introduction (Part 1)

In this post, I will highlight the topics that will be covered in this tutorial. There will be 6 main parts to this tutorial that involves using Excel, which consists of: Descriptive Statistics Visualisation Testing Hypothesis Probability Distributions Co-variance & Correlation Bayesian Analysis I will describe more about these main topics in future tutorials. However, […]

Continue Reading 0

Powered by WordPress. Designed by WooThemes

Free WordPress Themes