Informações sobre o curso
4.8
249 classificações
56 avaliações

100% online

Comece imediatamente e aprenda em seu próprio cronograma.

Prazos flexíveis

Redefinir os prazos de acordo com sua programação.

Nível iniciante

Aprox. 20 horas para completar

Sugerido: 4 weeks of study, 4-6 hours/week...

Inglês

Legendas: Inglês, Árabe

Habilidades que você terá

Data AnalysisMicrosoft ExcelStatistical AnalysisNormal Distribution

100% online

Comece imediatamente e aprenda em seu próprio cronograma.

Prazos flexíveis

Redefinir os prazos de acordo com sua programação.

Nível iniciante

Aprox. 20 horas para completar

Sugerido: 4 weeks of study, 4-6 hours/week...

Inglês

Legendas: Inglês, Árabe

Programa - O que você aprenderá com este curso

Semana
1
1 hora para concluir

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 vídeos (total de (Total 7 mín.) min), 6 leituras, 1 teste
2 videos
Excel Data Analysis Toolpak1min
6 leituras
Syllabus10min
About the Discussion Forums4min
Glossary5min
Using Excel for this Course10min
Updating Your Profile10min
Social Media4min
1 exercício prático
Orientation Quiz10min
3 horas para concluir

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....
11 vídeos (total de (Total 63 mín.) min), 2 leituras, 6 testes
11 videos
1-2.1. Summarizing Data: Frequency Tables7min
1-2.2. Frequency Tables in Excel: Quantitative Data6min
1-2.3. Frequency Tables in Excel: Qualitative Data6min
1-2.4. Presenting Frequency Tables as a Bar Graph in Excel2min
1-3.1. Summarizing Data: Histograms5min
1-3.2. Histograms in Excel7min
1-4.1. Summarizing Data: Pie Charts4min
1-4.2. Pie Charts in Excel5min
1-5.1. Summarizing Data: Scatter Plots4min
1-5.2. Scatter Plots in Excel4min
2 leituras
Module 1 Overview3min
Module 1 Readings45min
6 exercícios práticos
Lesson 1-1 Practice Quiz6min
Lesson 1-2 Practice Quiz10min
Lesson 1-3 Practice Quiz8min
Lesson 1-4 Practice Quiz8min
Lesson 1-5 Practice Quiz8min
Module 1 Quiz38min
Semana
2
4 horas para concluir

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....
16 vídeos (total de (Total 107 mín.) min), 2 leituras, 7 testes
16 videos
2-1.2. Mean and Median in Excel3min
2-2.1. Measures of Dispersion9min
2-2.2. Standard Deviation in Excel2min
2-3.1. Percentiles and Z-Score13min
2-3.2. Z-Score in Excel5min
2-4.1. Discrete and Continuous Random Variables11min
2-4.2. Expected Value in Excel6min
2-5.1. Normal Distribution10min
2-5.2. Normal Distribution in Excel5min
2-5.3. Standard Normal Distribution in Excel4min
2-5.4. "Less Than" in Excel1min
2-5.5. "Greater Than" in Excel1min
2-5.6. "Between Values" in Excel1min
2-5.7. Finding Z for a Given Probability (INV) in Excel3min
2-6.1. Standard Normal Distribution Table14min
2 leituras
Module 2 Overview3min
Module 2 Readings15min
7 exercícios práticos
Lesson 2-1 Practice Quiz6min
Lesson 2-2 Practice Quiz8min
Lesson 2-3 Practice Quiz6min
Lesson 2-4 Practice Quiz6min
Lesson 2-5 Practice Quiz6min
Lesson 2-6 Practice Quiz6min
Module 2 Quiz30min
Semana
3
5 horas para concluir

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....
7 vídeos (total de (Total 63 mín.) min), 2 leituras, 6 testes
7 videos
3-2.1. Sampling14min
3-2.2 Sampling Function in Excel6min
3-3.1. Central Limit Theorem and Sampling Means9min
3-3.2. Animating the Central Limit Theorem6min
3-3.3. Sampling Distribution and Empirical Rule in Excel11min
3-4.1. Central Limit Theorem – Sampling Proportion5min
2 leituras
Module 3 Overview3min
Module 3 Readings30min
5 exercícios práticos
Lesson 3-1 Practice Quiz8min
Lesson 3-2 Practice Quiz8min
Lesson 3-3 Practice Quiz6min
Lesson 3-4 Practice Quiz6min
Module 3 Quiz44min
Semana
4
3 horas para concluir

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....
12 vídeos (total de (Total 97 mín.) min), 2 leituras, 5 testes
12 videos
4-2.1. Confidence Interval for Means9min
4-2.2. Confidence Interval for Mean in Excel8min
4-2.3. Impact of Confidence Level Illustrated in Excel4min
4-3.1. Confidence Interval for Population Proportion10min
4-3.2. Confidence Interval for Population Proportion in Excel8min
4-3.3. Confidence Interval Animation in Excel5min
4-3.4. Starting Salary Example in Excel7min
4-4.1. Sample Size9min
4-4.2. Sample Size Proportion in Excel3min
4-4.3. Sample Size Mean in Excel7min
4-4.4. Sample Size Effect in Excel5min
2 leituras
Module 4 Overview3min
Module 4 Readings20min
5 exercícios práticos
Lesson 4-1 Practice Quiz6min
Lesson 4-2 Practice Quiz6min
Lesson 4-3 Practice Quiz6min
Lesson 4-4 Practice Quiz8min
Module 4 Quiz20min
4.8
56 avaliaçõesChevron Right

50%

consegui um benefício significativo de carreira com este curso

50%

recebi um aumento ou promoção

Melhores avaliações

por DAMay 15th 2018

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!

por RSApr 21st 2018

In my opinion, this is a good course. The content really aims at teaching how to better understand and use statistics. In the end, I am glad that I chose this course.

Instrutores

Avatar

Fataneh Taghaboni-Dutta

Clinical Professor of Business Administration
University of Illinois, Urbana-Champaign College of Business Department of Business Administration

Comece a trabalhar rumo ao seu mestrado

Este curso é parte de uma graduação 100% on-line Master of Business Administration (iMBA) pela Universidade de Illinois em Urbana-ChampaignUniversidade de Illinois em Urbana-Champaign. Caso seja aceito para o programa completo, seus cursos contarão para sua graduação.

Sobre Universidade de Illinois em Urbana-ChampaignUniversidade de Illinois em 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. ...

Sobre o Programa de cursos integrados Economia gerencial e análise de negócios

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....
Economia gerencial e análise de negócios

Perguntas Frequentes – FAQ

  • Ao se inscrever para um Certificado, você terá acesso a todos os vídeos, testes e tarefas de programação (se aplicável). Tarefas avaliadas pelos colegas apenas podem ser enviadas e avaliadas após o início da sessão. Caso escolha explorar o curso sem adquiri-lo, talvez você não consiga acessar certas tarefas.

  • Quando você se inscreve no curso, tem acesso a todos os cursos na Especialização e pode obter um certificado quando concluir o trabalho. Seu Certificado eletrônico será adicionado à sua página de Participações e você poderá imprimi-lo ou adicioná-lo ao seu perfil no LinkedIn. Se quiser apenas ler e assistir o conteúdo do curso, você poderá frequentá-lo como ouvinte sem custo.

Mais dúvidas? Visite o Central de Ajuda ao Aprendiz.