Microsoft Excel Statistics
Statistics involves collecting, analysing, interpreting, presenting, and organising data and provides methods for making inferences and conclusions about a population based on a sample of data.
Microsoft Excel offers various techniques and functions to calculate a single value or an array of values from the data in your Excel worksheets.
Whether you want to use the Excel Analysis ToolPak (an add-in that provides many statistical analysis tools) or formulas for statistical analysis, such as probability and distribution, this course will guide you through building and developing the various advanced statistical approaches needed.
We will use Microsoft Excel and various sample datasets to produce statistical results that can be used in reports and storytelling.
We will help you apply the topics covered in the course to your everyday activities through hands-on learning and structured workshops.
At the end of the course, you’ll be able to:
Build probability formulas
Develop statistical distribution functionality
Apply inferential statistics to datasets
You will need a working knowledge of the following;
Module 1: Probability rules
- Conditional Probability
- Bayes’ Theorem
- Random Variables
Module 2: Statistical Distributions
Module 3: Inferential Statistics
- Point Estimates
- Hypothesis Testing
- Confidence Levels
Module 4: Inference for Numerical Data
Module 5: Inference for Categorical Data