|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/regression-analysis-for-business-insight-consulting-case/
课程评论：没有评论
**课程名称：** 商业洞察回归分析 – 咨询案例 **课程概述：** 本课程将理论与实践相结合，通过构建普通最小二乘（OLS）回归模型来解答现实世界的商业问题。我们将扮演管理咨询顾问的角色，客户委托我们利用回归模型找出其销售的关键驱动因素，并回答一系列具体的商业问题，例如： * 2022年营销活动的投资回报率（ROI）是多少？ * 2022年竞争对手营销活动的影响是什么？ * 产品价格上涨对业务有何影响？ * 产品的价格弹性是多少？ * 哪个月份的基线销量最高？ * 假设营销效率明年提高10%，在保持投入水平不变的情况下，营销活动将带来多少增量单位？ * 如果明年将价格提高10%，将对业务产生什么影响？ 我们还将简要回顾OLS回归的理论以及高斯-马尔可夫定理（Gauss-Markov Theorem），并学习如何通过分析残差来验证模型的理论准确性。课程将重点介绍如何使用R方（R-squared）、杜宾-沃森（Durbin-Watson）和平均绝对百分比误差（MAPE）等关键统计指标来评估模型。 所有分析将在Excel中进行，我们将学习如何设置Excel模型工作簿，并掌握诸如INDEX MATCH、SUMIFS和COUNTIFS等关键函数的使用。此外，还将学习如何构建折线图、散点图和直方图。 **目标学员：** 本课程适合任何对咨询、数据分析、数据科学、计量经济学和学术研究感兴趣的人员。
In this course, we will be combining the practical and theoretical aspects of regression analysis by building a ordinary least squares model to answer real world business questions then validating it using the Gauss Markov Theorem to ensure it is theoretically accurate as well.We will be taking the place of a management consultant who has been tasked by the client to find the key drivers of their sales using a regression model and then answer business questions has using that model.These are a few of the questions the client has asked us to answer:What was the ROI from marketing efforts in 2022? What was the impact of competitor marketing in 2022? What was the impact of the increase in price of our product?What is the price elasticity of demand for our product? Which month had the highest baseline sales?We expect our marketing to be 10% more efficient next year. If we keep spend at the same level, how many incremental units will we get from our marketing efforts next year? We would like to increase price by 10% next year, what impact will that have on our business? In addition to this, we will also briefly go over the theory of ordinary least squares regression and the Gauss Markov theorem. Which we will then put into practice to validate our model by analyzing the residuals. We will also learn how to evaluate our model using key statistics like the R Square, Durbin Watson and the MAPE.All analysis will be done in excel, so we will learn how to setup a model workbook in excel and learn how to use essential functions such as Index Match, Sumifs and Countifs. We will also go over how to build line graphs, scatterplots and histograms.This course is ideal for anyone interested in working in consulting, data analytics, data science, econometrics and academic research.
