42,575 recent views

## 50%

got a tangible career benefit from this course
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Approx. 19 hours to complete
English
Subtitles: English, Korean

## Skills you will gain

Statistical InferenceStatistical AnalysisStatistical Hypothesis Testing

## 50%

got a tangible career benefit from this course
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Approx. 19 hours to complete
English
Subtitles: English, Korean

## 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 Rating96%(1,467 ratings)
Week
1

## Week 1

1 hour to complete

## Course Orientation

1 hour to complete
2 videos (Total 7 min), 6 readings, 1 quiz
2 videos
Excel Data Analysis Toolpak1m
Syllabus10m
ePub10m
Glossary15m
Using Excel for this Course10m
1 practice exercise
Orientation Quiz10m
4 hours to complete

## Module 1: Hypothesis Testing

4 hours to complete
11 videos (Total 80 min), 2 readings, 6 quizzes
11 videos
1-2.1. Analyzing the Result8m
1-3.1. Two-Tail Test for Mean10m
1-3.2. Two-Tail Test for Mean in Excel4m
1-4.1. One-Tail Test for Mean5m
1-4.2. Left-Tail Test for Mean in Excel3m
1-4.3. Right-Tail Test for Mean in Excel6m
1-5.1. Testing the Proportion12m
1-5.2. Left-Tail Test for Proportion in Excel5m
1-5.3. Right-Tail Test for Proportion in Excel3m
1-5.4. Two-Tail Test for Proportion in Excel5m
Module 1 Overview3m
6 practice exercises
Lesson 1-1 Practice Quiz15m
Lesson 1-2 Practice Quiz30m
Lesson 1-3 Practice Quiz15m
Lesson 1-4 Practice Quiz15m
Lesson 1-5 Practice Quiz15m
Module 1 Quiz30m
Week
2

## Week 2

5 hours to complete

## Module 2: Statistical Inference Based on Two Samples

5 hours to complete
11 videos (Total 93 min), 2 readings, 7 quizzes
11 videos
2-1.2. Testing for No Difference in Means in Excel9m
2-1.3. Two-Tail Mean Test for Two Samples and Calculating the Confidence Interval in Excel6m
2-2.1. One-Tail Test of the Means9m
2-2.2. One-Tail Test of the Means in Excel5m
2-3.1. Testing for a Specific Value in Means6m
2-4.1. Paired Tests9m
2-4.2. Paired Test in Excel7m
2-5.1. Test of Proportions11m
2-5.2. One-Tail Test of Proportions for Two Samples in Excel6m
2-5.3. Two-Tail Test of Proportions for Two Samples in Excel3m
Module 2 Overview3m
6 practice exercises
Lesson 2-1 Practice Quiz15m
Lesson 2-2 Practice Quiz15m
Lesson 2-3 Practice Quiz15m
Lesson 2-4 Practice Quiz15m
Lesson 2-5 Practice Quiz15m
Module 2 Quiz30m
Week
3

## Week 3

4 hours to complete

## Module 3: Simple Linear Regression

4 hours to complete
9 videos (Total 70 min), 2 readings, 6 quizzes
9 videos
3-2.1. Least Square Methods7m
3-2.2. Least Square Method in Excel3m
3-3.1. Assessing the Regression Model10m
3-3.2. Testing the Significance in Excel4m
3-4.1. Using the Model10m
3-4.2. Simple Linear Regression: Excel Output Analysis7m
3-5.1. Model Assumptions and Limitations8m
3-5.2. Residual Analysis in Excel4m
Module 3 Overview3m
6 practice exercises
Lesson 3-1 Practice Quiz15m
Lesson 3-2 Practice Quiz15m
Lesson 3-3 Practice Quiz30m
Lesson 3-4 Practice Quiz15m
Lesson 3-5 Practice Quiz15m
Module 3 Quiz30m
Week
4

## Week 4

3 hours to complete

## Module 4: Multiple Linear Regression

3 hours to complete
8 videos (Total 60 min), 3 readings, 4 quizzes
8 videos
4-1.2. Developing Multiple Regression Model in Excel6m
4-1.3. Multiple Regression: Excel Output Analysis5m
4-2.1. Qualitative Data – Two Categories12m
4-2.2. Dummy Variable in Excel – Two Categories6m
4-3.1. Qualitative Data – Many Categories6m
4-3.2. Dummy Variable in Excel – Many Categories5m
Gies Online Programs3m
Module 4 Overview3m
Congratulations!10m
4 practice exercises
Lesson 4-1 Practice Quiz15m
Lesson 4-2 Practice Quiz15m
Lesson 4-3 Practice Quiz15m
Module 4 Quiz30m