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. 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.
Creada por: Universidad de Illinois en Urbana-Champaign
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 6 de 7 en Managerial Economics and Business Analysis Specialization |
| Compromiso | 4 weeks of study, 2-4 hours/week |
| Idioma | English |
| Cómo aprobar | Aprueba todas las tareas calificadas para completar el curso. |
| Calificaciones del usuario |
Completa este curso para conseguir:
Programa Especializado - Managerial Economics and Business Analysis
Este curso es parte del Programa especializado Managerial Economics and Business Analysis de Universidad de Illinois en Urbana-Champaign del curso 7
Master of Business Administration (iMBA)
El curso forma parte del programa de títulos 18 courses plus three capstone projects totalmente en línea
Programa
SEMANA 1
Course Orientation
In the course orientation, you will become familiar with the course, your classmates, and our learning environment. The orientation will also help you obtain the technical skills required for the course.
2 videos, 6 readings, 1 practice quiz
- 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
Module 1: Hypothesis Testing
Watch any infomercial and you hear many outrageous promises. Use this cream and your skin will look 80% firmer! Use this supplement and you will lose 10 pounds in the first 10 days! Are they telling you the truth? Are they all lying? The only way to know the answer to any of these questions is to scientifically test the claim being made – that is what we call hypothesis testing and what we will learn in this module.
11 videos, 2 readings, 5 practice quizzes
- Reading: Module 1 Overview
- Reading: Module 1 Readings
- Practice Quiz: Lesson 1-1 Practice Quiz
- Vídeo: 1-2.1. Analyzing the Result
- Practice Quiz: Lesson 1-2 Practice Quiz
- Vídeo: 1-3.1. Two-Tail Test for Mean
- Vídeo: 1-3.2. Two-Tail Test for Mean in Excel
- Practice Quiz: Lesson 1-3 Practice Quiz
- Vídeo: 1-4.1. One-Tail Test for Mean
- Vídeo: 1-4.2. Left-Tail Test for Mean in Excel
- Vídeo: 1-4.3. Right-Tail Test for Mean in Excel
- Practice Quiz: Lesson 1-4 Practice Quiz
- Vídeo: 1-5.1. Testing the Proportion
- Vídeo: 1-5.2. Left-Tail Test for Proportion in Excel
- Vídeo: 1-5.3. Right-Tail Test for Proportion in Excel
- Vídeo: 1-5.4. Two-Tail Test for Proportion in Excel
- Practice Quiz: Lesson 1-5 Practice Quiz
Calificado: Module 1 Quiz
SEMANA 2
Module 2: Statistical Inference Based on Two Samples
Does the medicine a person is taking to treat his condition really work better than a sugar pill? Is the new chip-enabled credit card more secure than the magnetic card? How do you know whether the claims being made about anything being “better than” or “faster than” a competitor are true? In this module we will learn to make this comparison.
11 videos, 2 readings, 5 practice quizzes
- Reading: Module 2 Overview
- Reading: Module 2 Readings
- Vídeo: 2-1.2. Testing for No Difference in Means in Excel
- Vídeo: 2-1.3. Two-Tail Mean Test for Two Samples and Calculating the Confidence Interval in Excel
- Practice Quiz: Lesson 2-1 Practice Quiz
- Vídeo: 2-2.1. One-Tail Test of the Means
- Vídeo: 2-2.2. One-Tail Test of the Means in Excel
- Practice Quiz: Lesson 2-2 Practice Quiz
- Vídeo: 2-3.1. Testing for a Specific Value in Means
- Practice Quiz: Lesson 2-3 Practice Quiz
- Vídeo: 2-4.1. Paired Tests
- Vídeo: 2-4.2. Paired Test in Excel
- Practice Quiz: Lesson 2-4 Practice Quiz
- Vídeo: 2-5.1. Test of Proportions
- Vídeo: 2-5.2. One-Tail Test of Proportions for Two Samples in Excel
- Vídeo: 2-5.3. Two-Tail Test of Proportions for Two Samples in Excel
- Practice Quiz: Lesson 2-5 Practice Quiz
Calificado: Module 2 Quiz
Calificado: Inferential and Predictive Statistics Peer Review Assignment
SEMANA 3
Module 3: Simple Linear Regression
Does your job involve a lot of sitting? If so, you are at higher risk of coronary heart disease. How do I know this? We got to know the relationship between coronary heart disease and sitting when researchers studied a cohort of London bus drivers and bus conductors from 1947 to 1972. If you want to know more, then read on!
9 videos, 2 readings, 5 practice quizzes
- Reading: Module 3 Overview
- Reading: Module 3 Readings
- Practice Quiz: Lesson 3-1 Practice Quiz
- Vídeo: 3-2.1. Least Square Methods
- Vídeo: 3-2.2. Least Square Method in Excel
- Practice Quiz: Lesson 3-2 Practice Quiz
- Vídeo: 3-3.1. Assessing the Regression Model
- Vídeo: 3-3.2. Testing the Significance in Excel
- Practice Quiz: Lesson 3-3 Practice Quiz
- Vídeo: 3-4.1. Using the Model
- Vídeo: 3-4.2. Simple Linear Regression: Excel Output Analysis
- Practice Quiz: Lesson 3-4 Practice Quiz
- Vídeo: 3-5.1. Model Assumptions and Limitations
- Vídeo: 3-5.2. Residual Analysis in Excel
- Practice Quiz: Lesson 3-5 Practice Quiz
Calificado: Module 3 Quiz
SEMANA 4
Module 4: Multiple Linear Regression
You are trying to predict next month’s sales numbers. You know that dozens, maybe even hundreds, of things like the weather, competitor’s promotions, rumors, etc. can impact the number. You talk to five people and each one has an idea about what makes the biggest impact, and the only thing they offer is “trust me.” Do you wish there was a better way of doing this rather than relying on blind faith? Well, there is. We can use Multiple Regression to sort through this mess and bring the focus to factors that really do matter.
7 videos, 2 readings, 3 practice quizzes
- Reading: Module 4 Overview
- Reading: Module 4 Readings
- Vídeo: 4-1.2. Developing Multiple Regression Model in Excel
- Vídeo: 4-1.3. Multiple Regression: Excel Output Analysis
- Practice Quiz: Lesson 4-1 Practice Quiz
- Vídeo: 4-2.1. Qualitative Data – Two Categories
- Vídeo: 4-2.2. Dummy Variable in Excel – Two Categories
- Practice Quiz: Lesson 4-2 Practice Quiz
- Vídeo: 4-3.1. Qualitative Data – Many Categories
- Vídeo: 4-3.2. Dummy Variable in Excel – Many Categories
- Practice Quiz: Lesson 4-3 Practice Quiz
Calificado: Module 4 Quiz
Preguntas Frecuentes
Cómo funciona
Coursework
Each course is like an interactive textbook, featuring pre-recorded videos, quizzes and projects.
Help from Your Peers
Connect with thousands of other learners and debate ideas, discuss course material, and get help mastering concepts.
Certificates
Earn official recognition for your work, and share your success with friends, colleagues, and employers.
Creadores
Universidad de Illinois en Urbana-Champaign
The University of Illinois at Urbana-Champaign is a world leader in research, teaching and public engagement, distinguished by the breadth of its programs, broad academic excellence, and internationally renowned faculty and alumni. Illinois serves the world by creating knowledge, preparing students for lives of impact, and finding solutions to critical societal needs.
Tarifa
| 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 |
Calificaciones y revisiones
very well organized !!
Great Professor and a very interesting class! The possibilities are endless for regression testing.
Amazing experience
Coursera brinda acceso universal a la mejor educación del mundo, al asociarse con las mejores universidades y organizaciones, para ofrecer cursos en línea.
© 2018 Coursera Inc. Todos los derechos reservados.
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 !