When you enroll in this course, you'll also be enrolled in this Specialization.
Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate
There are 5 modules in this course
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.
What's included
2 videos3 readings1 discussion prompt
Show info about module content
2 videos•Total 2 minutes
Excel Skills for Business Forecasting Introduction•1 minute
Course introduction•2 minutes
3 readings•Total 30 minutes
Welcome to Excel Regression Models for Business Forecasting•10 minutes
Course goals and weekly learning objectives•10 minutes
Important information about versions and regions•10 minutes
1 discussion prompt•Total 15 minutes
Set your goals and be successful•15 minutes
Regression Models
Module 2•2 hours to complete
Module details
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.
What's included
4 videos3 readings4 assignments
Show info about module content
4 videos•Total 40 minutes
Regression Models•8 minutes
Single Variable Regression•11 minutes
Single Variable Regression — Forecasts•10 minutes
Single Variable Regression — Tests•11 minutes
3 readings•Total 25 minutes
Read me before you start: Quizzes and Navigation•10 minutes
Download the Week 1 workbooks•5 minutes
Week 1 Toolbox•10 minutes
4 assignments•Total 70 minutes
Week 1 Assessment•40 minutes
Single Variable Regression•10 minutes
Single Variable Regression — Forecasts•10 minutes
Single Variable Regression — Tests•10 minutes
Multiple Variable Regression
Module 3•2 hours to complete
Module details
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.
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.
What's included
4 videos2 readings4 assignments
Show info about module content
4 videos•Total 27 minutes
Dummy Variable Regression•4 minutes
Binary Dummy Regression — Introduction•8 minutes
Binary Dummy Regression — Forecasts•8 minutes
Binary Dummy Regression — Tests•7 minutes
2 readings•Total 15 minutes
Download the Week 3 workbooks•5 minutes
Week 3 Toolbox•10 minutes
4 assignments•Total 70 minutes
Week 3 Assessment•40 minutes
Binary Dummy Regression — Introduction•10 minutes
Binary Dummy Regression — Forecasts•10 minutes
Binary Dummy Regression — Tests•10 minutes
Seasonal Dummy Regression
Module 5•2 hours to complete
Module details
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.
In this module we will also explore autoregressions - their theoretical underpinning, creating an autoregression, critically evaluating this, and utilising our model for business forecasting.
We will end the module by learning how to create a composite forecast by combining two forecasts across this course and the first course in this specialisation.
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.
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."
Learner reviews
4.9
112 reviews
5 stars
94.64%
4 stars
3.57%
3 stars
0%
2 stars
1.78%
1 star
0%
Showing 3 of 112
T
TM
5·
Reviewed on Nov 6, 2023
It was challenging and required me to really dig deep to understand the concepts, but the path was progressive in nature and the testing very hands on with the excel tools. Thank you.
S
SP
5·
Reviewed on Oct 4, 2024
When the students get the right direction, they will only find excellence :)
S
SM
5·
Reviewed on Nov 25, 2022
This course help me to work online and earn some extra money as well I gained excel and forecasting skills.The instructor is really very nice.
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.