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.
Ce cours fait partie de la Spécialisation Excel Skills for Business Forecasting
1 873 déjà inscrits
Offert par
Spécialisation Excel Skills for Business ForecastingUniversité MacquarieÀ propos de ce cours
6 983 consultations récentes
Dates limites flexibles
Réinitialisez les dates limites selon votre disponibilité.
Certificat partageable
Obtenez un Certificat lorsque vous terminez
100 % en ligne
Commencez dès maintenant et apprenez aux horaires qui vous conviennent.
Cours 2 sur 3 dans le
Niveau intermédiaire
Approx. 9Â heures pour terminer
Anglais
Sous-titres : Anglais
Compétences que vous acquerrez
- Microsoft Excel
- Business Forecasting
- regression models
Dates limites flexibles
Réinitialisez les dates limites selon votre disponibilité.
Certificat partageable
Obtenez un Certificat lorsque vous terminez
100 % en ligne
Commencez dès maintenant et apprenez aux horaires qui vous conviennent.
Cours 2 sur 3 dans le
Niveau intermédiaire
Approx. 9Â heures pour terminer
Anglais
Sous-titres : Anglais
Offert par
Université Macquarie
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.
Programme de cours : ce que vous apprendrez dans ce cours
1Â heure pour terminer
Welcome and Critical Information
1Â heure pour terminer
2 vidéos (Total 2 min), 3 lectures
2Â heures pour terminer
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Â heures pour terminer
4 vidéos (Total 40 min), 3 lectures, 4 quiz
2Â heures pour terminer
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Â heures pour terminer
4 vidéos (Total 37 min), 2 lectures, 4 quiz
2Â heures pour terminer
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Â heures pour terminer
4 vidéos (Total 27 min), 2 lectures, 4 quiz
2Â heures pour terminer
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Â heures pour terminer
5 vidéos (Total 44 min), 2 lectures, 4 quiz
Avis
- 5 stars93,75Â %
- 4 stars4,16Â %
- 2 stars2,08Â %
Meilleurs avis pour EXCEL REGRESSION MODELS FOR BUSINESS FORECASTING
par DD8 janv. 2022
Learning this course was fantastic, it really improved my knowledge for excel and regression
par YN18 mai 2022
I think this is one of the best online course you can take. Awesome.
par CM12 juil. 2021
A step-by-step guide for business forecasting! Very easy to follow and the course brush up my statistics on linear regression as well.
par MH12 nov. 2021
The lecturer did great demonstrating how equation looks like on business application.
À propos du Spécialisation 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.
Foire Aux Questions
Quand aurai-je accès aux vidéos de cours et aux devoirs ?
À quoi ai-je droit si je m'abonne à cette Spécialisation ?
Une aide financière est-elle possible ?
D'autres questions ? Visitez le Centre d'Aide pour les Étudiants.
