FORECAST
Name of Formula:
FORECAST(A1,A2:A100,B2:B100)
Definition of FORECAST:
This formula Calculates the expected yvalue for a specified x based on a linear regression of a data set.
Syntax for FORECAST:
FORECAST(x, data_y, data_x)
x
 The value on the xaxis to forecast.data_y
 The range representing the array or matrix of dependent data.data_x
 The range representing the array or matrix of independent data.
Notes:
 Any text encountered in the
value
arguments will be ignored.
Step 1. To begin to use the FORECAST formula, start with the Excellentable you would like to edit.
Step 2. Then type the FORECAST formula into the cell you have chosen to display the outcome:
Step 3. Fill in the 5 values In this example I have chosen 5 values that are the same.
Step 4. Once saved, your completed formula will display in a confluence page like this.
A

B



1


2


3


4


5


6


7


8


9


10


11


12
