FORECAST

Definition: FORECAST is a function that predicts a future value using linear regression.

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

Situation: This formula is suitable when you need to predict a future value using linear regression.

Example: If you have a set of known x and y values, and want to predict the y value for a new x value of 10, the formula =FORECAST(10, A1:A10, B1:B10) can be used.