See attached data file.
Text: Data Analysis & Decision Making with Microsoft® Excel, Rev 3e, S. Christian Albright, Wayne L.Winston, Christopher J. Zappe
Chapter 10 - Problem 16
A large buyer of household batteries wants to decide which of two equally priced brands to purchase. To do this, he takes a random sample of 100 batteries of each brand. The lifetimes, measured in hours, of the randomly chosen batteries are recorded in the file P10_16.xlsx.
a. Using the given sample data, generate a 95% confidence interval for the difference between the mean lifetimes of brand 1 and brand 2 batteries. Based on this confidence interval, which brand should the buyer purchase?
b. Using the given sample data, generate a 99% confidence interval for the difference in the mean lifetimes of brand 1 and brand 2 batteries. Based on this confidence interval, which brand should the buyer purchase?
c. How can your analyses in parts a and b be related to hypothesis testing?© BrainMass Inc. brainmass.com June 4, 2020, 1:02 am ad1c9bdddf
This solution provides assistance with the attached statistics problems regarding random sampling.