4.8
242 个评分
56 个审阅

### 您将获得的技能

Data AnalysisMicrosoft ExcelStatistical AnalysisNormal Distribution

1

## 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 个视频 （总计 7 分钟）, 6 个阅读材料, 1 个测验
2 个视频
Excel Data Analysis Toolpak1分钟
6 个阅读材料
Syllabus10分钟
Glossary5分钟
Using Excel for this Course10分钟
Social Media4分钟
1 个练习
Orientation Quiz10分钟

## 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 个视频 （总计 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分钟
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

## 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 个视频 （总计 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分钟
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

## 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 个视频 （总计 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分钟
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

## 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 个视频 （总计 97 分钟）, 2 个阅读材料, 5 个测验
12 个视频
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分钟
2 个阅读材料
Module 4 Overview3分钟
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
56 个审阅

## 50%

### 热门审阅

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!

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.

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

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