Share
Explore BrainMass

Linear Trend Forecasts in Excel

The Dean of the business college at Strayer University wants to forecast the number of students who will enroll in business courses at the Charleston SC campus. Historically the enrollments have been:

Year Students
1 400
2 450
3 380
4 425
5 500
6 555
7 495
8 610

a. Compute a linear trend forecast for the next 5 years.
b. Is the trend seasonal or not?

Solution Summary

This solution provides calculations for linear trend forecasts in Excel.

$2.19