Question
I've been asked to solve using Excel. Can you please tell me the appropriate functions in excel and briefly explain what is needed with each
I've been asked to solve using Excel. Can you please tell me the appropriate functions in excel and briefly explain what is needed with each question? Thank you!
The quality-control manager at a compact fluorescent light bulb (CFL) factory needs to determine whether the mean of life of a large shipment of CFL's is equal to 7,500 hours. The population standard deviation is 1,000. A random sample of 64 CFL's indicates a sample mean life of 7,250 hours.
A)At the 0.05 level of significance, is there evidence that the mean life is different from 7,500 hours?
B)Compute the p-value and interpret its meaning?
C)Construct a 95% confidence interval estimate of the population mean life of the CFL's.
D)Compare the results of (A) and (C). What conclusions do you reach?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started