Microsoft Office Tutorials and References
In Depth Information
Using TREND to Calculate Many Future Data Points at Once
Figure 14.17.
Figure 14.17. You use the
You use the FORECAST
FORECAST function to find the data point for one
function to find the data point for one
future time period.
future time period.
To predict sales for future periods, follow these steps:
11. Enter future years in A13:A17.
22. In column B, enter Actual
Forecast for each row so that the per-
son reading the table understands that the new values are a forecast.
33. To predict sales for 2016, enter this formula in cell C13:
=FORECAST(A13,$C$2:$C$12,$A$2:$A$12).
44. Copy the formula from cell C13 down to C14:C17.
Actual or Forecast
Using
Using TREND
to Calculate Many Future Data Points at Once
The TREND function is another array function. This means that it can return
many values from a single formula. If you think about the previous use of
FORECAST in Figure 14.17 , you realize that Excel really had to perform the
linear regression multiple times once for each of the cells in C13:C17. It
TREND to Calculate Many Future Data Points at Once
Search JabSto ::




Custom Search