Question

The cost of ink cartridges for inkjet printers can be substantial over the life of a printer. Printer manufacturers publish the number of pages that can be printed from an ink cartridge in an effort to attract customers. A company claims that its black ink cartridge will yield an average 2 comma 387 pages. To test this​ claim, an independent lab measured the page count of 62 cartridges and found the average page count to be 2 comma 211.4. Assume the standard deviation for this population is 221. Complete parts a and b.

a. Create a 95​% confidence interval.

Answer: 2,156.39 < x < 2,266.41

b. Does this sample support the​ company's claim?

Answer: If the​ company's claim is within the limits of the confidence​ interval, then it can be concluded that the​ company's claim is supported by these findings. Use this information to draw a conclusion.

Above are the questions and answers. Please provide all Excel formulas (not calculations) that get to these answers.

Answer 1