课程信息
11,399 次近期查看

第 5 门课程(共 7 门)

100% 在线

立即开始,按照自己的计划学习。

可灵活调整截止日期

根据您的日程表重置截止日期。

初级

完成时间大约为22 小时

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

英语(English)

字幕:英语(English), 阿拉伯语(Arabic)

您将获得的技能

Data AnalysisMicrosoft ExcelStatistical AnalysisNormal Distribution

第 5 门课程(共 7 门)

100% 在线

立即开始,按照自己的计划学习。

可灵活调整截止日期

根据您的日程表重置截止日期。

初级

完成时间大约为22 小时

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

英语(English)

字幕:英语(English), 阿拉伯语(Arabic)

教学大纲 - 您将从这门课程中学到什么

1
完成时间为 1 小时

Course Orientation

2 个视频 (总计 7 分钟), 5 个阅读材料, 1 个测验
5 个阅读材料
Syllabus10分钟
About the Discussion Forums4分钟
Glossary5分钟
Using Excel for this Course10分钟
Updating Your Profile10分钟
1 个练习
Orientation Quiz10分钟
完成时间为 3 小时

Module 1: Introduction and Summarizing Data

11 个视频 (总计 63 分钟), 2 个阅读材料, 6 个测验
11 个视频
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 Quiz6分钟
Lesson 1-2 Practice Quiz10分钟
Lesson 1-3 Practice Quiz8分钟
Lesson 1-4 Practice Quiz8分钟
Lesson 1-5 Practice Quiz8分钟
Module 1 Quiz38分钟
2
完成时间为 4 小时

Module 2: Descriptive Statistics and Probability Distributions

16 个视频 (总计 107 分钟), 2 个阅读材料, 7 个测验
16 个视频
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 Quiz6分钟
Lesson 2-2 Practice Quiz8分钟
Lesson 2-3 Practice Quiz6分钟
Lesson 2-4 Practice Quiz6分钟
Lesson 2-5 Practice Quiz6分钟
Lesson 2-6 Practice Quiz6分钟
Module 2 Quiz30分钟
3
完成时间为 5 小时

Module 3: Sampling and Central Limit Theorem

7 个视频 (总计 63 分钟), 2 个阅读材料, 6 个测验
7 个视频
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 Quiz8分钟
Lesson 3-2 Practice Quiz8分钟
Lesson 3-3 Practice Quiz6分钟
Lesson 3-4 Practice Quiz6分钟
Module 3 Quiz44分钟
4
完成时间为 3 小时

Module 4: Inference

12 个视频 (总计 97 分钟), 2 个阅读材料, 5 个测验
12 个视频
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分钟
2 个阅读材料
Module 4 Overview3分钟
Module 4 Readings20分钟
5 个练习
Lesson 4-1 Practice Quiz6分钟
Lesson 4-2 Practice Quiz6分钟
Lesson 4-3 Practice Quiz6分钟
Lesson 4-4 Practice Quiz8分钟
Module 4 Quiz20分钟
4.8
78 个审阅Chevron Right

50%

通过此课程获得实实在在的工作福利

50%

加薪或升职

来自Exploring and Producing Data for Business Decision Making的热门评论

创建者 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!

创建者 RDJun 2nd 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

讲师

Avatar

Fataneh Taghaboni-Dutta

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

立即开始攻读硕士学位

此 课程 隶属于 伊利诺伊大学香槟分校 提供的 100% 在线 Master of Business Administration (iMBA)。如果您被录取参加全部课程,您的课程将计入您的学位学习进程。

关于 伊利诺伊大学香槟分校

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. ...

关于 管理经济学和商业分析 专项课程

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....
管理经济学和商业分析

常见问题

  • 注册以便获得证书后,您将有权访问所有视频、测验和编程作业(如果适用)。只有在您的班次开课之后,才可以提交和审阅同学互评作业。如果您选择在不购买的情况下浏览课程,可能无法访问某些作业。

  • 您注册课程后,将有权访问专项课程中的所有课程,并且会在完成课程后获得证书。您的电子课程证书将添加到您的成就页中,您可以通过该页打印您的课程证书或将其添加到您的领英档案中。如果您只想阅读和查看课程内容,可以免费旁听课程。

还有其他问题吗?请访问 学生帮助中心