About this course: 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. Specifically, you will be introduced to statistics and how to summarize data and learn concepts of frequency, normal distribution, statistical studies, sampling, and confidence intervals. While you will be introduced to some of the science of what is being taught, the focus will be on applying the methodologies. This will be accomplished through the use of Excel and data sets from many different disciplines, allowing you to see the use of statistics in very diverse settings. The course will focus not only on explaining these concepts, but also understanding the meaning of the results obtained. Upon successful completion of this course, you will be able to: • Summarize large data sets in graphical, tabular, and numerical forms. • Understand the significance of proper sampling and why you can rely on sample information. • Understand why normal distribution can be used in so many settings. • Use sample information to infer about the population with a certain level of confidence about the accuracy of the estimations. • Use Excel for statistical analysis. This course is part of the iMBA offered by the University of Illinois, a flexible, fully-accredited online MBA at an incredibly competitive price. For more information, please see the Resource page in this course and onlinemba.illinois.edu.
Taught by: Fataneh Taghaboni-Dutta, Clinical Professor of Business Administration
University of Illinois, Urbana-Champaign College of Business Department of Business Administration
| Basic Info | Course 5 of 7 in the Managerial Economics and Business Analysis Specialization |
| Level | Beginner |
| Commitment | 4 weeks of study, 4-6 hours/week |
| Language | English |
| How To Pass | Pass all graded assignments to complete the course. |
| User Ratings |
- 阅读: Syllabus
- 阅读: About the Discussion Forums
- 阅读: Glossary
- 练习测验: Orientation Quiz
- 阅读: Using Excel for this Course
- Video: Excel Data Analysis Toolpak
- 阅读: Updating Your Profile
- 讨论提示: Getting to Know Your Classmates
- 阅读: Social Media
- 阅读: Module 1 Overview
- 阅读: Module 1 Readings
- 练习测验: Lesson 1-1 Practice Quiz
- Video: 1-2.1. Summarizing Data: Frequency Tables
- Video: 1-2.2. Frequency Tables in Excel: Quantitative Data
- Video: 1-2.3. Frequency Tables in Excel: Qualitative Data
- Video: 1-2.4. Presenting Frequency Tables as a Bar Graph in Excel
- 练习测验: Lesson 1-2 Practice Quiz
- Video: 1-3.1. Summarizing Data: Histograms
- Video: 1-3.2. Histograms in Excel
- 练习测验: Lesson 1-3 Practice Quiz
- Video: 1-4.1. Summarizing Data: Pie Charts
- Video: 1-4.2. Pie Charts in Excel
- 练习测验: Lesson 1-4 Practice Quiz
- Video: 1-5.1. Summarizing Data: Scatter Plots
- Video: 1-5.2. Scatter Plots in Excel
- 练习测验: Lesson 1-5 Practice Quiz
- 阅读: Module 2 Overview
- 阅读: Module 2 Readings
- Video: 2-1.2. Mean and Median in Excel
- 练习测验: Lesson 2-1 Practice Quiz
- Video: 2-2.1. Measures of Dispersion
- Video: 2-2.2. Standard Deviation in Excel
- 练习测验: Lesson 2-2 Practice Quiz
- Video: 2-3.1. Percentiles and Z-Score
- Video: 2-3.2. Z-Score in Excel
- 练习测验: Lesson 2-3 Practice Quiz
- Video: 2-4.1. Discrete and Continuous Random Variables
- Video: 2-4.2. Expected Value in Excel
- 练习测验: Lesson 2-4 Practice Quiz
- Video: 2-5.1. Normal Distribution
- Video: 2-5.2. Normal Distribution in Excel
- Video: 2-5.3. Standard Normal Distribution in Excel
- Video: 2-5.4. "Less Than" in Excel
- Video: 2-5.5. "Greater Than" in Excel
- Video: 2-5.6. "Between Values" in Excel
- Video: 2-5.7. Finding Z for a Given Probability (INV) in Excel
- 练习测验: Lesson 2-5 Practice Quiz
- Video: 2-6.1. Standard Normal Distribution Table
- 练习测验: Lesson 2-6 Practice Quiz
- 阅读: Module 3 Overview
- 阅读: Module 3 Readings
- 练习测验: Lesson 3-1 Practice Quiz
- Video: 3-2.1. Sampling
- Video: 3-2.2 Sampling Function in Excel
- 练习测验: Lesson 3-2 Practice Quiz
- Video: 3-3.1. Central Limit Theorem and Sampling Means
- Video: 3-3.2. Animating the Central Limit Theorem
- Video: 3-3.3. Sampling Distribution and Empirical Rule in Excel
- 练习测验: Lesson 3-3 Practice Quiz
- Video: 3-4.1. Central Limit Theorem – Sampling Proportion
- 练习测验: Lesson 3-4 Practice Quiz
- 阅读: Module 4 Overview
- 阅读: Module 4 Readings
- 练习测验: Lesson 4-1 Practice Quiz
- Video: 4-2.1. Confidence Interval for Means
- Video: 4-2.2. Confience Interval for Mean in Excel
- Video: 4-2.3. Impact of Confidence Level Illustrated in Excel
- 练习测验: Lesson 4-2 Practice Quiz
- Video: 4-3.1. Confidence Interval for Population Proportion
- Video: 4-3.2. Confidence Interval for Population Proportion in Excel
- Video: 4-3.3. Confidence Interval Animation in Excel
- Video: 4-3.4. Starting Salary Example in Excel
- 练习测验: Lesson 4-3 Practice Quiz
- Video: 4-4.1. Sample Size
- Video: 4-4.2. Sample Size Proportion in Excel
- Video: 4-4.3. Sample Size Mean in Excel
- Video: 4-4.4. Sample Size Effect in Excel
- 练习测验: Lesson 4-4 Practice Quiz
每门课程都像是一本互动的教科书，具有预先录制的视频、测验和项目。
与其他成千上万的学生相联系，对想法进行辩论，讨论课程材料，并寻求帮助来掌握概念。
获得正式认证的作业，并与朋友、同事和雇主分享您的成功。
| Purchase Course | |
|---|---|
| Access to course materials | Available |
| Access to graded materials | Available |
| Receive a final grade | Available |
| Earn a shareable Course Certificate | Available |
Great class!
This is truly a great course. Anyone in a business program or a working professional will be very thankful that they took statistics with Professor TAghaboni-Dutta. She is a remarkable teacher and consistently ranks as one of Illinois' best Professors. The two class sessions break down statistics into easy-to-understand lessons. Professor Taghaboni-Dutta incorporates contemporary interesting problems and issues into her lessons, which make statistics much more interesting!. Another feature of this class, which I considered a wonderful value, are her extra instructional videos showing how to use Excel to solve statistics problems. These videos are better than anything else I've found. I'm serious, even MSFT doesn't have instructional videos that are as good and easy to understand as the ones in this class. If they were posted on You-Tube, she'd probably get sponsors quickly.
I don't mean to sound like a cheerleader, but I know what it is like to take Statistics from a bad teacher. I took Statistics a long time ago, before Excel existed. I remember trying to understand a professor who spent all of her time writing out proofs and never answering questions. It was one of the most frustrating depressing classes of my undergraduate experience. Professor Taghaboni-Dutta's classes are enjoyable and educational. She is highly accommodating and yet thorough. Heck, I'm even considering taking more classes in statistics. and probability. Bottom line, this class is a total home-run and a significant value for the money!
Great course and structure. Professor was great.
Well organized !!