Please show work in excel/ explain how you did it so I can try to do it as well.

Thank you!

A consumer advocate researches the length of life between two brands of refrigerators, Brand A and Brand B. He collects data {measured in years] on the longevity of 40 refrigerators for Brand A and repeats the sampling for Brand B. These data are measured in years. {You may nd it useful to reference the appropriate table: 2 table or 1' table} Brand A Brand 3- Brand A Brand 5 12 14 25 24 23 14 1? 1? 24 13 13 23 14 14 13 21 24 13 1? 13 22 24 13 25 12 19 1? 13 15 25 13 14 15 14 14 25 12 2B 13 22 12 19 13 25 2B 13 14 24 13 25 13 19 19 13 15 19 25 19 22 21 2B 24 1? 22 19 14 13 19 13 12 16 13 14 14 1? 19 21 12 1? 22 Click here for the Excel Data File Assume that {.11 is the mean longevity for Brand A and 1.12 is the mean longevity for Brand B. a. Select the competing hypotheses to test whether the average length of life differs between the two brands. OHa=#1-#2=BEHA=P1-#2*B OHa=#1-#229i,q=rr1-#20 b-1. Calculate the value of the test statistic. Assume that (.542 = 4.5 and 052 = 5.8. [Negative values should be indicated by a minus sign. Round intermediate calculations to at least 4 decimal places and nal answer to 2 decimal places.) b-2. Find the p-value. O p-value