Macquarie University
Excel Regression Models for Business Forecasting
Macquarie University

Excel Regression Models for Business Forecasting

This course is part of Excel Skills for Business Forecasting Specialization

Taught in English

Some content may not be translated

4,375 already enrolled

Included with Coursera Plus

Course

Gain insight into a topic and learn the fundamentals

4.9

(85 reviews)

Intermediate level
Some related experience required
9 hours (approximately)
Flexible schedule
Learn at your own pace

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

16 quizzes

Course

Gain insight into a topic and learn the fundamentals

4.9

(85 reviews)

Intermediate level
Some related experience required
9 hours (approximately)
Flexible schedule
Learn at your own pace

See how employees at top companies are mastering in-demand skills

Placeholder

Build your subject-matter expertise

This course is part of the Excel Skills for Business Forecasting Specialization
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
Placeholder
Placeholder

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

Placeholder

There are 5 modules in this course

What's included

2 videos3 readings1 discussion prompt

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 quizzes

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 quizzes

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 quizzes

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 quizzes

Instructor

Instructor ratings
5.0 (23 ratings)
Dr Prashan S. M. Karunaratne
Macquarie University
28 Courses1,249,578 learners

Offered by

Recommended if you're interested in Business Strategy

Why people choose Coursera for their career

Felipe M.
Learner since 2018
"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

Showing 3 of 85

4.9

85 reviews

  • 5 stars

    92.94%

  • 4 stars

    4.70%

  • 3 stars

    0%

  • 2 stars

    2.35%

  • 1 star

    0%

TM
5

Reviewed on Nov 6, 2023

ST
5

Reviewed on Mar 5, 2023

MK
5

Reviewed on Nov 25, 2022

New to Business Strategy? Start here.

Placeholder

Open new doors with Coursera Plus

Unlimited access to 7,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Frequently asked questions