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.

	A	B
1	Year	Sales
2	2006	$1,500,000
3	2007	$2,500,000
4	2008	$4,500,000
5	2009	$5,500,000
6	2010	$7,500,000
7	2011	$9,000,000
8	2012	$10,000,000
9	2013	$11,000,000
10	2014	$11,500,000
11	2015	$12,500,000
12	2016	$14,533,333

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

If this problem persists, please contact our support.