Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I've been asked to solve the problem below using Excel. Can you explain the steps for excel and how to best answer each question please?

I've been asked to solve the problem below using Excel. Can you explain the steps for excel and how to best answer each question please? Thank you

The operations manager at a compact fluorescent light bulb (CFL) factory needs to estimate the mean life of a large shipment of CFLs. The manufacturer's specifications are that the population standard deviation is 1,000 hours. A random sample of 64 CFLs indicated a sample mean life of 7,500 hours.

A)Construct a 95% confidence interval estimate for the population mean life of compact fluorescent light bulbs in this shipment.

B)Do you think that the manufacturer has the right to state that the compact fluorescent lightbulbs have a mean life of 8,000 hours, Explain?

C)Must you assume that the population compact fluorescent light bulb life is normally distributed? Explain?

D)Suppose that the standard deviation changes to 800 hours. What are your answers for (A) & (B)?

(Hint: for this problem for 95% confidence interval, you are finding the cumulative 2.5% and 97.5% points of the x bar that sandwiched the center 95%. you will use the observed X_bar as the mu and standard deviation / sqrt(n) as the sigma, and the same inverse normal cumulative function. Notice so far we have avoided using Z table lookup from the back of the book completely, but use excel function for all the calculation.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Recent Developments Of Mathematical Fluid Mechanics

Authors: Herbert Amann, Yoshikazu Giga, Hideo Kozono, Hisashi Okamoto, Masao Yamazaki

1st Edition

3034809395, 9783034809399

More Books

Students also viewed these Mathematics questions