If you have QM for Windows, please use. I used this software and it will be easier to compare my work. Please show all work, see attachment. Thank you.
McIntosh University wants to develop forecasts for next year's quarterly enrollment. It has collected data for 2 years. It has also forecasted total annual enrollment for next year to be 90,000 students. What is the forecast for each quarter of next year? Show your work.
Enrollment (in thousands)
Quarter Year 1 Year 2
Fall 24 26
Winter 23 22
Spring 19 19
Summer 14 17
Total 80 84
Please see attached excel file for complete details regarding your ...
Excel file contains QM results and computations using regression forecasting technique.