Statistics and Data Analysis with Excel: Essentials

Overview

Statistics and data analysis involve collecting, analysing, interpreting and presenting data to stakeholders to enhance their decision-making. Statistics is all about making sense of numbers and finding patterns in the data - in business, health, sports, science, the arts, and more. Statistics can be divided into two main branches, descriptive statistics and inferential statistics. Descriptive Statistics summarise and describe the features of a data set. Inferential Statistics allow us to make predictions or inferences about a population based on a sample of data that we have access to. In this course, you will be equipped with the tools and techniques to transform your data into meaningful output to drive insights for your work and your organisation. We will explore both Descriptive Statistics as well as Inferential Statistics.

Syllabus

Introduction to Statistics

In this module, we will cover the Introduction to Statistics. What is Statistics? What are the different types of Statistics? How do we summarise large volumes of data to make it more meaningful to generate insights for our organisation? Welcome to the Introduction to Statistics!

Variance

In this module, we will cover Variance. Now that we know how to measure centred-ness, how do we measure spread? What are the various numerical and graphical measures of spread? Why is measuring spread important? Welcome to Variance!

Normal Distribution

Now that we have looked at measures of centred-ness and measures of spread, let's bring it all together. What do data distributions look like? What can we infer from a sample of data if we know its centre and its spread? Are all distributions the same? Welcome to the Normal Distribution!

Statistical Inference

Now that you have mastered the Normal Distribution, let's do some testing! What if you want to make an inference about an entire population but you only have a sample of data? How can you use the statistics of a sample to make decisions for your organisation? How large should your sample size be? Welcome to Statistical Inference!

Optional - Additional Excel Content to enhance your Excel Skills

The material in this module consists of a series of Toolboxes. While the material covered in these Toolboxes is not necessarily related to Statistics - these Toolboxes will help you expand your tools and techniques in Microsoft Excel. To further your skills in Microsoft Excel in domains beyond Statistics, you may want to consider our other courses and specializations: Excel Skills for Business. Excel Skills for Data Analytics and Visualization, Excel Skills for Business Forecasting