Home > Multiple Regression Analysis and Forecasting User Guide > Forecasting the Dependent Variable Help Topic Share

Forecasting the Dependent Variable

Help for forecasting the dependent variable in the multiple regression analysis and forecasting template for Excel

User Guide Navigation:
Business Spreadsheets User Guides: Project Planning and Management Multiple Regression Analysis and Forecasting Investment and Business Valuation Real Options Valuation Portfolio Optimization Portfolio Performance Tracking Customer Invoicing
Multiple Regression Analysis and Forecasting Help Topics: Inputting Data Analyzing the Output Forecasting the Dependent Variable

The Output is essentially an iterative tool for identifying the value drivers of the dependent variable though manually analyzing independent variable relationships or employing automated feature selection processes. When the output shows a satisfying relationship and predictive equation, a robust forecast can be made by using the options at the right of the Output sheet. Each independent variable can be either independently forecast using built in trend line methods (linear, exponential, or polynomial of 2nd and 3rd order) or left blank so that existing forecast or known data can be input to predict the dependent variable. Such forecasts of independent variables may be from third party or business plan data. Either way, the 'Forecast' sheet automatically inputs the regression equation to produce the forecasted dependent variable data.

Screenshot: Forecasting the Dependent Variable