Acerca de este curso: 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.
Enseñado por: Fataneh Taghaboni-Dutta, Clinical Professor of Business Administration
University of Illinois, Urbana-Champaign College of Business Department of Business Administration
| Información básica | Curso 5 de 7 en Managerial Economics and Business Analysis Specialization |
| Nivel | Beginner |
| Compromiso | 4 weeks of study, 4-6 hours/week |
| Idioma | English |
| Cómo aprobar | Aprueba todas las tareas calificadas para completar el curso. |
| Calificaciones del usuario |
- Reading: Syllabus
- Reading: About the Discussion Forums
- Reading: Glossary
- Practice Quiz: Orientation Quiz
- Reading: Using Excel for this Course
- Vídeo: 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
- Vídeo: 1-2.1. Summarizing Data: Frequency Tables
- Vídeo: 1-2.2. Frequency Tables in Excel: Quantitative Data
- Vídeo: 1-2.3. Frequency Tables in Excel: Qualitative Data
- Vídeo: 1-2.4. Presenting Frequency Tables as a Bar Graph in Excel
- Practice Quiz: Lesson 1-2 Practice Quiz
- Vídeo: 1-3.1. Summarizing Data: Histograms
- Vídeo: 1-3.2. Histograms in Excel
- Practice Quiz: Lesson 1-3 Practice Quiz
- Vídeo: 1-4.1. Summarizing Data: Pie Charts
- Vídeo: 1-4.2. Pie Charts in Excel
- Practice Quiz: Lesson 1-4 Practice Quiz
- Vídeo: 1-5.1. Summarizing Data: Scatter Plots
- Vídeo: 1-5.2. Scatter Plots in Excel
- Practice Quiz: Lesson 1-5 Practice Quiz
- Reading: Module 2 Overview
- Reading: Module 2 Readings
- Vídeo: 2-1.2. Mean and Median in Excel
- Practice Quiz: Lesson 2-1 Practice Quiz
- Vídeo: 2-2.1. Measures of Dispersion
- Vídeo: 2-2.2. Standard Deviation in Excel
- Practice Quiz: Lesson 2-2 Practice Quiz
- Vídeo: 2-3.1. Percentiles and Z-Score
- Vídeo: 2-3.2. Z-Score in Excel
- Practice Quiz: Lesson 2-3 Practice Quiz
- Vídeo: 2-4.1. Discrete and Continuous Random Variables
- Vídeo: 2-4.2. Expected Value in Excel
- Practice Quiz: Lesson 2-4 Practice Quiz
- Vídeo: 2-5.1. Normal Distribution
- Vídeo: 2-5.2. Normal Distribution in Excel
- Vídeo: 2-5.3. Standard Normal Distribution in Excel
- Vídeo: 2-5.4. "Less Than" in Excel
- Vídeo: 2-5.5. "Greater Than" in Excel
- Vídeo: 2-5.6. "Between Values" in Excel
- Vídeo: 2-5.7. Finding Z for a Given Probability (INV) in Excel
- Practice Quiz: Lesson 2-5 Practice Quiz
- Vídeo: 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
- Vídeo: 3-2.1. Sampling
- Vídeo: 3-2.2 Sampling Function in Excel
- Practice Quiz: Lesson 3-2 Practice Quiz
- Vídeo: 3-3.1. Central Limit Theorem and Sampling Means
- Vídeo: 3-3.2. Animating the Central Limit Theorem
- Vídeo: 3-3.3. Sampling Distribution and Empirical Rule in Excel
- Practice Quiz: Lesson 3-3 Practice Quiz
- Vídeo: 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
- Vídeo: 4-2.1. Confidence Interval for Means
- Vídeo: 4-2.2. Confience Interval for Mean in Excel
- Vídeo: 4-2.3. Impact of Confidence Level Illustrated in Excel
- Practice Quiz: Lesson 4-2 Practice Quiz
- Vídeo: 4-3.1. Confidence Interval for Population Proportion
- Vídeo: 4-3.2. Confidence Interval for Population Proportion in Excel
- Vídeo: 4-3.3. Confidence Interval Animation in Excel
- Vídeo: 4-3.4. Starting Salary Example in Excel
- Practice Quiz: Lesson 4-3 Practice Quiz
- Vídeo: 4-4.1. Sample Size
- Vídeo: 4-4.2. Sample Size Proportion in Excel
- Vídeo: 4-4.3. Sample Size Mean in Excel
- Vídeo: 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.
| Comprar curso | |
|---|---|
| Accede a los materiales del curso | Disponible |
| Accede a los materiales con calificación | Disponible |
| Recibe una calificación final | Disponible |
| Obtén un Certificado de curso para compartir | Disponible |
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 !!