Explore BrainMass
Share

Linear Trend Forecasts in Excel

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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 March 21, 2019, 4:43 pm ad1c9bdddf
https://brainmass.com/statistics/multivariate-time-series-and-survival-analysis/196314

Solution Summary

This solution provides calculations for linear trend forecasts in Excel.

$2.19