FORECAST

Name of Formula: 

FORECAST(A1,A2:A100,B2:B100)

Definition of FORECAST:

This formula Calculates the expected y-value 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 x-axis 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.