|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/essential-statistics-for-data-analysis/
课程评论：没有评论
课程名称：Microsoft Excel：数据分析的基本统计学 课程概述：本课程是一门以实践和项目为基础的课程，旨在帮助您学习并应用数据分析和商业智能所需的基本统计学概念。我们的目标是简化统计学的复杂性，通过使用熟悉的电子表格工具（如Microsoft Excel），使普通人能够理解和应用这些工具和技术，即使您没有数学或统计学的背景！ 课程内容： 1. **统计学的角色**：讨论统计学在商业智能中的重要性，样本数据与总体数据的区别，以及如何利用统计技术做出明智的预测和数据驱动的决策。 2. **描述性统计学**：使用Excel理解数据，包括频率分布和集中趋势与变异性度量的应用。 - 项目1：Maven比萨店 3. **概率分布建模**：使用概率分布模型数据，利用正态分布计算概率并估算值。 - 项目2：Maven医疗中心 4. **中心极限定理**：介绍中心极限定理，利用正态分布对任何分布的总体进行推断。 5. **置信区间的估算**：使用样本统计量通过置信区间对未知总体参数进行范围估计。 - 项目3：Maven制药公司 6. **假设检验**：通过假设检验评估关于总体参数的假设。 - 项目4：Maven安全委员会 7. **回归分析**：通过回归分析进行预测，并估计因变量与自变量之间的关系。 - 项目5：Maven航空公司 在整个课程中，您将扮演Maven商学院的招聘分析师，利用所学的统计技术探索学生数据，预测未来班级的表现，并提出改进毕业生结果的建议。此外，您还可以实践5个真实世界的附加项目，应用统计学探索来自餐馆、医疗中心、制药公司、安全团队和航空公司的数据。 课程附加内容包括7.5小时高质量视频、统计分析PDF电子书（150多页）、可下载的Excel项目文件及解决方案、专家支持及问答论坛以及30天的满意保证。 对于数据分析师、数据科学家、商业智能专业人员或任何希望利用统计做出明智数据驱动决策的人员，此课程非常适合您！欢迎参加并享受学习的乐趣！- Enrique Ruiz（Maven Analytics首席统计学和Excel讲师） 如需浏览我们的全课程库，请搜索“Maven Analytics”以查看我们的Excel、Power BI、SQL、Tableau、Python、Alteryx和机器学习课程的完整集合！
This is a hands-on, project-based course designed to help you learn and apply essential statistics concepts for data analysis and business intelligence. Our goal is to simplify and demystify the world of statistics using familiar spreadsheet tools like Microsoft Excel, and empower everyday people to understand and apply these tools and techniques - even if you have absolutely no background in math or stats!We'll start by discussing the role of statistics in business intelligence, the difference between sample and population data, and the importance of using statistical techniques to make smart predictions and data-driven decisions.Next we'll explore our data using descriptive statistics and probability distributions, introduce the normal distribution and empirical rule, and learn how to apply the central limit theorem to make inferences about populations of any type.From there we'll practice making estimates with confidence intervals, and using hypothesis tests to evaluate assumptions about unknown population parameters. We'll introduce the basic hypothesis testing framework, then dive into concepts like null and alternative hypotheses, t-scores, p-values, type I vs. type II errors, and more.Last but not least, we'll introduce the fundamentals of regression analysis, explore the difference between correlation and causation, and practice using basic linear regression models to make predictions using Excel's Analysis Toolpak.Throughout the course, you'll play the role of a Recruitment Analyst for Maven Business School. Your goal is to use the statistical techniques you've learned to explore student data, predict the performance of future classes, and propose changes to help improve graduate outcomes.You'll also practice applying your skills to 5 real-world BONUS PROJECTS, and use statistics to explore data from restaurants, medical centers, pharmaceutical companys, safety teams, airlines, and more.COURSE OUTLINE:Why Statistics?Discuss the role of statistics in the context of business intelligence and decision-making, and introduce the statistics workflowUnderstanding Data with Descriptive StatisticsUnderstand data using descriptive statistics in Excel, including frequency distributions and measures of central tendency & variabilityPROJECT #1: Maven Pizza ParlorModeling Data with Probability DistributionsModel data with probability distributions, and use the normal distribution to calculate probabilities and make value estimates using Excel formulasPROJECT #2: Maven Medical CenterThe Central Limit TheoremIntroduce the Central Limit Theorem, which leverages the normal distribution to make inferences on populations with any distributionMaking Estimates with Confidence IntervalsMake estimates with confidence intervals, which use sample statistics to define a range where an unknown population parameter likely liesPROJECT #3: Maven PharmaDrawing Conclusions with Hypothesis TestsDraw conclusions with hypothesis tests, which let you evaluate assumptions about population parameters using sample statisticsPROJECT #4: Maven Safety CouncilMaking Predictions with Regression AnalysisMake predictions with regression analysis, and estimate the values of a dependent variable via its relationship with independent variablesPROJECT #5: Maven AirlinesJoin today and get immediate, lifetime access to the following:7.5 hours of high-quality videoStatistics for Data Analysis PDF ebook (150+ pages)Downloadable Excel project files & solutionsExpert support and Q & A forum30-day Udemy satisfaction guaranteeIf you're a data analyst, data scientist, business intelligence professional, or anyone looking to use statistics to make smart, data-driven decisions, this course is for you!Happy learning!-Enrique Ruiz (Lead Statistics & Excel Instructor, Maven Analytics)__________Looking for our full course library? Search "Maven Analytics" to browse our full collection of Excel, Power BI, SQL, Tableau, Python, Alteryx & Machine Learning courses!See why our Excel courses are some of the TOP-RATED on Udemy:"At the first part I just said to myself, 'Wow, Excel is capable of that? It's amazing!' Then at the second part I told myself 'This guy is doing magic!', and now I feel like I'm capable of doing the same. I can't wait to dive into the other courses!"- Judit B."Excellent from start to finish. I picked up a bunch of techniques that will be useful in the workplace, from new chart templates to some very cool advanced visualizations. I loved all of it!"- Robert C."Excellent material that I apply to my daily use of Excel. I consider myself an Excel professional, yet I picked up dozens of new tips and techniques. Wonderful course, well-presented and well-explained."- Jeffrey P.__________
