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.
Este curso forma parte de Programa Especializado - Managerial Economics and Business Analysis
ofrecido por
Programa Especializado - Managerial Economics and Business Analysis Universidad de Illinois en Urbana-ChampaignAcerca de este Curso
81,453 vistas recientes
Resultados profesionales del estudiante
50%
consiguió un beneficio tangible en su carrera profesional gracias a este curso
50%
consiguió un aumento de sueldo o ascenso
Certificado para compartir
Obtén un certificado al finalizar
100 % en línea
Comienza de inmediato y aprende a tu propio ritmo.
Fechas límite flexibles
Restablece las fechas límite en función de tus horarios.
Nivel principiante
Aprox. 23 horas para completar
Inglés (English)
Subtítulos: Inglés (English), Coreano, Árabe (Arabic)
Habilidades que obtendrás
Data AnalysisMicrosoft ExcelStatistical AnalysisNormal Distribution
Resultados profesionales del estudiante
50%
consiguió un beneficio tangible en su carrera profesional gracias a este curso
50%
consiguió un aumento de sueldo o ascenso
Certificado para compartir
Obtén un certificado al finalizar
100 % en línea
Comienza de inmediato y aprende a tu propio ritmo.
Fechas límite flexibles
Restablece las fechas límite en función de tus horarios.
Nivel principiante
Aprox. 23 horas para completar
Inglés (English)
Subtítulos: Inglés (English), Coreano, Árabe (Arabic)
ofrecido por
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.
Comienza a trabajar para obtener tu maestría
Este curso es parte del Master of Business Administration (iMBA) completamente en línea de Universidad de Illinois en Urbana-Champaign.
Si eres aceptado en el programa completo, tus cursos cuentan para tu título.
Programa - Qué aprenderás en este curso
2 horas para completar
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 horas para completar
2 videos (Total 7 minutos), 6 lecturas, 1 cuestionario
2 videos
Excel Data Analysis Toolpak1m
6 lecturas
Syllabus10m
ePub10m
About the Discussion Forums4m
Glossary5m
Using Excel for this Course10m
Updating Your Profile10m
1 ejercicio de práctica
Orientation Quiz30m
5 horas para completar
Module 1: Introduction and Summarizing Data
Data is all around you, but what is the data telling you? The first step in making better decisions and taking action is to get a good understanding of information you have gathered. In this module we will learn about some of the tools in statistics that help us achieve this.
5 horas para completar
11 videos (Total 63 minutos), 2 lecturas, 6 cuestionarios
11 videos
1-2.1. Summarizing Data: Frequency Tables7m
1-2.2. Frequency Tables in Excel: Quantitative Data6m
1-2.3. Frequency Tables in Excel: Qualitative Data6m
1-2.4. Presenting Frequency Tables as a Bar Graph in Excel2m
1-3.1. Summarizing Data: Histograms5m
1-3.2. Histograms in Excel7m
1-4.1. Summarizing Data: Pie Charts4m
1-4.2. Pie Charts in Excel5m
1-5.1. Summarizing Data: Scatter Plots4m
1-5.2. Scatter Plots in Excel4m
2 lecturas
Module 1 Overview3m
Module 1 Readings45m
6 ejercicios de práctica
Lesson 1-1 Practice Quiz30m
Lesson 1-2 Practice Quiz30m
Lesson 1-3 Practice Quiz30m
Lesson 1-4 Practice Quiz30m
Lesson 1-5 Practice Quiz30m
Module 1 Quiz30m
7 horas para completar
Module 2: Descriptive Statistics and Probability Distributions
We all have heard the phrase that a "picture is worth a thousand words," but you certainly don’t want one of those to be "what exactly am I looking at?" So, now that you know to use "pictures" to summarize your data, let’s make those pictures easier to understand.
7 horas para completar
16 videos (Total 107 minutos), 2 lecturas, 7 cuestionarios
16 videos
2-1.2. Mean and Median in Excel3m
2-2.1. Measures of Dispersion9m
2-2.2. Standard Deviation in Excel2m
2-3.1. Percentiles and Z-Score13m
2-3.2. Z-Score in Excel5m
2-4.1. Discrete and Continuous Random Variables11m
2-4.2. Expected Value in Excel6m
2-5.1. Normal Distribution10m
2-5.2. Normal Distribution in Excel5m
2-5.3. Standard Normal Distribution in Excel4m
2-5.4. "Less Than" in Excel1m
2-5.5. "Greater Than" in Excel1m
2-5.6. "Between Values" in Excel1m
2-5.7. Finding Z for a Given Probability (INV) in Excel3m
2-6.1. Standard Normal Distribution Table14m
2 lecturas
Module 2 Overview3m
Module 2 Readings1h 15m
7 ejercicios de práctica
Lesson 2-1 Practice Quiz30m
Lesson 2-2 Practice Quiz30m
Lesson 2-3 Practice Quiz30m
Lesson 2-4 Practice Quiz30m
Lesson 2-5 Practice Quiz30m
Lesson 2-6 Practice Quiz30m
Module 2 Quiz30m
5 horas para completar
Module 3: Sampling and Central Limit Theorem
You are charged with analyzing a market segment for your company. You and your team have figured out what variables you need to understand; you also have an idea what factors might be influencing these variables of interest. Now you are ready to do your analysis. But, wait! Where is the data? How do you begin to get the data? In this module we will review the means by which you can begin to produce data – the concepts of sampling and Central Limit Theorem – and will help you understand how to produce "good" sample data and why sample data will work.
5 horas para completar
7 videos (Total 63 minutos), 2 lecturas, 6 cuestionarios
7 videos
3-2.1. Sampling14m
3-2.2 Sampling Function in Excel6m
3-3.1. Central Limit Theorem and Sampling Means9m
3-3.2. Animating the Central Limit Theorem6m
3-3.3. Sampling Distribution and Empirical Rule in Excel11m
3-4.1. Central Limit Theorem – Sampling Proportion5m
2 lecturas
Module 3 Overview3m
Module 3 Readings30m
5 ejercicios de práctica
Lesson 3-1 Practice Quiz30m
Lesson 3-2 Practice Quiz30m
Lesson 3-3 Practice Quiz30m
Lesson 3-4 Practice Quiz30m
Module 3 Quiz30m
5 horas para completar
Module 4: Inference
You have sample data and have done the analysis – you think you can say something about the population based on your sample study. But, do you have a sense of what are the chances of you being right or wrong? How can you be surer? What else should you have considered? In this module, you will learn how to find the answers to these questions.
5 horas para completar
12 videos (Total 97 minutos), 2 lecturas, 5 cuestionarios
12 videos
4-2.1. Confidence Interval for Means9m
4-2.2. Confidence Interval for Mean in Excel8m
4-2.3. Impact of Confidence Level Illustrated in Excel4m
4-3.1. Confidence Interval for Population Proportion10m
4-3.2. Confidence Interval for Population Proportion in Excel8m
4-3.3. Confidence Interval Animation in Excel5m
4-3.4. Starting Salary Example in Excel7m
4-4.1. Sample Size9m
4-4.2. Sample Size Proportion in Excel3m
4-4.3. Sample Size Mean in Excel7m
4-4.4. Sample Size Effect in Excel5m
2 lecturas
Module 4 Overview3m
Module 4 Readings20m
5 ejercicios de práctica
Lesson 4-1 Practice Quiz30m
Lesson 4-2 Practice Quiz30m
Lesson 4-3 Practice Quiz30m
Lesson 4-4 Practice Quiz30m
Module 4 Quiz30m
Acerca de Programa especializado: Managerial Economics and Business Analysis
In order to effectively manage and operate a business, managers and leaders need to understand the market characteristics and economic environment they operate in. In this Specialization, you will build a solid understanding of the operation of markets and the macro-economic environment with real-world examples. You will be able to identify firm and country-level economic factors that impact business decisions, develop an analytical framework using statistical tools, and apply economic theory and data in the analysis of business environment and trends to make effective business decisions.
The capstone project involves an in-depth analysis of an actual business situation in which you will examine the global economic environment of a business. The final project will be a business plan that uses statistical tools and economic theory to create a comprehensive analysis of the microeconomic and macroeconomic environment in which the focal company operates.
This Specialization is part of the University of Illinois Masters of Business Administration degree program, the iMBA. Learn more about the admission into the program here and how your Coursera work can be leveraged if accepted into the program. You can also start with for-credit courses within the Illinois iMBA degree program.
Preguntas Frecuentes
¿Cuándo podré acceder a las lecciones y tareas?
Una vez que te inscribes para obtener un Certificado, tendrás acceso a todos los videos, cuestionarios y tareas de programación (si corresponde). Las tareas calificadas por compañeros solo pueden enviarse y revisarse una vez que haya comenzado tu sesión. Si eliges explorar el curso sin comprarlo, es posible que no puedas acceder a determinadas tareas.
¿Qué recibiré si me suscribo a este Programa especializado?
Cuando te inscribes en un curso, obtienes acceso a todos los cursos que forman parte del Programa especializado y te darán un Certificado cuando completes el trabajo. Se añadirá tu Certificado electrónico a la página Logros. Desde allí, puedes imprimir tu Certificado o añadirlo a tu perfil de LinkedIn. Si solo quieres leer y visualizar el contenido del curso, puedes auditar el curso sin costo.
¿Cuál es la política de reembolsos?
Si estás suscrito, obtienes una prueba gratis de 7 días, que podrás cancelar cuando desees sin ningún tipo de penalidad. Una vez transcurrido ese tiempo, no realizamos reembolsos. No obstante, puedes cancelar tu suscripción cuando quieras. Consulta nuestra política completa de reembolsos.
¿Hay ayuda económica disponible?
Sí, Coursera ofrece ayuda económica a los estudiantes que no pueden pagar la tarifa. Solicítala haciendo clic en el enlace de Ayuda económica que está debajo del botón “Inscribirse” a la izquierda. Se te pedirá que completes una solicitud. Recibirás una notificación en caso de que se apruebe. Deberás completar este paso para cada uno de los cursos que forman parte del Programa especializado, incluido el proyecto final. Obtén más información.
¿Tienes más preguntas? Visita el Centro de Ayuda al Alumno.