# FORECAST

### [data-colorid=jjth3wknk3]{color:#212121} html[data-color-mode=dark] [data-colorid=jjth3wknk3]{color:#dedede}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 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

JavaScript errors detected