This course provides an analytical framework to help you evaluate key problems in a structured fashion and will equip you with tools to better manage the uncertainties that pervade and complicate business processes. The course aim to cover statistical ideas that apply to managers. We will consider two basic themes: first, is recognizing and describing variations present in everything around us, and then modeling and making decisions in the presence of these variations. The fundamental concepts studied in this course will reappear in many other classes and business settings. Our focus will be on interpreting the meaning of the results in a business and managerial setting.
This course is part of the Managerial Economics and Business Analysis Specialization
Offered By
Managerial Economics and Business Analysis SpecializationUniversity of Illinois at Urbana-ChampaignAbout this Course
31,270 recent views
Learner Career Outcomes
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.
Course 6 of 7 in the
Flexible deadlines
Reset deadlines in accordance to your schedule.
Approx. 19 hours to complete
English
Subtitles: Arabic, French, Portuguese (European), Chinese (Simplified), Italian, Vietnamese, Korean, German, Russian, Turkish, English, Spanish
Skills you will gain
Statistical InferenceStatistical AnalysisStatistical Hypothesis Testing
Learner Career Outcomes
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.
Course 6 of 7 in the
Flexible deadlines
Reset deadlines in accordance to your schedule.
Approx. 19 hours to complete
English
Subtitles: Arabic, French, Portuguese (European), Chinese (Simplified), Italian, Vietnamese, Korean, German, Russian, Turkish, English, Spanish
Offered by
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.
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
1 hour to complete
Course Orientation
In the course orientation, you will become familiar with the course, your classmates, and our learning environment. The orientation will also help you obtain the technical skills required for the course.
1 hour to complete
2 videos (Total 7 min), 6 readings, 1 quiz
2 videos
Excel Data Analysis Toolpak1m
6 readings
Syllabus10m
ePub10m
About the Discussion Forums4m
Glossary15m
Using Excel for this Course10m
Updating Your Profile10m
1 practice exercise
Orientation Quiz10m
4 hours to complete
Module 1: Hypothesis Testing
Watch any infomercial and you hear many outrageous promises. Use this cream and your skin will look 80% firmer! Use this supplement and you will lose 10 pounds in the first 10 days! Are they telling you the truth? Are they all lying? The only way to know the answer to any of these questions is to scientifically test the claim being made – that is what we call hypothesis testing and what we will learn in this module.
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
2 readings
Module 1 Overview3m
Module 1 Readings1h
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
5 hours to complete
Module 2: Statistical Inference Based on Two Samples
Does the medicine a person is taking to treat his condition really work better than a sugar pill? Is the new chip-enabled credit card more secure than the magnetic card? How do you know whether the claims being made about anything being “better than” or “faster than” a competitor are true? In this module we will learn to make this comparison.
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
2 readings
Module 2 Overview3m
Module 2 Readings1h
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
4 hours to complete
Module 3: Simple Linear Regression
Does your job involve a lot of sitting? If so, you are at higher risk of coronary heart disease. How do I know this? We got to know the relationship between coronary heart disease and sitting when researchers studied a cohort of London bus drivers and bus conductors from 1947 to 1972. If you want to know more, then read on!
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
2 readings
Module 3 Overview3m
Module 3 Readings1h
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
3 hours to complete
Module 4: Multiple Linear Regression
You are trying to predict next month’s sales numbers. You know that dozens, maybe even hundreds, of things like the weather, competitor’s promotions, rumors, etc. can impact the number. You talk to five people and each one has an idea about what makes the biggest impact, and the only thing they offer is “trust me.” Do you wish there was a better way of doing this rather than relying on blind faith? Well, there is. We can use Multiple Regression to sort through this mess and bring the focus to factors that really do matter.
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
3 readings
Module 4 Overview3m
Module 4 Readings1h
Congratulations!10m
4 practice exercises
Lesson 4-1 Practice Quiz15m
Lesson 4-2 Practice Quiz15m
Lesson 4-3 Practice Quiz15m
Module 4 Quiz30m
Reviews
TOP REVIEWS FROM INFERENTIAL AND PREDICTIVE STATISTICS FOR BUSINESS
by JCDec 10, 2020
I find the use of Excel after the lecture to be more useful in the real life. The professor has a slower speaking speed so you may need to use 2x the speed.\n\nThe content is super useful.
by SGMay 19, 2017
Very good introductory Statistics course. The topic selection is very pertinent to meet the need of a manager to analyze data and to make decision. Quality of teaching is GREAT.
by EKDec 7, 2019
Great course! Incredibly well organized and clear. I was terrified of Stats before I took this class, now I feel confident and am seeing my entire world differently. Thank you!
by DFDec 28, 2019
Very well produced. The modules are clear and easy to follow. Maybe I missed it but it would be good to supply all the related example data in Excel to be able to practice.
About the Managerial Economics and Business Analysis Specialization
In order to effectively manage and operate a business, managers and leaders need to understand the market characteristics and economic environment they operate in. In this Specialization, you will build a solid understanding of the operation of markets and the macro-economic environment with real-world examples. You will be able to identify firm and country-level economic factors that impact business decisions, develop an analytical framework using statistical tools, and apply economic theory and data in the analysis of business environment and trends to make effective business decisions.
Frequently Asked Questions
When will I have access to the lectures and assignments?
What will I get if I subscribe to this Specialization?
Is financial aid available?
Will I earn university credit for completing the Course?
More questions? Visit the Learner Help Center.
