About this Course
36,749 recent views

Learner Career Outcomes

50%

got a tangible career benefit from this course

50%

got a pay increase or promotion

100% online

Start instantly and learn at your own schedule.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Beginner Level

Approx. 23 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

Learner Career Outcomes

50%

got a tangible career benefit from this course

50%

got a pay increase or promotion

100% online

Start instantly and learn at your own schedule.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Beginner Level

Approx. 23 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
5 readings
Syllabus10m
About the Discussion Forums4m
Glossary5m
Using Excel for this Course10m
Updating Your Profile10m
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.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
2 readings
Module 1 Overview3m
Module 1 Readings45m
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-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
2 readings
Module 2 Overview3m
Module 2 Readings1h 15m
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-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
2 readings
Module 3 Overview3m
Module 3 Readings30m
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.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
2 readings
Module 4 Overview3m
Module 4 Readings20m
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
96 ReviewsChevron Right

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

Instructor

Avatar

Fataneh Taghaboni-Dutta

Clinical Professor of Business Administration
University of Illinois, Urbana-Champaign College of Business Department of Business Administration

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

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. The capstone project involves an in-depth analysis of an actual business situation in which you will examine the global economic environment of a business. The final project will be a business plan that uses statistical tools and economic theory to create a comprehensive analysis of the microeconomic and macroeconomic environment in which the focal company operates. This Specialization is part of the University of Illinois Masters of Business Administration degree program, the iMBA. Learn more about the admission into the program here and how your Coursera work can be leveraged if accepted into the program. You can also start with for-credit courses within the Illinois iMBA degree program....
Managerial Economics and Business Analysis

Frequently Asked Questions

  • Once you enroll for a Certificate, you’ll have access to all videos, quizzes, and programming assignments (if applicable). Peer review assignments can only be submitted and reviewed once your session has begun. If you choose to explore the course without purchasing, you may not be able to access certain assignments.

  • When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

More questions? Visit the Learner Help Center.