In this problem we will examine a sample of call center call volume data. Do the following: Use a Pivot Table to calculate the average call volume, the standard deviation of call volume, and the number of calls by 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 average call volume on Mondays is greater than 725. The second claim is that 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. State a short interpretation of the result.

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