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?

© SolutionLibrary Inc. solutionlibary.com September 28, 2020, 11:35 am 9836dcf9d7 https://solutionlibrary.com/statistics/multivariate-time-series-and-survival-analysis/linear-trend-forecasts-in-excel-5vmq