Completed
) VLOOKUP & MATCH functions with Mixed Cell References to populate new categorical variable columns with the Boolean ones and zeroes.
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…