FORECAST function - The function returns a value along a linear trend in Excel
The following article introduces you to the FORECAST function - one of the functions in the statistical function group is very popular in Excel.
Description: The function performs a calculation or prediction of a future value by using current values using linear regression. In Excel 2016 this function is replaced by FORECAST.LINEAR function .
Syntax: FORECAST (x, known_y's, known_x's)
Inside:
- x: Data point to predict a value for it, is a required parameter.
- known_y's: Dependent array of an array or range of data.
- known_x's: Independent array of array or range of data .
Attention:
- If x is not a number -> the function returns the #VALUE! Error value .
- If known_y's or known_x's are empty or contain a different number of data points -> the function returns the # N / A error value
- If known_x's = 0 -> variance, the function returns the DIV / 0 error value !
- FORECAST transform equation is: A + BX where:
(a = bar y - bbar x)
(b = frac {{sum {(x - bar x) (y - bar y)}}}} {{sum {{{(x - bar x)} ^ 2}}}})
And x, y are the average samples of AVERAGE (known_x's) and AVERAGE (known y's).
For example:
Find the predicted value of y and the x value is 25 and 52, respectively:
- Predict the value of y to know the value of x is 25. In the cell to calculate enter the formula : = FORECAST (25, C6: C10, D6: D10)
- Press Enter -> Predict the value of y is:
- Similarly, copy for the case that the value of x is 52 results in:
- Where the number of data points of the two different x and y arrays is different -> the function returns the # N / A error value
Here the value array of x is known only from C6 -> C8 (there are 3 data points) while that of y from C6 -> C10 (there are 5 data points).
Above are instructions and some specific examples when using FORECAST function in Excel.
Good luck!
You should read it
- TREND - The function returns values in a linear trend in Excel
- WEIBULL function - The function returns the Weibull distribution in Excel
- SLOPE function - The function returns the slope of a linear regression line through data points in Excel
- PEARSON function - The function returns the Pearson product moment correlation coefficient in Excel
- How to use the IF function in Excel
- How to use the IFS function in Excel 2016
- CHISQ.TEST function - The function returns the independence test in Excel
- OR function in Excel, how to use the OR function, and examples
- GAMMA function - The function returns the gamma function value in Excel
- POISSON.DIST function - The function returns the Poisson distribution in Excel
- PHI function - The function returns the value of the density function for a normal distribution in Excel
- QUARTILE.EXC function - The function returns the quartile of a dataset without values 0 and 1 in Excel
Maybe you are interested
AMD has surpassed Intel in brand value
SQL way to count NULL and NOT NULL values in a column
Comparing Odroid-N2+ and Raspberry Pi 4: Which option offers better value?
How to receive free gifts from IObit with a total value of nearly 150,000 USD
Write a program to find duplicate values in Python
Write a program to check duplicate values in Python