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.
管理经济学和商业分析 專項課程伊利诺伊大学香槟分校課程信息
194,644 次近期查看
學生職業成果
50%
通過此課程獲得實實在在的工作福利
50%
加薪或升職
可分享的證書
完成後獲得證書
100% 在線
立即開始，按照自己的計劃學習。
第 5 門課程（共 7 門）
可靈活調整截止日期
根據您的日程表重置截止日期。
初級
完成時間大約為23 小時
英語（English）
字幕：英語（English）, 韓語, 阿拉伯語（Arabic）
您將獲得的技能
Data AnalysisMicrosoft ExcelStatistical AnalysisNormal Distribution
學生職業成果
50%
通過此課程獲得實實在在的工作福利
50%
加薪或升職
可分享的證書
完成後獲得證書
100% 在線
立即開始，按照自己的計劃學習。
第 5 門課程（共 7 門）
可靈活調整截止日期
根據您的日程表重置截止日期。
初級
完成時間大約為23 小時
英語（English）
字幕：英語（English）, 韓語, 阿拉伯語（Arabic）
提供方
伊利诺伊大学香槟分校
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.
立即開始攻讀碩士學位
此 課程 隸屬於 伊利诺伊大学香槟分校 提供的 100% 在線 Master of Business Administration (iMBA)。如果您被錄取參加全部課程，您的課程將計入您的學位學習進程。
教學大綱 - 您將從這門課程中學到什麼
完成時間為 2 小時
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 小時
2 個視頻 （總計 7 分鐘）, 6 個閱讀材料, 1 個測驗
2 個視頻
Excel Data Analysis Toolpak1分鐘
6 個閱讀材料
Syllabus10分鐘
ePub10分鐘
About the Discussion Forums4分鐘
Glossary5分鐘
Using Excel for this Course10分鐘
Updating Your Profile10分鐘
1 個練習
Orientation Quiz30分鐘
完成時間為 5 小時
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 小時
11 個視頻 （總計 63 分鐘）, 2 個閱讀材料, 6 個測驗
11 個視頻
1-2.1. Summarizing Data: Frequency Tables7分鐘
1-2.2. Frequency Tables in Excel: Quantitative Data6分鐘
1-2.3. Frequency Tables in Excel: Qualitative Data6分鐘
1-2.4. Presenting Frequency Tables as a Bar Graph in Excel2分鐘
1-3.1. Summarizing Data: Histograms5分鐘
1-3.2. Histograms in Excel7分鐘
1-4.1. Summarizing Data: Pie Charts4分鐘
1-4.2. Pie Charts in Excel5分鐘
1-5.1. Summarizing Data: Scatter Plots4分鐘
1-5.2. Scatter Plots in Excel4分鐘
2 個閱讀材料
Module 1 Overview3分鐘
Module 1 Readings45分鐘
6 個練習
Lesson 1-1 Practice Quiz30分鐘
Lesson 1-2 Practice Quiz30分鐘
Lesson 1-3 Practice Quiz30分鐘
Lesson 1-4 Practice Quiz30分鐘
Lesson 1-5 Practice Quiz30分鐘
Module 1 Quiz30分鐘
完成時間為 7 小時
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 小時
16 個視頻 （總計 107 分鐘）, 2 個閱讀材料, 7 個測驗
16 個視頻
2-1.2. Mean and Median in Excel3分鐘
2-2.1. Measures of Dispersion9分鐘
2-2.2. Standard Deviation in Excel2分鐘
2-3.1. Percentiles and Z-Score13分鐘
2-3.2. Z-Score in Excel5分鐘
2-4.1. Discrete and Continuous Random Variables11分鐘
2-4.2. Expected Value in Excel6分鐘
2-5.1. Normal Distribution10分鐘
2-5.2. Normal Distribution in Excel5分鐘
2-5.3. Standard Normal Distribution in Excel4分鐘
2-5.4. "Less Than" in Excel1分鐘
2-5.5. "Greater Than" in Excel1分鐘
2-5.6. "Between Values" in Excel1分鐘
2-5.7. Finding Z for a Given Probability (INV) in Excel3分鐘
2-6.1. Standard Normal Distribution Table14分鐘
2 個閱讀材料
Module 2 Overview3分鐘
Module 2 Readings1 小時 15 分
7 個練習
Lesson 2-1 Practice Quiz30分鐘
Lesson 2-2 Practice Quiz30分鐘
Lesson 2-3 Practice Quiz30分鐘
Lesson 2-4 Practice Quiz30分鐘
Lesson 2-5 Practice Quiz30分鐘
Lesson 2-6 Practice Quiz30分鐘
Module 2 Quiz30分鐘
完成時間為 5 小時
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 小時
7 個視頻 （總計 63 分鐘）, 2 個閱讀材料, 6 個測驗
7 個視頻
3-2.1. Sampling14分鐘
3-2.2 Sampling Function in Excel6分鐘
3-3.1. Central Limit Theorem and Sampling Means9分鐘
3-3.2. Animating the Central Limit Theorem6分鐘
3-3.3. Sampling Distribution and Empirical Rule in Excel11分鐘
3-4.1. Central Limit Theorem – Sampling Proportion5分鐘
2 個閱讀材料
Module 3 Overview3分鐘
Module 3 Readings30分鐘
5 個練習
Lesson 3-1 Practice Quiz30分鐘
Lesson 3-2 Practice Quiz30分鐘
Lesson 3-3 Practice Quiz30分鐘
Lesson 3-4 Practice Quiz30分鐘
Module 3 Quiz30分鐘
完成時間為 5 小時
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 小時
13 個視頻 （總計 101 分鐘）, 3 個閱讀材料, 5 個測驗
13 個視頻
4-2.1. Confidence Interval for Means9分鐘
4-2.2. Confidence Interval for Mean in Excel8分鐘
4-2.3. Impact of Confidence Level Illustrated in Excel4分鐘
4-3.1. Confidence Interval for Population Proportion10分鐘
4-3.2. Confidence Interval for Population Proportion in Excel8分鐘
4-3.3. Confidence Interval Animation in Excel5分鐘
4-3.4. Starting Salary Example in Excel7分鐘
4-4.1. Sample Size9分鐘
4-4.2. Sample Size Proportion in Excel3分鐘
4-4.3. Sample Size Mean in Excel7分鐘
4-4.4. Sample Size Effect in Excel5分鐘
Gies Online Programs3分鐘
3 個閱讀材料
Module 4 Overview3分鐘
Module 4 Readings20分鐘
Congratulations!10分鐘
5 個練習
Lesson 4-1 Practice Quiz30分鐘
Lesson 4-2 Practice Quiz30分鐘
Lesson 4-3 Practice Quiz30分鐘
Lesson 4-4 Practice Quiz30分鐘
Module 4 Quiz30分鐘
審閱
來自EXPLORING AND PRODUCING DATA FOR BUSINESS DECISION MAKING的熱門評論
由 DA 提供2018年5月14日
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!
由 OA 提供2020年9月4日
The class was difficult . The professor is demanding and very knowledgeable. She makes sure you learn the material and that you understand it. I learned a lot and I am very happy I took this class.
由 RD 提供2019年6月1日
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
由 EW 提供2019年4月18日
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.
關於 管理经济学和商业分析 專項課程
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.
常見問題
我什么时候能够访问课程视频和作业？
讲座和作业的访问权限取决于您的注册类型。如果您以旁听模式参加课程，则可以免费查看大多数课程资料。要访问评分作业并获得证书，您需要在旁听期间或之后购买证书体验。如果看不到旁听选项：
- 课程可能不提供旁听选项。您可以尝试免费试用，也可以申请助学金。
- 课程可能会改为提供'完整课程，没有证书'。通过此选项，您可以查看所有课程材料、提交所要求的作业，以及获得最终成绩。这也意味着您将无法购买证书体验。
我订阅此专项课程后会得到什么？
您注册课程后，将有权访问专项课程中的所有课程，并且会在完成课程后获得证书。您的电子课程证书将添加到您的成就页中，您可以通过该页打印您的课程证书或将其添加到您的领英档案中。如果您只想阅读和查看课程内容，可以免费旁听课程。
Is financial aid available?
是的，Coursera 可以为无法承担费用的学生提供助学金。通过点击左侧“注册”按钮下的“助学金”链接可以申请助学金。您可以根据屏幕提示完成申请，申请获批后会收到通知。您需要针对专项课程中的每一门课程完成上述步骤，包括毕业项目。了解更多。
還有其他問題嗎？請訪問 學生幫助中心。
