# 面向Excel Online数据分析的数学基础

## Essential Math for Data Analysis using Excel Online

Learn essential mathematical skills for analyzing data

434 次查看

edX
• 完成时间大约为 6
• 高级
• 英语

### 你将学到什么

Handle data sets for analysis purposes

Understand beginning mathematical notation

Work with different types of data

Summarize data with distributions and graphs

Apply summary statistics to analyze and understand data sets

Calculate business metrics and KPIs to derive business value from data sets

Apply basic inferential math to data

Use tools to forecast future trends in data

### 课程概况

Starting with the absolute basics of math and data, this course builds up your analyst skills while removing the mathematical hurdles and barriers that often come with beginning to learn how to analyze data. This course is intended for anyone with the desire to do data analysis and who would like to learn the math behind it all in a simplified way, as well as for anyone who would like a thorough refresher on the essentials.

Learn how to handle different data types, understand mathematical notation, become proficient in handling data sets and summary statistics, and even get a sneak peek into how to be effective at making stctistical inferences and predictions, all told in a way to maximize your understanding—so that afterward, you can be well on your way toward analyzing data in any field or discipline.

### 课程大纲

Module 1: Introduction to Data and Variables

Module 2: Summarizing Data with Distributions and Graphs

Module 3: Summary Statistics

Module 4: Business Statistics

Module 5: Introduction to Inferential Math and Forecasting

### 预备知识

Basic excel proficiency

### 常见问题

Q: Do I need desktop Excel?
A: No. We will be using Excel Online for all applied portions of the course, with the exception of a lab in Module 5, where we will not require the desktop version of Excel and the applied portion is optional.

Q: Do I need a Windows computer to complete the course?
A: No. You can complete the labs using a computer running Windows, Mac OS X, or Linux.

Apple 广告
##### 声明：MOOC中国十分重视知识产权问题，我们发布之课程均源自下列机构，版权均归其所有，本站仅作报道收录并尊重其著作权益。感谢他们对MOOC事业做出的贡献！
• Coursera
• edX
• OpenLearning
• FutureLearn
• iversity
• Udacity
• NovoEd
• Canvas
• Open2Study
• ewant
• FUN
• IOC-Athlete-MOOC
• World-Science-U
• CourseSites
• opencourseworld
• ShareCourse
• gacco