Excel Regression Models for Business Forecasting
Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.
Excel Regression Models for Business Forecasting
This course is part of Excel Skills for Business Forecasting Specialization
6,960 already enrolled
Included with
Ask Coursera
112 reviews
112 reviews
Skills you'll gain
Tools you'll learn
Details to know
See how employees at top companies are mastering in-demand skills
Build your subject-matter expertise
- 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
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
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
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
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.
What's included
4 videos2 readings4 assignments
4 videos•Total 37 minutes
- Multiple Variable Regression•8 minutes
- Multiple Variable Regression — Introduction•11 minutes
- Multiple Variable Regression — Forecasts•9 minutes
- Multiple Variable Regression — Tests•9 minutes
2 readings•Total 15 minutes
- Download the Week 2 workbooks•5 minutes
- Week 2 Toolbox•10 minutes
4 assignments•Total 70 minutes
- Week 2 Assessment•40 minutes
- Multiple Variable Regression — Introduction•10 minutes
- Multiple Variable Regression — Forecasts•10 minutes
- Multiple Variable Regression — Tests•10 minutes
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
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
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.
What's included
5 videos2 readings4 assignments
5 videos•Total 44 minutes
- Seasonal Dummy Regression•6 minutes
- Seasonal Dummy Regression — Introduction & Forecasts•14 minutes
- Seasonal Dummy Regression — Tests•6 minutes
- Autoregression•9 minutes
- Composite Forecasts•8 minutes
2 readings•Total 15 minutes
- Download the Week 4 workbooks•5 minutes
- Week 4 Toolbox•10 minutes
4 assignments•Total 70 minutes
- Week 4 Assessment•40 minutes
- Seasonal Dummy Regression — Introduction & Forecasts•10 minutes
- Seasonal Dummy Regression — Tests•10 minutes
- Autoregression•10 minutes
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Instructor
Offered by
Explore more from Business Strategy
- Status: Free TrialM
Macquarie University
Course
- Status: Free TrialM
Macquarie University
Specialization
- Status: Free TrialR
Rice University
Course
- Status: Free Trial
Course
Why people choose Coursera for their career
Learner reviews
- 5 stars
94.64%
- 4 stars
3.57%
- 3 stars
0%
- 2 stars
1.78%
- 1 star
0%
Showing 3 of 112
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.
Reviewed on Oct 4, 2024
When the students get the right direction, they will only find excellence :)
Reviewed on May 18, 2022
I think this is one of the best online course you can take. Awesome.
Frequently asked questions
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.
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.
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.
More questions
Financial aid available,