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