Explore BrainMass
Share

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?

© BrainMass Inc. brainmass.com June 20, 2018, 11:10 am ad1c9bdddf

Solution Summary

This solution provides calculations for linear trend forecasts in Excel.

$2.19