With these inputs, the FORECAST.LINEAR function returns 1505.36 in cell D13. Where sales (C5:C12) and periods (B5:B12) are named ranges. In the example shown above, the formula in cell D13 is: =FORECAST.LINEAR(B13,sales,periods) In other words, for a given value x, FORECAST.LINEAR returns a predicted value based on the linear regression relationship between x values and y values. FORECAST.LINEAR uses this approach to calculate a y value for a given x value based on existing x and y values. In statistics, linear regression is an approach for modeling the relationship between a dependent variable (y values) and an independent variable (x values). Microsoft recommends replacing FORECAST with FORECAST.LINEAR, since FORECAST will eventually be deprecated. ![]() Note: Starting with Excel 2016, the FORECAST function was replaced with the FORECAST.LINEAR function. ![]() FORECAST.LINEAR calculates future value predictions using linear regression, and can be used to predict numeric values like sales, inventory, test scores, expenses, measurements, etc. The FORECAST.LINEAR function predicts a value based on existing values along a linear trend.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |