Please explain step by step how to complete each problem in excel. Z-test in the first problem and two t-tests, one assuming equal variances and the other assuming unequal variances, and a z-test in the second problem. Whichever test you choose, please explain your choice.

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).