Please answer in Excel so I can understand the formulas. 10.11 An important feat
ID: 3222511 • Letter: P
Question
Please answer in Excel so I can understand the formulas.
10.11 An important feature of tablets is battery life, the num-ber of hours before the battery needs to be recharged. The file Tablets contains the battery life of 12 WiFi-only and 7 3G/4G/WiFi 9- through 12-inch tablets. (Data extracted from “Ratings and rec-ommendations: Tablets,” Consumer Reports, August 2013, p. 24.)
a. Assuming that the population variances from both types of tablets are equal, is there evidence of a difference in the mean battery life between the two types of tablets? Use a=0.05.
b. Determine the p-value in (a) and interpret its meaning.
c. Assuming that the population variances from both types of tablets are equal, construct and interpret a 95% confidence interval estimate of the difference between the population mean battery life of the two types of tablets.
Explanation / Answer
H0 : µ1 =µ2 VS
H1 : µ1µ2
11 x (1.3637) ^2 + 6 x (0.9873) ^2 / (11 + 6) = 1.547
df=17
Therefore, it can be concluded that there is sufficient evidence to support that the mean battery life of two types of tablets are equal.
Therefore, it can be concluded that there is insufficient evidence to support that the mean battery life between the two types of tablets is different.
a] To test hypothesis ,H0 : µ1 =µ2 VS
H1 : µ1µ2
Under the null hypothesis the test statistics is, X1bar 10.62 X2bar 11.01 S1 1.3637 S2 0.9837 n1 12 n2 7 Sp^2 =11 x (1.3637) ^2 + 6 x (0.9873) ^2 / (11 + 6) = 1.547