108,213 recent views

## 50%

got a tangible career benefit from this course

## 50%

got a pay increase or promotion
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Reset deadlines in accordance to your schedule.
Beginner Level
Approx. 23 hours to complete
English

### Skills you will gain

Data AnalysisMicrosoft ExcelStatistical AnalysisNormal Distribution

## 50%

got a tangible career benefit from this course

## 50%

got a pay increase or promotion
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Reset deadlines in accordance to your schedule.
Beginner Level
Approx. 23 hours to complete
English

## Start working towards your Master's degree

This course is part of the 100% online Master of Business Administration (iMBA) from University of Illinois at Urbana-Champaign. If you are admitted to the full program, your courses count towards your degree learning.

## Syllabus - What you will learn from this course

Content Rating95%(2,643 ratings)
Week
1

## Week 1

2 hours to complete

## Course Orientation

2 hours to complete
2 videos (Total 7 min), 6 readings, 1 quiz
2 videos
Excel Data Analysis Toolpak1m
Syllabus10m
ePub10m
About the Discussion Forums4m
Glossary5m
Using Excel for this Course10m
1 practice exercise
Orientation Quiz30m
5 hours to complete

## Module 1: Introduction and Summarizing Data

5 hours to complete
11 videos (Total 63 min), 2 readings, 6 quizzes
11 videos
1-2.1. Summarizing Data: Frequency Tables7m
1-2.2. Frequency Tables in Excel: Quantitative Data6m
1-2.3. Frequency Tables in Excel: Qualitative Data6m
1-2.4. Presenting Frequency Tables as a Bar Graph in Excel2m
1-3.1. Summarizing Data: Histograms5m
1-3.2. Histograms in Excel7m
1-4.1. Summarizing Data: Pie Charts4m
1-4.2. Pie Charts in Excel5m
1-5.1. Summarizing Data: Scatter Plots4m
1-5.2. Scatter Plots in Excel4m
Module 1 Overview3m
6 practice exercises
Lesson 1-1 Practice Quiz30m
Lesson 1-2 Practice Quiz30m
Lesson 1-3 Practice Quiz30m
Lesson 1-4 Practice Quiz30m
Lesson 1-5 Practice Quiz30m
Module 1 Quiz30m
Week
2

## Week 2

7 hours to complete

## Module 2: Descriptive Statistics and Probability Distributions

7 hours to complete
16 videos (Total 107 min), 2 readings, 7 quizzes
16 videos
2-1.2. Mean and Median in Excel3m
2-2.1. Measures of Dispersion9m
2-2.2. Standard Deviation in Excel2m
2-3.1. Percentiles and Z-Score13m
2-3.2. Z-Score in Excel5m
2-4.1. Discrete and Continuous Random Variables11m
2-4.2. Expected Value in Excel6m
2-5.1. Normal Distribution10m
2-5.2. Normal Distribution in Excel5m
2-5.3. Standard Normal Distribution in Excel4m
2-5.4. "Less Than" in Excel1m
2-5.5. "Greater Than" in Excel1m
2-5.6. "Between Values" in Excel1m
2-5.7. Finding Z for a Given Probability (INV) in Excel3m
2-6.1. Standard Normal Distribution Table14m
Module 2 Overview3m
Module 2 Readings1h 15m
7 practice exercises
Lesson 2-1 Practice Quiz30m
Lesson 2-2 Practice Quiz30m
Lesson 2-3 Practice Quiz30m
Lesson 2-4 Practice Quiz30m
Lesson 2-5 Practice Quiz30m
Lesson 2-6 Practice Quiz30m
Module 2 Quiz30m
Week
3

## Week 3

5 hours to complete

## Module 3: Sampling and Central Limit Theorem

5 hours to complete
7 videos (Total 63 min), 2 readings, 6 quizzes
7 videos
3-2.1. Sampling14m
3-2.2 Sampling Function in Excel6m
3-3.1. Central Limit Theorem and Sampling Means9m
3-3.2. Animating the Central Limit Theorem6m
3-3.3. Sampling Distribution and Empirical Rule in Excel11m
3-4.1. Central Limit Theorem – Sampling Proportion5m
Module 3 Overview3m
5 practice exercises
Lesson 3-1 Practice Quiz30m
Lesson 3-2 Practice Quiz30m
Lesson 3-3 Practice Quiz30m
Lesson 3-4 Practice Quiz30m
Module 3 Quiz30m
Week
4

## Week 4

5 hours to complete

## Module 4: Inference

5 hours to complete
13 videos (Total 101 min), 3 readings, 5 quizzes
13 videos
4-2.1. Confidence Interval for Means9m
4-2.2. Confidence Interval for Mean in Excel8m
4-2.3. Impact of Confidence Level Illustrated in Excel4m
4-3.1. Confidence Interval for Population Proportion10m
4-3.2. Confidence Interval for Population Proportion in Excel8m
4-3.3. Confidence Interval Animation in Excel5m
4-3.4. Starting Salary Example in Excel7m
4-4.1. Sample Size9m
4-4.2. Sample Size Proportion in Excel3m
4-4.3. Sample Size Mean in Excel7m
4-4.4. Sample Size Effect in Excel5m
Gies Online Programs3m
Module 4 Overview3m
Congratulations!10m
5 practice exercises
Lesson 4-1 Practice Quiz30m
Lesson 4-2 Practice Quiz30m
Lesson 4-3 Practice Quiz30m
Lesson 4-4 Practice Quiz30m
Module 4 Quiz30m

## Frequently Asked Questions

More questions? Visit the Learner Help Center.