Can you please provide instructions on how to use Excel to calculate the below?

Data needed for review- Google Drive link: https://drive.google.com/file/d/1-UayXwc_f-LqLCsE7QHO71LJSIoflC6N/view?usp=sharing

Each row in the database corresponds to a different call. Column variables are as follows.

• ProtocolType: indicates protocol type, either PT or PE
• QueueTime: Time in Queue, in seconds
• ServiceTime: Service Time, in seconds

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