Question: Need help with lab using week 6 confidence interval excel Give a point estimate (mean) for the average height of all people at the place
Need help with lab using week 6 confidence interval excel
Give a point estimate (mean) for the average height of all people at the place where you work. Start by putting the 20 heights you are working with into the blue Datacolumn of the spreadsheet. What is your point estimate, and what does this mean? 66 65 66 67 62 70 69 68 71 78 61 62.5 64 64.2 64.3 58 60 63 65 66.2
Find a 95% confidence interval for the true mean height of all the people at your place of work. Whatis the interval?
Give a practical interpretation of the interval you found in part b, and explain carefully what the outputmeans. (For example, you might say, "I am 95% confident that the true mean height of all of thepeople in my company is between 64 inches and 68 inches").
Post a screenshot of your work from the t value Confidence Interval for from the Confidence Interval tab on the Week 6 Excel spreadsheet
Step 5: Now, change your confidence level to 99% for the same data, and post a screenshot of this table, as well.
Step 6: Compare the margins of error from the two screenshots. Would the margin of error be larger or smaller for the 99% CI? Explain your reasoning.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
