Descriptive Statistics and Data Visualisation using Excel

In this course, I teach descriptive statistics and data visualisation using Excel.

I teach how descriptive statistics can be used to draw inferences about patterns in data. I teach how statistical tools such as mean, median, mode, variance, standard deviation, skewness, kurtosis, standard error, range, outliers, rank, percentile, maximum and minimum values can be used to understand data better.

The statistical tools are taught using Microsoft Excel, and the course is designed in a way that will allow students to understand the nature of data better.

Descriptive Statistics is the foundation for higher level statistical analysis and data analysis, and often people ignore it. But in this course, I show how important and insightful descriptive statistics can be. Concepts such as skew, and kurtosis for example are pivotal in understanding the dispersion and distribution of data, and in this course, I teach the intuition underlying these measures and their applications.

The following measurements will be taught in the course:

1. Mean

2. Median

3. Mode

4. Variance

5. Standard Deviation.

6. Standard Error.

7. Maximum

8. Minimum.

9. Range.

10. Rank

11. Percentile.

12. Skewness.

13. Kurtosis

14. Outliers

Also, in this course, using Excel, I teach how descriptive statistical measures can be obtained easily in the form of statistical reports.

In this course, I use real world data to demonstrate concepts, and at the end of the course, the students will be provided with a  dataset to apply the techniques learnt in Excel.

Further, in this course, I  teach about the most commonly used plots for data visualization. I teach how each plot is generated, what it represents and what can be inferred from them.

I, then, show how the plots can be generated with Excel and how data is visualised using Excel.

The following types of plots are taught:

1. Bar Plot

2. Pie Chart.

3. X-Y Scatter Plot

4. Histogram.

5. Line Plot

6. Box and Whisker Plot.

At the end of the course, you’ll be well equipped to visualise data in Excel and interpret the visualised plots.

The course is meant for students who want to learn basic statistics and understand how basic statistics can be used to draw inferences about the nature of data. The methods taught in the course will allow students to draw the following inferences:

1. Is the data widely dispersed?

2. Does the data have outliers?

3. Is the data skewed?

4. Is the distribution normal?

5. What is the structure of data?

6. What do the statistical measures tell about the dataset?

The course is structured as follows:

1. Activating data analysis toolkits in Excel.

2. Descriptive Statistics measures and concepts, their definition, and intuition.

3. Descriptive Statistics in Excel.

4. Different types of plots.

5. Data Visualisation in Excel.