A consumer advocate researches the length of life between two brands

question.xlsx

10.15

15. A consumer advocate researches the length of life between two brands of refrigerators, Brand A and Brand B. He collects data on the longevity of 40 refrigerators for Brand A and repeats the sampling for Brand B. The data are measured in years.
Brand A	Brand B
16	16
14	20
17	18	a. Specify the competing hypotheses to test whether the average length of life differs between the two brands.
19	15	b. Using the appropriate commands in Excel, find the value of the test statistic. Assume that σ2A = 4.4 and σ2B = 5.2 . What is the p-value?
19	19	c. At the 5% significance level, what is the conclusion?
20	21
12	21
16	18
19	20
14	19
15	15
13	13
13	16
15	15
15	19
12	17
15	18
16	16
17	16
16	20
16	12
16	19
19	16
16	15
16	20
16	18
21	14
18	17
21	18
15	17
20	18
13	16
18	18
18	14
21	15
16	20
16	23
18	15
16	16
18	17