|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/statistics-and-data-analysis-with-excel/
课程评论：没有评论
**课程名称：** 使用 Excel 进行统计与数据分析 **课程概述：** 本课程是一门实用型课程，专注于教授学员如何利用 Microsoft Excel 进行高级统计计算和数据分析。Excel 是一款在众多公司广泛使用的工具，具备强大的数据分析能力，尤其适用于数据分析师和营销专家。即使您是统计学专业人士，也会惊讶于 Excel 在假设检验和计算数据集常见指标方面的价值。通过掌握 Excel 的基础和高级函数，您可以最大化地利用数据。因此，对于任何需要处理数据和进行各种分析的人来说，Excel 都是一个非常有用的工具。 本课程适合需要处理数据和调查数据的**数据分析师**和**营销专家**。 **课程将帮助您学习：** * **单变量描述性分析：** 包括均值、标准差、偏度、分位数、百分位数、四分位距 (IQR) 等。 * **高级单变量分析：** 包括异常值检测、滚动测量等。 * **置信区间：** 理解和计算数据的可靠区间。 * **线性相关与回归预测：** 分析变量间的关系并进行预测。 * **假设检验：** 掌握 t 检验 (Student's t-test)、卡方检验 (chi-square test)、F 检验 (F-test)、Welch 检验 (Welch test) 等。 * **t 分布表和 z 分布表：** 理解和应用统计表格。 * **数据库操作与条件操作：** 有效管理和处理数据。 * **垂直查找 (Vertical Lookup)：** 快速在数据表中查找信息。 * **数据透视表 (Pivot Tables)：** 强大的数据汇总和分析工具。 **教学模式：** 所有视频课程都以简要介绍开始，并以 Excel 中的实际操作示例结束。每节课都附带可下载的 Excel 练习文件，方便学员实践。
In this practical course, we are going to focus on how to perform advanced statistical calculations and data analysis using Microsoft Excel.Excel is a very used tool in several companies and has very powerful data analysis capabilities that can be used by data analysts and marketing experts. Even if you work with a lot of statistics you'd be surprised at how valuable Excel is for calculating hypothesis tests and the most common metrics you can calculate on a dataset. There are several basic and advanced functions you can use to get the best from your data and that's why Excel is a very useful tool for anybody who needs to crunch data and perform analyses of various kinds.This course can be attended by both data analysts and marketing experts who need to work with data and surveys.With this course, you are going to learn:Univariate descriptive analysis (mean, standard deviation, skewness, quantiles, percentiles, IQR)Advanced univariate analysis (outlier detection, rolling measures)Confidence intervalsLinear correlation and regression forecastingHypothesis tests (Student's t-test, chi-square test, F-test, Welch test)t tables and z tablesDatabase operations and conditional operationsVertical lookupPivot tablesAll the video lessons of this course start with a brief introduction and end with a practical example in Excel. All the Excel spreadsheets are attached to each lesson and can be downloaded.
