Use the FORECAST function for linear forecasting

Use the FORECAST function for linear forecasting

Syntax: FORECAST(x, known_y’s, known_x’s)

Step 1: Define the x-value for the forecast, known_y’s (dependent variable), and known_x’s (independent variable).

Step 2: Enter the formula in a cell and press Enter.

For all things Strategy, Management Theories, and Business Frameworks, please visit https://www.stratrix.com