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. The course aim to cover statistical ideas that apply to managers. We will consider two basic themes: first, is recognizing and describing variations present in everything around us, and then modeling and making decisions in the presence of these variations. The fundamental concepts studied in this course will reappear in many other classes and business settings. Our focus will be on interpreting the meaning of the results in a business and managerial setting. 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 use of Excel and using 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: • Test for beliefs about a population.. • Compare differences between populations. • Use linear regression model for prediction. • Learn how to 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 6 of 7 in the Managerial Economics and Business Analysis Specialization |
| Commitment | 4 weeks of study, 2-4 hours/week |
| Language | English |
| How To Pass | Pass all graded assignments to complete the course. |
| User Ratings |
- Reading: Syllabus
- Reading: About the Discussion Forums
- Reading: Glossary
- Practice Quiz: Orientation Quiz
- Reading: Using Excel for this Course
- Video: 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
- Video: 1-2.1. Analyzing the Result
- Practice Quiz: Lesson 1-2 Practice Quiz
- Video: 1-3.1. Two-Tail Test for Mean
- Video: 1-3.2. Two-Tail Test for Mean in Excel
- Practice Quiz: Lesson 1-3 Practice Quiz
- Video: 1-4.1. One-Tail Test for Mean
- Video: 1-4.2. Left-Tail Test for Mean in Excel
- Video: 1-4.3. Right-Tail Test for Mean in Excel
- Practice Quiz: Lesson 1-4 Practice Quiz
- Video: 1-5.1. Testing the Proportion
- Video: 1-5.2. Left-Tail Test for Proportion in Excel
- Video: 1-5.3. Right-Tail Test for Proportion in Excel
- Video: 1-5.4. Two-Tail Test for Proportion in Excel
- Practice Quiz: Lesson 1-5 Practice Quiz
- Reading: Module 2 Overview
- Reading: Module 2 Readings
- Video: 2-1.2. Testing for No Difference in Means in Excel
- Video: 2-1.3. Two-Tail Mean Test for Two Samples and Calculating the Confidence Interval in Excel
- Practice Quiz: Lesson 2-1 Practice Quiz
- Video: 2-2.1. One-Tail Test of the Means
- Video: 2-2.2. One-Tail Test of the Means in Excel
- Practice Quiz: Lesson 2-2 Practice Quiz
- Video: 2-3.1. Testing for a Specific Value in Means
- Practice Quiz: Lesson 2-3 Practice Quiz
- Video: 2-4.1. Paired Tests
- Video: 2-4.2. Paired Test in Excel
- Practice Quiz: Lesson 2-4 Practice Quiz
- Video: 2-5.1. Test of Proportions
- Video: 2-5.2. One-Tail Test of Proportions for Two Samples in Excel
- Video: 2-5.3. Two-Tail Test of Proportions for Two Samples in Excel
- Practice Quiz: Lesson 2-5 Practice Quiz
- Reading: Module 3 Overview
- Reading: Module 3 Readings
- Practice Quiz: Lesson 3-1 Practice Quiz
- Video: 3-2.1. Least Square Methods
- Video: 3-2.2. Least Square Method in Excel
- Practice Quiz: Lesson 3-2 Practice Quiz
- Video: 3-3.1. Assessing the Regression Model
- Video: 3-3.2. Testing the Significance in Excel
- Practice Quiz: Lesson 3-3 Practice Quiz
- Video: 3-4.1. Using the Model
- Video: 3-4.2. Simple Linear Regression: Excel Output Analysis
- Practice Quiz: Lesson 3-4 Practice Quiz
- Video: 3-5.1. Model Assumptions and Limitations
- Video: 3-5.2. Residual Analysis in Excel
- Practice Quiz: Lesson 3-5 Practice Quiz
- Reading: Module 4 Overview
- Reading: Module 4 Readings
- Video: 4-1.2. Developing Multiple Regression Model in Excel
- Video: 4-1.3. Multiple Regression: Excel Output Analysis
- Practice Quiz: Lesson 4-1 Practice Quiz
- Video: 4-2.1. Qualitative Data – Two Categories
- Video: 4-2.2. Dummy Variable in Excel – Two Categories
- Practice Quiz: Lesson 4-2 Practice Quiz
- Video: 4-3.1. Qualitative Data – Many Categories
- Video: 4-3.2. Dummy Variable in Excel – Many Categories
- Practice Quiz: Lesson 4-3 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.
| Purchase Course | |
|---|---|
| Access to course materials | Available |
| Access to graded materials | Available |
| Receive a final grade | Available |
| Earn a shareable Course Certificate | Available |
Very good course. Simple, objective and useful.
Excellent course.
For business students and professionals who really want to understand and apply statistics to their business, there's no better course series that Professor Taghaboni-Dutta's Coursera Series. This course is particularly a unique gem because it integrate statistics lessons into actual practice. The lessons also include great little video clips on how to use Excel to run calculations. Professor Taghaboni-Dutta's lessons are easy to follow and understand; so don't worry, you don't have to be a quant or know calculus to get through this. Just be prepared to spend the time, it's not "statistics light. It's worth the effort!
This class teaches inferential and predictive statistics and the early steps of model building. What really makes this course sizzle is that students also learn how to integrate statistics into business management. Professor Taghaboni-Dutta a phenomenal teacher with a good sense of humor. Students at the UofI campus consistently rank her as one of the best teachers at the school. (How many times have you heard of a statistics professor getting high reviews from students?) I can't imagine how many hours were spent making these videos, but she's thought of everything.
One of my friends is an engineer who has recently moved to management and had been struggling. "They just don't understand anything," she cried. She took the course as part of the iMBA program. She told me that it has helped her learn how to talk with her non-quant executive board and tweak her messaging so that they understand. The course contains tons of of actual real-life problems, such as analyzing Flint Michigan's Drinking water data, testing to find out if a discount store is really the cheapest; figuring out if a marketing plan is working and all sorts of interesting problems.
Honestly, this is a home-run course !
Very well taught and explained. One of the best statistics courses I have taken. As a non math student I have tried many books to understand statistics, but they were all intimidating. This course and the prior course on Exploring Data are my Holy Grail to learning and understanding Statistics. Hats off to the Prof. FATANEH TAGHABONI-DUTTA for the wonderful course and the way she helped approached it.