Problem 2

In this problem, we will examine a sample of call center call volume data. This data is presented in Tab 2 of the data set. Do the following:

• Use a Pivot Table to calculate the average call volume and the standard deviation of call volume by Day of the Week. Include only non-holiday calls. Also include in the pivot table the number of observations, i.e., the number of records for each day of the week.

Management is working on staffing plans based on average call volume. They would like to evaluate 2 claims made by the call center manager. The first claim is that the average call volume on Mondays is greater than 725. The second claim is that the average call volume on Fridays is less than 475. For each hypothesis do the following:

• State the null and alternative hypothesis
• Determine the critical t value for the test for an = .05 level test.
• Calculate the test statistic
• Calculate the p-value
• State your conclusion.
• Evaluate and summarize the results.

Date	Day	DOW	Holiday	Calls
6/2	1	1-Monday	0	796
6/3	2	2-Tuesday	0	704
6/4	3	3-Wednesday	0	553
6/5	4	4-Thursday	0	563
6/6	5	5-Friday	0	517
6/9	8	1-Monday	0	763
6/10	9	2-Tuesday	0	662
6/11	10	3-Wednesday	0	569
6/12	11	4-Thursday	0	559
6/13	12	5-Friday	0	466
6/16	15	1-Monday	0	730
6/17	16	2-Tuesday	0	668
6/18	17	3-Wednesday	0	549
6/19	18	4-Thursday	0	535
6/20	19	5-Friday	0	497
6/23	22	1-Monday	0	772
6/24	23	2-Tuesday	0	646
6/25	24	3-Wednesday	0	678
6/26	25	4-Thursday	0	576
6/27	26	5-Friday	0	529
6/30	29	1-Monday	0	721
7/1	30	2-Tuesday	0	637
7/2	31	3-Wednesday	0	523
7/3	32	4-Thursday	0	566
7/4	33	5-Friday	1	32
7/7	36	1-Monday	0	761
7/8	37	2-Tuesday	0	659
7/9	38	3-Wednesday	0	609
7/10	39	4-Thursday	0	558
7/11	40	5-Friday	0	474
7/14	43	1-Monday	0	773
7/15	44	2-Tuesday	0	643
7/16	45	3-Wednesday	0	556
7/17	46	4-Thursday	0	596
7/18	47	5-Friday	0	414
7/21	50	1-Monday	0	713
7/22	51	2-Tuesday	0	558
7/23	52	3-Wednesday	0	495
7/24	53	4-Thursday	0	505
7/25	54	5-Friday	0	423
7/28	57	1-Monday	0	637
7/29	58	2-Tuesday	0	589
7/30	59	3-Wednesday	0	572
7/31	60	4-Thursday	0	467
8/1	61	5-Friday	0	388
8/4	64	1-Monday	0	888
8/5	65	2-Tuesday	0	719
8/6	66	3-Wednesday	0	628
8/7	67	4-Thursday	0	677
8/8	68	5-Friday	0	482
8/11	71	1-Monday	0	693
8/12	72	2-Tuesday	0	613
8/13	73	3-Wednesday	0	676
8/14	74	4-Thursday	0	611
8/15	75	5-Friday	0	485
8/18	78	1-Monday	0	849
8/19	79	2-Tuesday	0	695
8/20	80	3-Wednesday	0	626
8/21	81	4-Thursday	0	599
8/22	82	5-Friday	0	515
8/25	85	1-Monday	0	735
8/26	86	2-Tuesday	0	683
8/27	87	3-Wednesday	0	608
8/28	88	4-Thursday	0	528
8/29	89	5-Friday	0	402
9/1	92	1-Monday	1	44
9/2	93	2-Tuesday	0	848
9/3	94	3-Wednesday	0	690
9/4	95	4-Thursday	0	581
9/5	96	5-Friday	0	438
9/8	99	1-Monday	0	746
9/9	100	2-Tuesday	0	644
9/10	101	3-Wednesday	0	567
9/11	102	4-Thursday	0	482
9/12	103	5-Friday	0	402
9/15	106	1-Monday	0	652
9/16	107	2-Tuesday	0	591
9/17	108	3-Wednesday	0	597
9/18	109	4-Thursday	0	485
9/19	110	5-Friday	0	426
9/22	113	1-Monday	0	665
9/23	114	2-Tuesday	0	567
9/24	115	3-Wednesday	0	498
9/25	116	4-Thursday	0	511
9/26	117	5-Friday	0	415
9/29	120	1-Monday	0	688
9/30	121	2-Tuesday	0	518
10/1	122	3-Wednesday	0	551
10/2	123	4-Thursday	0	474
10/3	124	5-Friday	0	413
10/6	127	1-Monday	0	713
10/7	128	2-Tuesday	0	588
10/8	129	3-Wednesday	0	526
10/9	130	4-Thursday	0	571
10/10	131	5-Friday	0	465
10/13	134	1-Monday	0	618
10/14	135	2-Tuesday	0	638
10/15	136	3-Wednesday	0	527
10/16	137	4-Thursday	0	524
10/17	138	5-Friday	0	453
10/20	141	1-Monday	0	579
10/21	142	2-Tuesday	0	607
10/22	143	3-Wednesday	0	545
10/23	144	4-Thursday	0	518
10/24	145	5-Friday	0	466
10/27	148	1-Monday	0	759
10/28	149	2-Tuesday	0	602
10/29	150	3-Wednesday	0	603
10/30	151	4-Thursday	0	556
10/31	152	5-Friday	0	470
11/3	155	1-Monday	0	870
11/4	156	2-Tuesday	0	678
11/5	157	3-Wednesday	0	649
11/6	158	4-Thursday	0	671
11/7	159	5-Friday	0	520
11/10	162	1-Monday	0	764
11/11	163	2-Tuesday	0	651
11/12	164	3-Wednesday	0	591
11/13	165	4-Thursday	0	552
11/14	166	5-Friday	0	521
11/17	169	1-Monday	0	863
11/18	170	2-Tuesday	0	777
11/19	171	3-Wednesday	0	635
11/20	172	4-Thursday	0	658
11/21	173	5-Friday	0	546
11/24	176	1-Monday	0	739
11/25	177	2-Tuesday	0	620
11/26	178	3-Wednesday	0	569
11/27	179	4-Thursday	1	21
11/28	180	5-Friday	1	52
12/1	183	1-Monday	0	852
12/2	184	2-Tuesday	0	695
12/3	185	3-Wednesday	0	650
12/4	186	4-Thursday	0	561
12/5	187	5-Friday	0	549
12/8	190	1-Monday	0	853
12/9	191	2-Tuesday	0	644
12/10	192	3-Wednesday	0	598
12/11	193	4-Thursday	0	588
12/12	194	5-Friday	0	432
12/15	197	1-Monday	0	740
12/16	198	2-Tuesday	0	603
12/17	199	3-Wednesday	0	603
12/18	200	4-Thursday	0	535
12/19	201	5-Friday	0	467
12/22	204	1-Monday	0	557
12/23	205	2-Tuesday	0	424
12/24	206	3-Wednesday	1	32
12/25	207	4-Thursday	1	4
12/26	208	5-Friday	1	61
12/29	211	1-Monday	0	272
12/30	212	2-Tuesday	0	200
12/31	213	3-Wednesday	1	80