Question: Hi--I need help understanding how to do the math in the excel link listed below. That is all I need. I want to understand the

Hi--I need help understanding how to do the math in the excel link listed below. That is all I need. I want to understand the math and HOW to solve the question. I know I have to do a Z Test.

Performa test of hypothesis to determine whether the average TiQ is lower than the industry standard of 2.5 minutes (150 seconds). Use a significance level =0.05.

Evaluateif the company should allocate more resources to improve its average TiQ.

Performa test of hypothesis to determine whether the average ST with service protocol PE is lower than with the PT protocol. Use a significance level =0.05.

Assessif the new protocol served its purpose. (Hint: This should be a test of means for 2 independent groups).

summary of your conclusions.

*I do not intend to use the work as my own. I want to understand how to solve the answer in the excel sheet*

Please use this link for Data Call Wait Time Excel Sheet

https://docs.google.com/spreadsheets/d/12gSUROCba8lHYmrpHbFgZ1VcsHFT29kn_yftylKbIx0/edit?usp=sharing

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!

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) Instructor: to your instructor. The tabs (bottom of each...

MATHEMATICIANS RISE TO A CHALLENGE ne of the theorems we teach in eighth grade is a + b= *, where c is the length of the hypotenuse of a right triangle in Euclidean space, and a and b are the lengths...

This text was adapted by The Saylor Foundation under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 License without attribution as requested by the work's original creator or licensee. 1...

Please read chapter 6 and answer the questions and see the ( guide to answer number 3) For each case study, you will view the material as the student's teacher, read the information provided and...

Please read chapter 6 and answer the questions and see the ( guide to answer number 3) 1. Decide what assessment you would like to do to provide you with more information about the student, 2....

Please read and First, choose Five terms or concepts from the chapter that you are going to "Identify" 1. Define the term (using your own words or the book's definition). 2. Provide and example or...

Summarize the following chapter: (Basic Elements of Planning and Decision Making) Obviously, insurance companies incur immense risks because of the number of policies they issue, but you may not know...

Make the summary of the following chapter "Basic Elements of Planning and Decision Making" . Obviously, insurance companies incur immense risks because of the number of policies they issue, but you...

Current and historical Financial Statements (Income Statement (I/S), Balance Sheet (B/S) and Statement of Cash Flows) from the three most current years for the firm The financial statements must...

Practice makes perfect so make sure to practice your math skills regularly if you want to keep improving your understanding and problem solving abilities Read and understand the problem carefully....

Refer to Asokans Golden Brown Pancake Restaurant in E6-32A. Requirements 1. Use Microsoft Excel to perform regression analysis on Asokans monthly data. Based on the output, write Asokans monthly...

What purpose(s) might be served by using each of the following priority rules for allocating scarce resources? a. As late as possible b. Shortest task duration time first c. Minimum slack first

Case 2 Ricky is reviewing his estate plan. He and his wife, Anita, have the following assets registered in joint title with the right of survivorship: Personal residence FMV $ 3 8 0 , 0 0 0 and ACB $...

Human Resource professionals are responsible for planning all aspects of people within the organization. What are some inside and outside factors that impact the ability to plan people's functions...

2. Find five metaphors for communication.

5. Starting with a motive you may have for acting the way you do in a particular situation: a) What purpose did you seek to achieve? b) Which aspects of your past and your surroundings influenced...

3. (Constructing a metaphor about something can be done by comparing it to something else by using the word is. For instance, Communication is a bridge between people.