Excel Regression Models for Business Forecasting Master Class

Welcome to Excel Regression Models for Business Forecasting in which you will learn about Training goals and weekly learning objectives and Important information about versions and region

In this training we will focus on Regression Models, building causal models for both time series data as well as cross-sectional data. Causal models allow us to develop further business insights and strategy by controlling the inputs to generate the output we desire.

About this training:

The current state of the world makes business forecasting even more fundamental to the operation of institutions.

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.

Outline:

Regression Models, building causal models for both time series data as well as cross-sectional data. Causal models allow us to develop further business insights and strategy by controlling the inputs to generate the output we desire.

What will you learn:

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.

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.

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.

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.

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 training and the first training in this specialisation.

Eligibility: For Students and Experts

Training Level: Advanced

Benefits:

  • Financial aid available
  • This Training Plus the Full Specialization
  • Shareable Certificates
  • Self-Paced Learning Option
  • Training Videos & Readings
  • Practice Quizzes
  • Graded Assignments with Peer Feedback
  • Graded Quizzes with Feedback
  • Graded Programming Assignments
  • Shareable on LinkedIn: You can share your Training Certificates in the Certifications section of your LinkedIn profile, on printed resumes, CVs, or other documents.

Be the first to add a review.

Please, login to leave a review
Add to Wishlist

Archive

Working hours

Monday 9:30 am - 6.00 pm
Tuesday 9:30 am - 6.00 pm
Wednesday 9:30 am - 6.00 pm
Thursday 9:30 am - 6.00 pm
Friday 9:30 am - 5.00 pm
Saturday Closed
Sunday Closed