Monthly Subscription Starting at AED 99 + VAT

Excel Regression Models for Business Forecasting
  • Level Professional
  • Duration 9 hours
  • Course by Macquarie University
  • Offered by

About

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.

Modules

About the course

    • 2 Videos
    • 3 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • Set your goals and be successful

2 Videos

  • Excel Skills for Business Forecasting Introduction
  • Course introduction

3 Readings

  • Welcome to Excel Regression Models for Business Forecasting
  • Course goals and weekly learning objectives
  • Important information about versions and regions

Introduction

    • 1 Videos
Show info about module content

1 Videos

  • Regression Models

Practice Videos

    • 3 Videos
    • 2 Readings
    • 3 Assignment
Show info about module content

3 Assignment

  • Single Variable Regression
  • Single Variable Regression — Forecasts
  • Single Variable Regression — Tests

3 Videos

  • Single Variable Regression
  • Single Variable Regression — Forecasts
  • Single Variable Regression — Tests

2 Readings

  • Read me before you start: Quizzes and Navigation
  • Download the Week 1 workbooks

Toolbox

    • 1 Readings
Show info about module content

1 Readings

  • Week 1 Toolbox

Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Week 1 Assessment

Introduction

    • 1 Videos
Show info about module content

1 Videos

  • Multiple Variable Regression

Practice Videos

    • 3 Videos
    • 1 Readings
    • 3 Assignment
Show info about module content

3 Assignment

  • Multiple Variable Regression — Introduction
  • Multiple Variable Regression — Forecasts
  • Multiple Variable Regression — Tests

3 Videos

  • Multiple Variable Regression — Introduction
  • Multiple Variable Regression — Forecasts
  • Multiple Variable Regression — Tests

1 Readings

  • Download the Week 2 workbooks

Toolbox

    • 1 Readings
Show info about module content

1 Readings

  • Week 2 Toolbox

Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Week 2 Assessment

Introduction

    • 1 Videos
Show info about module content

1 Videos

  • Dummy Variable Regression

Practice Videos

    • 3 Videos
    • 1 Readings
    • 3 Assignment
Show info about module content

3 Assignment

  • Binary Dummy Regression — Introduction
  • Binary Dummy Regression — Forecasts
  • Binary Dummy Regression — Tests

3 Videos

  • Binary Dummy Regression — Introduction
  • Binary Dummy Regression — Forecasts
  • Binary Dummy Regression — Tests

1 Readings

  • Download the Week 3 workbooks

Toolbox

    • 1 Readings
Show info about module content

1 Readings

  • Week 3 Toolbox

Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Week 3 Assessment

Introduction

    • 1 Videos
Show info about module content

1 Videos

  • Seasonal Dummy Regression

Practice Videos

    • 3 Videos
    • 1 Readings
    • 3 Assignment
Show info about module content

3 Assignment

  • Seasonal Dummy Regression — Introduction & Forecasts
  • Seasonal Dummy Regression — Tests
  • Autoregression

3 Videos

  • Seasonal Dummy Regression — Introduction & Forecasts
  • Seasonal Dummy Regression — Tests
  • Autoregression

1 Readings

  • Download the Week 4 workbooks

Composite Forecasts

    • 1 Videos
Show info about module content

1 Videos

  • Composite Forecasts

Toolbox

    • 1 Readings
Show info about module content

1 Readings

  • Week 4 Toolbox

Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Week 4 Assessment

Auto Summary

Discover how to harness Regression Models for business forecasting in this professional-level course offered by Coursera. Explore simple, multiple, dummy variable, seasonal, and autoregressions to understand and predict business variables. Perfect for professionals in Business & Management, this 540-minute course offers Starter and Professional subscription options. Ideal for generating actionable business intelligence.

Dr Prashan S. M. Karunaratne
Instructor

Dr Prashan S. M. Karunaratne