3. A hospital usually measures the weight of its patients (to make better medical decisions). The hospital wants to build a new hospital and to plan the facility requirements, knowing approximately the average weight of its patients is in what range is very useful. As a data analyst you have access to a random sample of 200 patients, and you know that the average weight of these patients is 80kg. Then answer the following questions: 3.a Calculate the Estimated Standard Deviation of the population mean (the average weight of patients). [You need to do this part in excel and then write down here the formula you used in excel and the answer you got.] 3.b Calculate the margin of error for estimating an interval for the population mean such that your estimation will have 90% of confidence. [You need to do this part in excel and then write down here the formula you used in excel and the answer you got.] 3.c Calculate a lower limit and Upper limit for the population mean using the calculated margin of error in previous part. [You need to do this part in excel and then write down here the formula you used in excel and the answer you got.]
3. A hospital usually measures the weight of its patients (to make better medical decisions). The hospital wants to build a new hospital and to plan the facility requirements, knowing approximately the average weight of its patients is in what range is very useful. As a data analyst you have access to a random sample of 200 patients, and you know that the average weight of these patients is 80kg. Then answer the following questions:
3.a Calculate the Estimated Standard Deviation of the population mean (the average weight of patients). [You need to do this part in excel and then write down here the formula you used in excel and the answer you got.]
3.b Calculate the margin of error for estimating an interval for the population mean such that your estimation will have 90% of confidence. [You need to do this part in excel and then write down here the formula you used in excel and the answer you got.]
3.c Calculate a lower limit and Upper limit for the population mean using the calculated margin of error in previous part. [You need to do this part in excel and then write down here the formula you used in excel and the answer you got.]
No data set provided - Must use excel to calculate answers
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 10 images
