Microsoft Office Tutorials and References

In Depth Information

**What’s in the Future: Using FORECAST, TREND, and GROWTH to Make Predictions**

3. Label this area
Actual Data
.

4. In another section of the worksheet, enter the numbers 13 through 18

inacolumntorepresenttheupcomingsixmonths.

5.Inthecolumnadjacenttotheprojectedmonthnumbers,selectthesix

adjacent cells (empty at present) by dragging over them.

6. Type
=TREND(
to start the function entry.

7. Drag the mouse over the range of known Y values, or enter the range

address.

The known Y values are the income figures entered in Step 2.

8. Enter a comma (
,).

9. Drag the mouse over the range of known X values, or enter the range

address.

The known X values are the numbers 1 through 12 entered in Step 1.

10. Enter a comma (
,).

11. Drag the mouse over the list of month numbers for which you want

projections (the numbers 13 through 18).

These are the new X values.

12. Enter a
).

13. Press Ctrl + Shift + Enter to complete the formula.

When you’ve completed these steps, you’ll see the projected income figures,

calculated by the TREND function, displayed in the worksheet. An example is

shown in Figure 11-6. There’s no assurance you’ll have this income — but it

may be even higher! You can always hope for the best.

Figure 11-6:

Using the

TREND

function to

calculate

predictions

for an array.