Basic Excel Business Analytics - Forecasting with Linear Regression: Trend & Seasonal Pattern

Basic Excel Business Analytics - Forecasting with Linear Regression: Trend & Seasonal Pattern

ExcelIsFun via YouTube Direct link

) Forecast a Trend using Simple Liner Regression. We use the Data Analysis Regression Feature.

2 of 6

2 of 6

) Forecast a Trend using Simple Liner Regression. We use the Data Analysis Regression Feature.

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Basic Excel Business Analytics - Forecasting with Linear Regression: Trend & Seasonal Pattern

Automatically move to the next video in the Classroom when playback concludes

  1. 1 ) Forecasting using Regression when we see a trend and belief the trend will extend into the future. Will will predict outside the Experimental Region with the Assumption is that trend continues into…
  2. 2 ) Forecast a Trend using Simple Liner Regression. We use the Data Analysis Regression Feature.
  3. 3 ) Learn how to use FORECAST function.
  4. 4 ) Forecast a Seasonal Pattern using Multiple Regression and three Categorical Variables for quarter using Multiple Linear Regression. We use the Data Analysis Regression Feature.
  5. 5 ) VLOOKUP & MATCH functions with Mixed Cell References to populate new categorical variable columns with the Boolean ones and zeroes.
  6. 6 ) Forecast a Trend with a Seasonal Pattern using Multiple Regression and three Categorical Variables for quarter and one quantitative variable using Multiple Linear Regression. We use the Data Analys…

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.