Об этом курсе: 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.
Преподаватели: Fataneh Taghaboni-Dutta, Clinical Professor of Business Administration
University of Illinois, Urbana-Champaign College of Business Department of Business Administration
| Основные сведения | Course 5 of 7 in the Managerial Economics and Business Analysis Specialization |
| Уровень | Начинающий |
| Выполнение | 4 weeks of study, 4-6 hours/week |
| Язык | English |
| Как пройти курс | Чтобы пройти курс, выполните все оцениваемые задания. |
| Оценки пользователей |
- Reading: Syllabus
- Reading: About the Discussion Forums
- Reading: Glossary
- Practice Quiz: Orientation Quiz
- Reading: Using Excel for this Course
- Видео: Excel Data Analysis Toolpak
- Reading: Updating Your Profile
- Discussion Prompt: Getting to Know Your Classmates
- Reading: Social Media
- Reading: Module 1 Overview
- Reading: Module 1 Readings
- Practice Quiz: Lesson 1-1 Practice Quiz
- Видео: 1-2.1. Summarizing Data: Frequency Tables
- Видео: 1-2.2. Frequency Tables in Excel: Quantitative Data
- Видео: 1-2.3. Frequency Tables in Excel: Qualitative Data
- Видео: 1-2.4. Presenting Frequency Tables as a Bar Graph in Excel
- Practice Quiz: Lesson 1-2 Practice Quiz
- Видео: 1-3.1. Summarizing Data: Histograms
- Видео: 1-3.2. Histograms in Excel
- Practice Quiz: Lesson 1-3 Practice Quiz
- Видео: 1-4.1. Summarizing Data: Pie Charts
- Видео: 1-4.2. Pie Charts in Excel
- Practice Quiz: Lesson 1-4 Practice Quiz
- Видео: 1-5.1. Summarizing Data: Scatter Plots
- Видео: 1-5.2. Scatter Plots in Excel
- Practice Quiz: Lesson 1-5 Practice Quiz
- Reading: Module 2 Overview
- Reading: Module 2 Readings
- Видео: 2-1.2. Mean and Median in Excel
- Practice Quiz: Lesson 2-1 Practice Quiz
- Видео: 2-2.1. Measures of Dispersion
- Видео: 2-2.2. Standard Deviation in Excel
- Practice Quiz: Lesson 2-2 Practice Quiz
- Видео: 2-3.1. Percentiles and Z-Score
- Видео: 2-3.2. Z-Score in Excel
- Practice Quiz: Lesson 2-3 Practice Quiz
- Видео: 2-4.1. Discrete and Continuous Random Variables
- Видео: 2-4.2. Expected Value in Excel
- Practice Quiz: Lesson 2-4 Practice Quiz
- Видео: 2-5.1. Normal Distribution
- Видео: 2-5.2. Normal Distribution in Excel
- Видео: 2-5.3. Standard Normal Distribution in Excel
- Видео: 2-5.4. "Less Than" in Excel
- Видео: 2-5.5. "Greater Than" in Excel
- Видео: 2-5.6. "Between Values" in Excel
- Видео: 2-5.7. Finding Z for a Given Probability (INV) in Excel
- Practice Quiz: Lesson 2-5 Practice Quiz
- Видео: 2-6.1. Standard Normal Distribution Table
- Practice Quiz: Lesson 2-6 Practice Quiz
- Reading: Module 3 Overview
- Reading: Module 3 Readings
- Practice Quiz: Lesson 3-1 Practice Quiz
- Видео: 3-2.1. Sampling
- Видео: 3-2.2 Sampling Function in Excel
- Practice Quiz: Lesson 3-2 Practice Quiz
- Видео: 3-3.1. Central Limit Theorem and Sampling Means
- Видео: 3-3.2. Animating the Central Limit Theorem
- Видео: 3-3.3. Sampling Distribution and Empirical Rule in Excel
- Practice Quiz: Lesson 3-3 Practice Quiz
- Видео: 3-4.1. Central Limit Theorem – Sampling Proportion
- Practice Quiz: Lesson 3-4 Practice Quiz
- Reading: Module 4 Overview
- Reading: Module 4 Readings
- Practice Quiz: Lesson 4-1 Practice Quiz
- Видео: 4-2.1. Confidence Interval for Means
- Видео: 4-2.2. Confidence Interval for Mean in Excel
- Видео: 4-2.3. Impact of Confidence Level Illustrated in Excel
- Practice Quiz: Lesson 4-2 Practice Quiz
- Видео: 4-3.1. Confidence Interval for Population Proportion
- Видео: 4-3.2. Confidence Interval for Population Proportion in Excel
- Видео: 4-3.3. Confidence Interval Animation in Excel
- Видео: 4-3.4. Starting Salary Example in Excel
- Practice Quiz: Lesson 4-3 Practice Quiz
- Видео: 4-4.1. Sample Size
- Видео: 4-4.2. Sample Size Proportion in Excel
- Видео: 4-4.3. Sample Size Mean in Excel
- Видео: 4-4.4. Sample Size Effect in Excel
- Practice Quiz: Lesson 4-4 Practice Quiz
Each course is like an interactive textbook, featuring pre-recorded videos, quizzes and projects.
Connect with thousands of other learners and debate ideas, discuss course material, and get help mastering concepts.
Earn official recognition for your work, and share your success with friends, colleagues, and employers.
| Приобрести курс | |
|---|---|
| Получить доступ к материалам курса | Доступен |
| Получить доступ к оцениваемым материалам курса | Доступен |
| Получить итоговую оценку | Доступен |
| Earn a shareable Course Certificate | Доступен |
Well organized !!
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!
Excellent course.