Skip to main content


Name of Formula


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. 


  • 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. 


User does not have sufficient privileges to access this Content
Learn More

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.