11,227 recent views

#### 100% online

Start instantly and learn at your own schedule.

#### Approx. 22 hours to complete

Suggested: 4 weeks of study, 4-6 hours/week...

#### English

Subtitles: English, Arabic

### Skills you will gain

Data AnalysisMicrosoft ExcelStatistical AnalysisNormal Distribution

#### 100% online

Start instantly and learn at your own schedule.

#### Approx. 22 hours to complete

Suggested: 4 weeks of study, 4-6 hours/week...

#### English

Subtitles: English, Arabic

### Syllabus - What you will learn from this course

Week
1
1 hour to complete

## Course Orientation

2 videos (Total 7 min), 5 readings, 1 quiz
Syllabus10m
Glossary5m
Using Excel for this Course10m
1 practice exercise
Orientation Quiz10m
3 hours to complete

## Module 1: Introduction and Summarizing Data

11 videos (Total 63 min), 2 readings, 6 quizzes
11 videos
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 Quiz6m
Lesson 1-2 Practice Quiz10m
Lesson 1-3 Practice Quiz8m
Lesson 1-4 Practice Quiz8m
Lesson 1-5 Practice Quiz8m
Module 1 Quiz38m
Week
2
4 hours to complete

## Module 2: Descriptive Statistics and Probability Distributions

16 videos (Total 107 min), 2 readings, 7 quizzes
16 videos
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
7 practice exercises
Lesson 2-1 Practice Quiz6m
Lesson 2-2 Practice Quiz8m
Lesson 2-3 Practice Quiz6m
Lesson 2-4 Practice Quiz6m
Lesson 2-5 Practice Quiz6m
Lesson 2-6 Practice Quiz6m
Module 2 Quiz30m
Week
3
5 hours to complete

## Module 3: Sampling and Central Limit Theorem

7 videos (Total 63 min), 2 readings, 6 quizzes
7 videos
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 Quiz8m
Lesson 3-2 Practice Quiz8m
Lesson 3-3 Practice Quiz6m
Lesson 3-4 Practice Quiz6m
Module 3 Quiz44m
Week
4
3 hours to complete

## Module 4: Inference

12 videos (Total 97 min), 2 readings, 5 quizzes
12 videos
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
Module 4 Overview3m
5 practice exercises
Lesson 4-1 Practice Quiz6m
Lesson 4-2 Practice Quiz6m
Lesson 4-3 Practice Quiz6m
Lesson 4-4 Practice Quiz8m
Module 4 Quiz20m
4.8
78 Reviews

## 50%

got a tangible career benefit from this course

## 50%

got a pay increase or promotion

### Top reviews from Exploring and Producing Data for Business Decision Making

By DAMay 15th 2018

The separation of the concepts and Excel skills made the lessons very easy to navigate. Although I knew the concepts from a previous statistics course, the Excel skills made everything feel like new!

By RDJun 2nd 2019

Very useful for beginners as well as anyone interested in learning some basics. Highly recommended for managers and people trying to figure out what insights can be obtained form data

## 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.

## About University of Illinois at Urbana-Champaign

The University of Illinois at Urbana-Champaign is a world leader in research, teaching and public engagement, distinguished by the breadth of its programs, broad academic excellence, and internationally renowned faculty and alumni. Illinois serves the world by creating knowledge, preparing students for lives of impact, and finding solutions to critical societal needs. ...