Об этом курсе: 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 |
| Уровень | Beginner |
| Выполнение | 4 weeks of study, 4-6 hours/week |
| Язык | English |
| Как пройти курс | Чтобы пройти курс, выполните все оцениваемые задания. |
| Оценки пользователей |
- Leyendo: Syllabus
- Leyendo: About the Discussion Forums
- Leyendo: Glossary
- Cuestionario de práctica: Orientation Quiz
- Leyendo: Using Excel for this Course
- Видео: Excel Data Analysis Toolpak
- Leyendo: Updating Your Profile
- Cuadro de aviso de la discusión: Getting to Know Your Classmates
- Leyendo: Social Media
- Leyendo: Module 1 Overview
- Leyendo: Module 1 Readings
- Cuestionario de práctica: 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
- Cuestionario de práctica: Lesson 1-2 Practice Quiz
- Видео: 1-3.1. Summarizing Data: Histograms
- Видео: 1-3.2. Histograms in Excel
- Cuestionario de práctica: Lesson 1-3 Practice Quiz
- Видео: 1-4.1. Summarizing Data: Pie Charts
- Видео: 1-4.2. Pie Charts in Excel
- Cuestionario de práctica: Lesson 1-4 Practice Quiz
- Видео: 1-5.1. Summarizing Data: Scatter Plots
- Видео: 1-5.2. Scatter Plots in Excel
- Cuestionario de práctica: Lesson 1-5 Practice Quiz
- Leyendo: Module 2 Overview
- Leyendo: Module 2 Readings
- Видео: 2-1.2. Mean and Median in Excel
- Cuestionario de práctica: Lesson 2-1 Practice Quiz
- Видео: 2-2.1. Measures of Dispersion
- Видео: 2-2.2. Standard Deviation in Excel
- Cuestionario de práctica: Lesson 2-2 Practice Quiz
- Видео: 2-3.1. Percentiles and Z-Score
- Видео: 2-3.2. Z-Score in Excel
- Cuestionario de práctica: Lesson 2-3 Practice Quiz
- Видео: 2-4.1. Discrete and Continuous Random Variables
- Видео: 2-4.2. Expected Value in Excel
- Cuestionario de práctica: 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
- Cuestionario de práctica: Lesson 2-5 Practice Quiz
- Видео: 2-6.1. Standard Normal Distribution Table
- Cuestionario de práctica: Lesson 2-6 Practice Quiz
- Leyendo: Module 3 Overview
- Leyendo: Module 3 Readings
- Cuestionario de práctica: Lesson 3-1 Practice Quiz
- Видео: 3-2.1. Sampling
- Видео: 3-2.2 Sampling Function in Excel
- Cuestionario de práctica: 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
- Cuestionario de práctica: Lesson 3-3 Practice Quiz
- Видео: 3-4.1. Central Limit Theorem – Sampling Proportion
- Cuestionario de práctica: Lesson 3-4 Practice Quiz
- Leyendo: Module 4 Overview
- Leyendo: Module 4 Readings
- Cuestionario de práctica: Lesson 4-1 Practice Quiz
- Видео: 4-2.1. Confidence Interval for Means
- Видео: 4-2.2. Confience Interval for Mean in Excel
- Видео: 4-2.3. Impact of Confidence Level Illustrated in Excel
- Cuestionario de práctica: 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
- Cuestionario de práctica: 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
- Cuestionario de práctica: Lesson 4-4 Practice Quiz
Cada curso es como un libro de texto interactivo, con videos pregrabados, cuestionarios y proyectos.
Conéctate con miles de estudiantes y debate ideas y materiales del curso, y obtén ayuda para dominar los conceptos.
Obtén reconocimiento oficial por tu trabajo y comparte tu éxito con amigos, compañeros y empleadores.
| Приобрести курс | |
|---|---|
| Получить доступ к материалам курса | Доступен |
| Получить доступ к оцениваемым материалам курса | Доступен |
| Получить итоговую оценку | Доступен |
| 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!
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!