**** PLEASE SHOW HOW TO SOLVE IN EXCEL NOT HANDWRITTEN***
We have given sample mean=325
sample Standard Deviation=75
Size=100
In,excel
a)95% confidence interval for population mean is
We use CONFIDENCE function in excel
Confidence Interval = x ± CONFIDENCE
95% confidence interval | 310.3003 | 339.6997 |
b) 99% confidence interval for population mean is
99% confidence interval | 305.6813 | 305.6813 |
Excel work
Get Answers For Free
Most questions answered within 1 hours.