1) One of the divisions of TCC is a hotline for consumers requesting information on their line of all-inclusive student vacations for the week after finals. As more and more information becomes available online from customers who are making negative Yelp posts about the vacation timing, phone requests for information have been declining. Still, the company is concerned with proper staffing during the exam days of December 17th and 18th. Date Shift Requests December 13 Day 70 Evening 47 Night 46 December 14 Day 65 Evening 43 Night 37 December 15 Day 59 Evening 39 Night 34 December 16 Day 56 Evening 35 Night 30 Forecast the demand for information requests for the three shifts of December 17th and the three shifts of December 18th. Answer the following questions in a text box in the worksheet. A) Create a chart that shows the number of requests. Do you see both trend and seasonality components in the data? B) Forecast the number of requests for December 17th and December 18th. C) Create a second chart that shows both the requests through December 16th and the forecasted requests for December 17th and 18th. Color the chart so it is easy to distinguish the actual requests from the forecast. At the end of this problem you should have 2 charts and an answer to question A. Include and label a separate tab with your regression results.

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

1) One of the divisions of TCC is a hotline for consumers requesting information on their line of all-inclusive student vacations for the week after finals. As more and more information becomes available online from customers who are making negative Yelp posts about the vacation timing, phone requests for information have been declining. Still, the company is concerned with proper staffing during the exam days of December 17^th and 18^th.

Date	Shift	Requests
December 13	Day	70
	Evening	47
	Night	46
December 14	Day	65
	Evening	43
	Night	37
December 15	Day	59
	Evening	39
	Night	34
December 16	Day	56
	Evening	35
	Night	30

Forecast the demand for information requests for the three shifts of December 17^th and the three shifts of December 18^th. Answer the following questions in a text box in the worksheet.

A) Create a chart that shows the number of requests. Do you see both trend and seasonality components in the data?

B) Forecast the number of requests for December 17^th and December 18^th.

C) Create a second chart that shows both the requests through December 16^th and the forecasted requests for December 17^th and 18^th. Color the chart so it is easy to distinguish the actual requests from the forecast.

At the end of this problem you should have 2 charts and an answer to question A. Include and label a separate tab with your regression results.

Expert Solution