Explore BrainMass
Share

Explore BrainMass

    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 October 9, 2019, 9:45 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