Question: 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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Q:

Case Analysis 1. Compute the yield to maturity of Land'o'Toys' bonds before the purchase announcement and use it to determine the likely current bond rating. (Compare YTM to the table on p. 269)....

Q:

Hi, I am doing a project for derivatives class and I have some questions about a regression and Monte Carlo simulation that I need to come up with. So the goal is to hedge against CDS instruments by...

Q:

I need to see the SPSS output. You need to have all z-scores, all charts, all descriptives data from SPSS, everything you used to answer the questions. I am sending you what the previous tutor sent...

Q:

Here is the end-of-year account balance information from the accounting records of Jaunty Coffee Company: Sales revenue Cash Cost of goods sold Accounts payable Capital stock Dividends Retained...

Q:

The following data was collected for the distance traveled versus time for a rocket: Use numerical differentiation to estimate the rockets velocity and acceleration at each time. 125 25 50 100 t, s...

Q:

Can a person who is a Type A change if so, how?

Q:

=+31. E-security. A report released by the Pew Internet & American Life Project entitled The Internet & Consumer Choice focused on current online issues. Respondents were asked to indicate their...

Q:

New Business Ventures, Inc has an outstanding perpetual bond with a 10 percent coupon rate that can be called in one year. The bond makes annual coupon payments. The call premium is set is set at...

Q:

For separating small pieces of metal from engine oil of a car, the best separating technique is the Chromatography Evaporation Filtration Fractional distillation

Q:

Park Ltd is a retail company based in Shanghai. The company has a subsidiary, Sung Ltd, which complements the parent business in the retailing process. Jing, the Group Accountant, has asked you to...

Q:

Excel worksheet preference for this case study. In this CaseWilkins,A Zurn Company: Demand Forecasting,Wilkins competes in a seasonal commodity market with the peak demand happening in the fiscal...

Q:

Matrix Inc performs following job and it wants you to compute Actual Costing and Nominal Costing Based on following info:

Q:

Question 18 2 Points As a result of continuously measuring and evaluating their performance, Dana Pastries identified five areas that require improvement. Accordingly, they launched a new initiative...

Q:

Debate the following statement: 'Big Data' and the buzz of the so-called 'green marketing' and 'sustainable marketing' are being used nowadays by marketing professionals to increase the grip and the...

Q:

Required neat and clear handwritten solution with all steps. Knowing that a = 0.14 m, b = 0.54 m, c= 0.35 m and F = 3.6 kN, determine the magnitude of the force at point B. A B F KN C D bm am bm EO cm

Q:

Write a MATLAB script to visualize a 3 D plot of a parametric surface representing a spherical spiral. The parametric equations for a spherical spiral are given by: x ( ? , \ theta ) = Rsin ( ? ) cos...

Q:

The three accounts shown below appear in the general ledger of Herrick Corp. during 2017. Equipment Date????? Debit Credit Balance Jan. 1 Balance 160,000 July 31 Purchase of equipment 70,000 230,000...

Q:

During 2012, Cheng Book Store paid $483,000 for land and built a store in Georgetown. Prior to construction, the city of Georgetown charged Cheng $1,300 for a building permit, which Cheng paid. Cheng...

Q:

Consider an n server system where the service times of server i are exponentially distributed with rate i, i = 1,..., n. Suppose customers arrive in accordance with a Poisson process with rate , and...

Q:

Consider a time reversible continuous-time Markov chain having infinitesimal transition rates qi j and limiting probabilities {Pi}. Let A denote a set of states for this chain, and consider a new...

Q:

A hospital accepts k different types of patients, where type i patients arrive according to a Poisson proccess with rate i , with these k Poisson processes being independent. Type i patients spend an...