This course allows learners to explore Regression Models in order to utilise these models for business forecasting. Unlike Time Series Models, Regression Models are causal models, where we identify certain variables in our business that influence other variables. Regressions model this causality, and then we can use these models in order to forecast, and then plan for our business' needs. We will explore simple regression models, multiple regression models, dummy variable regressions, seasonal variable regressions, as well as autoregressions. Each of these are different forms of regression models, tailored to unique business scenarios, in order to forecast and generate business intelligence for organisations.
提供方
課程信息
6,780 次近期查看
可靈活調整截止日期
根據您的日程表重置截止日期。
可分享的證書
完成後獲得證書
100% 在線
立即開始，按照自己的計劃學習。
第 2 門課程（共 3 門）
中級
完成時間大約為9 小時
英語（English）
字幕：英語（English）
您將獲得的技能
- Microsoft Excel
- Business Forecasting
- regression models
可靈活調整截止日期
根據您的日程表重置截止日期。
可分享的證書
完成後獲得證書
100% 在線
立即開始，按照自己的計劃學習。
第 2 門課程（共 3 門）
中級
完成時間大約為9 小時
英語（English）
字幕：英語（English）
提供方
麦考瑞大学
Macquarie is ranked among the top one per cent of universities in the world, and with a 5-star QS rating, we are recognised for producing graduates who are among the most sought-after professionals in the world. Since our foundation 54 years ago, we have aspired to be a different type of university: one focused on fostering collaboration between students, academics, industry and society.
授課大綱 - 您將從這門課程中學到什麼
完成時間為 1 小時
Welcome and Critical Information
完成時間為 1 小時
2 個視頻 （總計 2 分鐘）, 3 個閱讀材料
完成時間為 2 小時
Regression Models
In this module, we explore the context and purpose of business forecasting and the three types of business forecasting using regression models. We will learn the theoretical underpinning for a regression model, and understand the relationship between explanatory variables and dependent variables. We will first focus on single variable or simple regression, and learn how to critically evaluate the model using regression diagnostic tools and then use our models for forecasting to suit our organisation's needs.
完成時間為 2 小時
4 個視頻 （總計 40 分鐘）, 3 個閱讀材料, 4 個測驗
完成時間為 2 小時
Multiple Variable Regression
In this module, we extend the simple regression model to take in multiple explanatory variables. We will extend the theoretical underpinning for a regression model by involving multiple dependent variables. We will learn how to critically evaluate the multiple regression models using regression diagnostic tools and then use our models for forecasting to suit our organisation's needs.
完成時間為 2 小時
4 個視頻 （總計 37 分鐘）, 2 個閱讀材料, 4 個測驗
完成時間為 2 小時
Dummy Variable Regression
In this module, we extend the multiple regression model to take in qualitative binary explanatory variables. We will extend the theoretical underpinning for a multiple regression model by creating dummy variables for binary qualitative data. We will learn how to critically evaluate the dummy variable regression models using regression diagnostic tools and then use our models for forecasting to suit our organisation's needs.
完成時間為 2 小時
4 個視頻 （總計 27 分鐘）, 2 個閱讀材料, 4 個測驗
完成時間為 2 小時
Seasonal Dummy Regression
In this module, we extend the binary dummary variable regression model to take in seasonal variables. We will extend the theoretical underpinning for a binary dummy variable regression model by creating a series of dummy variables to capture seasonality. We will learn how to critically evaluate the seasonal dummy regression models using regression diagnostic tools and then use our models for forecasting to suit our organisation's needs.
完成時間為 2 小時
5 個視頻 （總計 44 分鐘）, 2 個閱讀材料, 4 個測驗
審閱
- 5 stars95.65%
- 4 stars4.34%
來自EXCEL REGRESSION MODELS FOR BUSINESS FORECASTING的熱門評論
由 PR 提供2021年10月1日
I never new I'd like regression, thanks to Dr Prashan! His skills in teaching is very clear and concise. The lessons are easy to follow. Perfect for beginners.
由 DD 提供2022年1月8日
Learning this course was fantastic, it really improved my knowledge for excel and regression
由 MH 提供2021年11月12日
The lecturer did great demonstrating how equation looks like on business application.
由 CM 提供2021年7月12日
A step-by-step guide for business forecasting! Very easy to follow and the course brush up my statistics on linear regression as well.
關於 Excel Skills for Business Forecasting 專項課程
The current state of the world makes business forecasting even more fundamental to the operation of institutions. In this Specialization we focus on Excel Skills for Business Forecasting in three courses — Time Series Models, Regression Models, and Judgmental Forecasting.
常見問題
我什么时候能够访问课程视频和作业？
我订阅此专项课程后会得到什么？
有助学金吗？
還有其他問題嗎？請訪問 學生幫助中心。
