Description Constructs the least squares regression line through the data given, then computes the predicted y value for the requested x.
Syntax FORECAST (x, arrayY, arrayX)
| Argument | Description |
|---|---|
| x | The x value at which you are requesting the corresponding y value for this regression. |
| arrayY and arrayX | A range reference or an array constant containing numeric values. ArrayX and arrayY must contain the same potential number of values. Text, logical values, and empty cells referenced by this function are ignored, along with the number they are paired up with. That is, when a number from arrayX is paired up with text from arrayY, the entire pair is ignored. |
Remarks This function pairs up the numbers in the two ranges by moving left-to-right through each sequential row.
Equations FORECAST uses the following formulas for slope and intercept to draw the line used to generate the forecast of y at a given x.
where n is the number of members in arrayY and arrayX.
Examples This function returns 1:
