70.2K

Verified Solution

Link Copied!

a. Plot the time series data using a line plot in the same sheet and comment below on its pattern. b. In the data worksheet, fit an appropriate trend-seasonality model using monthly dummy variables. c. In the data worksheet, plot the predicted values of occupancy in the same plot as the original data. d. How well do your forecasts perform? Point out below any limitations of your forecast model.

Occupancy 501 488 504 578 545 632 728 725 585 542 480 530 518 489 528 599 Month January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December January February March 758 602 587 497 558 555 523 532 623 598 083 774 780 009 804 531 592 578 543 585 848 615 097 785 830 845 843 551 606 585 553 578 Occupancy 501 488 504 578 545 632 728 725 585 542 480 530 518 489 528 599 Month January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December January February March 758 602 587 497 558 555 523 532 623 598 083 774 780 009 804 531 592 578 543 585 848 615 097 785 830 845 843 551 606 585 553 578

Answer & Explanation Solved by verified expert

See Answer