I would like step by step instructions for completing these two situations in excel. Please give rationale for choices and recommendations. For instance, why two t-tests, assuming equal and unequal variances, and or a z-test would be used for independent samples in the second problem.

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

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

For both hypothesis tests, "is lower than" (<) is a one-tailed test to the left. Sometimes Excel permits you to specify the number of tails [one (1) or two (2)], and sometimes not. If not, the Excel default is a two-tailed test, so be sure to interpret the p-value [prob-value, probability value] correctly for a one-tailed test to the left.