Step 3: Using the data you collected for the Week 5 Lab (heights of 10 different people that you work with), discuss your method of collection for the values that you are using in your study. What are some faults with this type of data collection? What other type of data collection could you have used, and how might this have affected your study?

Step 4: Now use the Week 6 Spreadsheet (Links to an external site.) to help you with calculations for the following questions/statements.

Give a point estimate for the average height of all people at the place where you work. Start by putting the ten heights you are working with into the blue Data column of the spreadsheet. What is your point estimate, and what does this mean?

example of adding a point estimate to spreadsheet
Find a 95% confidence interval for the true mean height of all the people at your place of work. What is the interval?

example of finding 95 percent confidence interval in spreadsheet
Give a practical interpretation of the interval you found in part b, and explain carefully what the output means. (For example, you might say, “I am 95% confident that the true mean height of all of the people 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, find a 99% confidence interval for the same data. Would the margin of error be larger or smaller for the 99% CI? Explain your reasoning.

Step 6: Save the Week 7 Lab document with your answers and include your name in the title.

Step 7: Submit the document.