|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/datascience-statistics/
课程评论：没有评论
**Coursera 课程《面向数据科学的统计学》内容摘要** 本课程旨在通过简单的Excel工具教授数据科学所需的统计学知识，强调统计学在数据科学中80%的重要性，而编程仅占20%。课程建议先掌握统计学基础，再转向Python和R等工具。 **课程主要内容：** * **第一课：数据科学入门** * 数据科学的定义与重要性 * 使用Excel计算平均值、众数、最小值和最大值 * 数据科学的多学科性 * 数据科学数学学习的两大黄金法则 * **第二课：数据分布与度量** * 数据的离散性与可视化 * 均值、中位数、众数、最大值与最小值 * 离群值、四分位数与四分位距 * 极差与数据分散度 * **第三课：标准差、正态分布与经验法则** * 极差计算的局限性 * 标准差的概念与计算 * 正态分布（钟形曲线）的理解 * 正态分布的实际应用示例 * 使用Excel绘制钟形曲线 * 理解一个、两个和三个标准差 * 68-95-98.7规则（经验法则）的深入解析 * **第四课：Z-score 计算与概率** * 计算50%以上和50%以下的概率 * 计算特定值（如20）的概率 * 计算某一范围（如40到60）内的概率 * **第五课：二项分布** * 二项分布的基础知识 * 利用历史数据计算概率 * 精确概率与范围概率的区别 * 在Excel中应用二项分布 * 实际应用范围概率 * 二项分布的规则
When you talk about data science the most important thing is Statistical MATHS. This course teaches statistical maths using simple excel. My firm belief is MATHS is 80% part of data science while programming is 20%. If you start data science directly with python , R and so on , you would be dealing with lot of technology things but not the statistical things.I recommend start with statistics first using simple excel and the later apply the same using python and R. Below are the topics covered in this course.Lesson 1:- What is Data science ?Chapter 1:- What is Data science and why do we need it ?Chapter 2:- Average , Mode , Min and Max using simple Excel.Chapter 3:- Data science is Multi-disciplinary.Chapter 4:- Two golden rules for maths for data science.Lesson 2:- What is Data science ?Chapter 4:- Spread and seeing the same visually.Chapter 5:- Mean,Median,Mode,Max and MinChapter 6:- Outlier,Quartile & Inter-QuartileChapter 7:- Range and SpreadLesson 3 - Standard Deviation, Normal Distribution & Emprical Rule.Chapter 8:- Issues with Range spread calculationChapter 9:- Standard deviationChapter 10:- Normal distribution and bell curve understandingChapter 11:- Examples of Normal distributionChapter 12:- Plotting bell curve using excelChapter 13:- 1 , 2 and 3 standard deviationChapter 14:- 68,95 and 98 emprical rule.Chapter 15:- Understanding distribution of 68,95 and 98 in-depth.Lesson 4:- The ZScore calculationChapter 16:- Probability of getting 50% above and 50% less.Chapter 17:- Probability of getting 20 value.Chapter 18:- Probability of getting 40 to 60.Lesson 5 - Binomial distributionChapter 22:- Basics of binomial distribution.Chapter 23:- Calculating existing probability from history.Chapter 24:- Exact vs Range probability.Chapter 25:- Applying binomial distribution in excel.Chapter 26:- Applying Range probability.Chapter 27:- Rules of Binomial distribution.
