How to use the FORECAST function
Author: Oscar Cronquist Article last updated on October 16, 2018
The FORECAST function calculates a value based on existing x and y values using linear regression. Use this function to predict linear trends.
This function is outdated and was replaced with FORECAST.LINEAR function in Excel 2016.
Formula in cell E3:
=FORECAST(E6,C3:C9,B3:B9)
Excel Function Syntax
FORECAST(x, known_y's, known_x's)
Arguments
x | Required. The data point for which you want to predict a value. |
known_y's | Required. Known y points. |
known_x's | Required. Known x points. |
Comments
The chart below shows the predicted value as a red dot, based on x and y values represented by the blue dots.
Functions in 'Compatibility' category
The FORECAST function function is one of many functions in the 'Compatibility' category.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form