![]() ![]() If known_ys and known_xs are not the same size, FORECAST will return an #N/A error.If x is not numeric, FORECAST returns a #VALUE! error.The chart to the right shows this data plotted in a scatter plot. As the formula is copied down the table, FORECAST returns predicted values in D13:D16, using values in column B for x. With these inputs, the FORECAST 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(B13,sales,periods) In other words, for a given value x, FORECAST returns a predicted value based on the linear regression relationship between x values and y values. FORECAST 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 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 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 |