|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/foundations-in-data-analysis-techniques-to-unlock-insights/
课程评论：没有评论
**课程名称:** 数据分析基础：解锁洞察力的技术 **课程概述:** 本课程将使用真实的性别薪酬数据集，教授数据分析的基础技术，以帮助学习者理解并量化性别薪酬差距的成因。课程内容涵盖： * **基本概念:** 数据和变量的理论介绍，Excel技巧（可选）。 * **核心分析技术:** * 平均数和均值的使用 * 计数和中位数的使用 * 数据可视化（图表和散点图） * 相关性和散点图分析 * 直方图的应用 * 方差和标准差的理解与应用 * 置信区间的构建与使用 * 假设检验（t检验） * **实践应用:** 课程将演示如何在Microsoft Excel中执行上述所有技术，并应用于分析一个包含500多份包含收入、就业、教育、性别、种族、年龄和行业信息的调查数据集。 * **目标:** 通过课程学习，学员将能够解释部分女性收入低于男性的原因，并能够识别和衡量发生性别薪酬歧视的确切位置和程度。 **课程特色:** * **实战导向:** 强调通过真实数据集进行实践操作。 * **工具实用:** 所有技术均可在Microsoft Excel中实现，有助于提升现有工作技能。 * **结论严谨:** 旨在通过统计学方法，以高置信度证明或证伪关于薪酬歧视的假设。 **适合人群:** 希望提升数据分析能力，理解并研究性别薪酬差别的学习者。
In this course we use a real data-set to practice what is taught in each of the lecture videos. By the end of this course you will be able to explain why some females earn less than males and be able to identify (and measure) where gender wage discrimination is taking place and where not. The techniques taught in this course are all executable in Microsoft Excel and will help you improve your current analysis skills. The topics cover:Using averages and meansUsing counts and mediansData visualizations (graphs and plots)Correlations and scatter-plotsHistograms to describe the shape of dataHow to easily understand and use variance and standard deviationHow to construct and use "confidence intervals"Hypothesis testing Using t-tests to prove or disprove an assumptionFor all of the above we replicate the technique in Excel and practice drawing insights about what we are seeing. The course begins by introducing you to some basic theory about data and variables. You will then be introduced to some Excel tips and tricks (if you want) and the data-set that will be used. The data is a sample of over 500 survey responses that includes information about income, employment, education, gender, race, age and industry. We then dive into the different techniques until we can statistically prove, with a high level of confidence, where wage discrimination is taking place (or not). I hope you find this course rewarding, interesting and challenging!Kind regards,Jef Jacobs
