FORECAST.LINEAR Function Explained
The FORECAST.LINEAR function in Microsoft Excel is used to calculate a linear trend line for a given set of data and return a predicted value based on that trend line. It takes two arguments: the x value (the known data point) and the known_y values (the known data points). It then returns the predicted y value for the given x value.
FORECAST.LINEAR Function Syntax
FORECAST.LINEAR(x, known_y's, known_x's)
- x: The x-value for which you want to predict a corresponding y-value.
- known_y’s: A set of y-values that are already known.
- known_x’s: A set of x-values that correspond to the known_y’s.