RESOURCE: Holmes, A., Illowsky, B., & Dean, S. (2017). Introductory business statistics. OpenStax. https://openstax.org/details/books/introductory-business-statistics

Heights: 62, 63, 64, 65, 66, 68, 68, 69, 70, 73, 65, 64, 64, 67, 66, 65, 66, 69, 66, 67

Step 3: Using the heights above discuss your method of collection for the values that you are using in your study (systematic, convenience, cluster, stratified, simple random). What are some faults with this type of data collection? What other types of data collection could you have used, and how might this have affected your study?

Step 4: Now use theWeek 6 Spreadsheetto help you with calculations for the following questions/statements.

a) 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 blueDatacolumn of the spreadsheet. What is your point estimate, and what does this mean?

b) Find a 95% confidence interval for the true mean height of all the people at your place of work. What is the interval? [see screenshot below]

c) 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").

d) 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 themargins oferror from the two screenshots. Would the margin of error be larger or smaller for the 99% CI? Explain your reasoning.

PLEASE ADDRESS ALL QUESTIONS AND PROVIDE SCREENSHOTS OF EXCEL SHEETS USING THESE HEIGHTS ABOVE THANK YOU IN ADVANCE