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