Note: In Excel 2016, the FORECAST function was replaced with FORECAST.LINEAR as part of the new. The syntax and usage of the two functions are the same, but the older FORECAST function will eventually be deprecated.
![]()
It's still available for backward compatibility, but consider using the new FORECAST.LINEAR function instead. DescriptionCalculate, or predict, a future value by using existing values. The future value is a y-value for a given x-value. The existing values are known x-values and y-values, and the future value is predicted by using linear regression. You can use these functions to predict future sales, inventory requirements, or consumer trends. SyntaxFORECAST.LINEAR(x, knowny's, knownx's)- or -FORECAST(x, knowny's, knownx's)The FORECAST/FORECAST.LINEAR function syntax has the following arguments:ArgumentRequiredRefers toxyesThe data point for which you want to predict a value.knowny'syesThe dependent array or range of data.knownx'syesThe independent array or range of data.Remarks.If x is nonnumeric, FORECAST and FORECAST.LINEAR return the #VALUE! Error value.If knowny's or knownx's is empty or one has more data points than the other, FORECAST and FORECAST.LINEAR return the #N/A error value.If the variance of knownx's equals zero, then FORECAST and FORECAST.LINEAR return the #DIV/0!
![]() ![]()
Apr 26, 2016 The sales forecast is the key to the whole financial plan, so it is important to use realistic estimates. Download SCORE’s easy-to-use business planning, finance, sales, marketing and management templates to help you plan for a new business startup or grow your existing business. Know what's coming with AccuWeather's extended daily forecasts for Bar, Bar, Montenegro. Up to 90 days of daily highs, lows, and precipitation chances.
Error value.The equation for FORECAST and FORECAST.LINEAR is a+bx, where:and:and where x and y are the sample means AVERAGE(knownx's) and AVERAGE(known y's).ExampleCopy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.
If you need to, you can adjust the column widths to see all the data.Known YKnown X5382140FormulaDescriptionResult=FORECAST.LINEAR(30,A2:A6,B2:B6)Predicts a value for y given an x value of 3010.607253See Also.
![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |