Business Statistics 101

Learn descriptive statistics and statistical plots using MS Excel

4.50 (8 reviews)
Udemy
platform
English
language
Data & Analytics
category
instructor
Business Statistics 101
1,169
students
1.5 hours
content
Jan 2023
last update
$19.99
regular price

What you will learn

Students will learn descriptive statistics

Students will learn how to interpret descriptive statistics

Students will learn how to find out descriptive statistics using Microsoft Excel

Students will learn how to analyse descriptive statistics to draw inferences about data

Students will learn data visualisation

Students will learn about different plots

Students will learn how to visualise data on Excel

Why take this course?

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 does 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, intuition.

3. Descriptive Statistics in Excel.

4. Different types of plots.

5. Data Visualisation in Excel.

Screenshots

Business Statistics 101 - Screenshot_01Business Statistics 101 - Screenshot_02Business Statistics 101 - Screenshot_03Business Statistics 101 - Screenshot_04

Reviews

Arita
January 27, 2023
A very helpful & excellent course. The instructor starts from the very basics and proceeds towards the intermediate & advanced concepts, making the course easy to follow & understand. All the concepts & techniques explained elaborately. The various plots in Excel very nicely explained. The project attached here on Sales and R&D costs makes the understanding crystal clear. The lively way of teaching really appreciating. Highly recommended . A very satisfying course overall.

Charts

Price

Business Statistics 101 - Price chart

Rating

Business Statistics 101 - Ratings chart

Enrollment distribution

Business Statistics 101 - Distribution chart
5105374
udemy ID
1/23/2023
course created date
1/24/2023
course indexed date
Bot
course submited by