Completed
) 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 ) 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 ) Forecast a Trend using Simple Liner Regression. We use the Data Analysis Regression Feature.
- 3 ) Learn how to use FORECAST function.
- 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 ) VLOOKUP & MATCH functions with Mixed Cell References to populate new categorical variable columns with the Boolean ones and zeroes.
- 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…