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 faz parte do Programa de cursos integrados Economia gerencial e análise de negócios
Exploring and Producing Data for Business Decision Making
oferecido por
Programa de cursos integrados Economia gerencial e análise de negócios Universidade de Illinois em Urbana-ChampaignUniversidade de Illinois em Urbana-Champaign
Informações sobre o curso
148,839 visualizações recentes
Resultados de carreira do aprendiz
50%
consegui um benefício significativo de carreira com este curso
50%
recebi um aumento ou promoção
Habilidades que você terá
Data AnalysisMicrosoft ExcelStatistical AnalysisNormal Distribution
Resultados de carreira do aprendiz
50%
consegui um benefício significativo de carreira com este curso
50%
recebi um aumento ou promoção
100% on-line
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. 23 horas para completar
Sugerido: 4 weeks of study, 4-6 hours/week
Inglês
Legendas: Inglês, Coreano, Árabe
oferecido por
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.
Comece a trabalhar rumo ao seu mestrado
Este curso é parte da graduação 100% on-line Master of Business Administration (iMBA) da 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.
Programa - O que você aprenderá com este curso
2 horas 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 horas para concluir
2 vídeos (Total 7 mín.), 6 leituras, 1 teste
2 videos
Excel Data Analysis Toolpak1min
6 leituras
Syllabus10min
ePub10min
About the Discussion Forums4min
Glossary5min
Using Excel for this Course10min
Updating Your Profile10min
1 exercício prático
Orientation Quiz30min
5 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.
5 horas para concluir
11 vídeos (Total 63 mín.), 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 Quiz30min
Lesson 1-2 Practice Quiz30min
Lesson 1-3 Practice Quiz30min
Lesson 1-4 Practice Quiz30min
Lesson 1-5 Practice Quiz30min
Module 1 Quiz30min
7 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.
7 horas para concluir
16 vídeos (Total 107 mín.), 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 Readings1h 15min
7 exercícios práticos
Lesson 2-1 Practice Quiz30min
Lesson 2-2 Practice Quiz30min
Lesson 2-3 Practice Quiz30min
Lesson 2-4 Practice Quiz30min
Lesson 2-5 Practice Quiz30min
Lesson 2-6 Practice Quiz30min
Module 2 Quiz30min
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.
5 horas para concluir
7 vídeos (Total 63 mín.), 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 Quiz30min
Lesson 3-2 Practice Quiz30min
Lesson 3-3 Practice Quiz30min
Lesson 3-4 Practice Quiz30min
Module 3 Quiz30min
5 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.
5 horas para concluir
12 vídeos (Total 97 mín.), 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 Quiz30min
Lesson 4-2 Practice Quiz30min
Lesson 4-3 Practice Quiz30min
Lesson 4-4 Practice Quiz30min
Module 4 Quiz30min
Avaliações
Principais avaliações do EXPLORING AND PRODUCING DATA FOR BUSINESS DECISION MAKING
por DAMay 14, 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 RDJun 1, 2019
Very useful for beginners as well as anyone interested in learning some basics. Highly recommended for managers and people trying to figure out what insights can be obtained form data
por EWApr 18, 2019
This professor does an exceptional job of breaking down complex concepts and calculations without diluting the material. The statistical examples are highly relevant and interesting.
por AOAug 8, 2019
The videos were very explicit and I could practically assimilate the teachings. This also has helped in my career and the skills acquired are been applied appropriately.
por RSApr 20, 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.
por ZOApr 22, 2017
I gained useful insight on data analysis from this course that directly applies to work that I am doing on assessing the accuracy of a new measurement method.
por ZSMay 22, 2017
Excellent production and highly effective teaching! Anyone who deal with number-based business decision making should take this course. Thanks!
por AMOct 22, 2017
Both courses about statistics are great. A lot of useful information and professor gives very detailed explanations with useful examples.
por JFApr 3, 2019
I really enjoyed the course. The professor explained the topics very clearly and made a difficult topic very interesting and compelling.
por APSep 18, 2017
A well-planned course for beginners in Decision Support Systems, I would recommend this course to my peers and students !\n\nThanks
por MFeb 8, 2020
The course was very helpful Fataneh Taghaboni-Dutta has an excellent understanding of the course and explained it well thank you!
por CSMay 14, 2019
Great lectures and great examples and everything in this course worked correctly, unlike in other Coursera courses I have taken.
por YYJun 30, 2019
A good intro course for beginner. For engineers who already took statistical course at school, this course is a little simple.
por NMJun 24, 2019
What can I say, this course is amazing! Ms. Fataneh you will be missed, I hope to find more courses you teach in the future!
por BTApr 5, 2019
Tough, but provides excellent examples along the way that are broken down to create understanding. Very informative course!
por JPApr 7, 2019
Good intro to statistical foundations. Would be great if all questions that involve Excel were in one Excel file
por HPAug 23, 2017
A very well taught course. Prof. Fataneh Taghaboni-Dutta is one of the best professors on the Coursera platform.
por LYApr 9, 2019
This is a very informative course. Easy to follow and understand. Lots of real examples. Strong recommendation.
por MMJan 7, 2018
Clear direction and easy to follow. Great intro to implementing a statistical approach in data analyses.
por MWDec 15, 2019
This is a very useful class, the professor can explain the complex topics in an easy way. Thanks a lot.
Sobre 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.
Perguntas Frequentes – FAQ
Quando terei acesso às palestras e às tarefas?
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.
O que recebo ao me inscrever nesta Especialização?
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.
Qual é a política de reembolso?
Existe algum auxílio financeiro disponível?
Mais dúvidas? Visite o Central de Ajuda ao Aprendiz.