Management Assignment

ArrivalsData_IntegratedInfo300IntegratedAssignment1.xlsx

Sheet1

	Number of Visitors 5/26 to 6/29 Requiring Day of Visit Tickets
Period	Date	Day	Visitors	Day	Index	intercept	1000
1	26-May	Mon	641	Mon	0.7	slope	100
2	27-May	Tue	583	Tue	0.7
3	28-May	Wed	1,433	Wed	0.8	stdev	400
4	29-May	Thu	999	Thu	0.8
5	30-May	Fri	1,165	Fri	0.95
6	31-May	Sat	3,311	Sat	1.5
7	1-Jun	Sun	3,244	Sun	1.55
8	2-Jun	Mon	1,332		7
9	3-Jun	Tue	894
10	4-Jun	Wed	2,072
11	5-Jun	Thu	2,112
12	6-Jun	Fri	2,940
13	7-Jun	Sat	3,167
14	8-Jun	Sun	3,279
15	9-Jun	Mon	1,255
16	10-Jun	Tue	1,784
17	11-Jun	Wed	2,209
18	12-Jun	Thu	1,485
19	13-Jun	Fri	2,959
20	14-Jun	Sat	4,740
21	15-Jun	Sun	4,878
22	16-Jun	Mon	2,540
23	17-Jun	Tue	2,187
24	18-Jun	Wed	2,802
25	19-Jun	Thu	2,509
26	20-Jun	Fri	3,506
27	21-Jun	Sat	5,486
28	22-Jun	Sun	5,257
29	23-Jun	Mon	2,762
30	24-Jun	Tue	2,568
31	25-Jun	Wed	3,228
32	26-Jun	Thu	3,774
33	27-Jun	Fri	4,282
34	28-Jun	Sat	6,176
35	29-Jun	Sun	6,884