This course teaches how to forecast trends and seasonal patterns using linear regression in Excel. Students will learn to use the FORECAST function, VLOOKUP & MATCH functions, and Data Analysis Regression Feature. The intended audience for this course is individuals interested in business analytics and forecasting using Excel.
Basic Excel Business Analytics - Forecasting with Linear Regression: Trend & Seasonal Pattern
ExcelIsFun via YouTube
Overview
Syllabus
) 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 future..
) Forecast a Trend using Simple Liner Regression. We use the Data Analysis Regression Feature..
) Learn how to use FORECAST function..
) Forecast a Seasonal Pattern using Multiple Regression and three Categorical Variables for quarter using Multiple Linear Regression. We use the Data Analysis Regression Feature..
) VLOOKUP & MATCH functions with Mixed Cell References to populate new categorical variable columns with the Boolean ones and zeroes..
) 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 Analysis Regression Feature..
Taught by
ExcelIsFun
