i have also attached week 6 spreadsheet

Week 7 Lab Assignment

Name:________________________   Instructor Name: _______________

Please use this template to help answer the questions listed in the lab instructions. The “steps” below refer to the steps listed in the lab instructions. Type your answers and post your screenshots in the spaces given.

1.   Write a paragraph summarizing what you learned from the articles provided. Consider the use of confidence intervals in health sciences with these articles as inspiration and insights.

You will need

·       your Week 5 Lab Data!!

·       the Week 6 Spreadsheet from the Week 6 Lesson: From Samples to Populations or the Getting Started module under Resources.

Step 1: Article Summaries

A. Quick summary of 1st article:

B. Quick summary of 2nd article:

C. Consider the use of confidence intervals in health sciences with these articles as inspiration and insights for the rest of the lab

Data Collection

Use the data set you collected for the Week 5 lab (heights of 10 different people plus the 10 heights provided by your instructor). (NOTE:  This is NOT the data used in the lab video at the bottom of this assignment, which is about midterm grades. Do NOT use the midterm grades data.)

Provide a screenshot of your Week 5 Data (20 Heights) from the Week 6 Spreadsheet (be sure that your mean, standard deviation, and all 20 data values from the spreadsheet are visible).

Summarize the Preliminary Calculations (Round to 2 decimal places):

Sample Mean: ______

Standard Deviation: _______

Your Height: _________

Please answer the following questions in complete sentences:

1.    Discuss your method of collection for the values that you are using in your study (systematic, convenience, cluster, stratified, simple random). What makes it this method?

2.    What are some faults with this type of data collection?

3.   What other types of data collection could you have used, and how might this have affected your study?

Calculation of 95% Confidence Interval

1.   Give a point estimate (mean) for the average height of all people in the place from which you pulled your data (use all 20 of your lab values to find this). What is your point estimate, and what does this mean?

2.   Find a 95% confidence interval for the true mean of heights. What is the interval? [Provide a Screenshot of your work from the t value Confidence Interval for µ from the Confidence Interval tab on the Week 6 Excel spreadsheet]

3.    Give a practical interpretation of the 95% confidence interval (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"). [Write a complete sentence].

Calculation of 99% Confidence Interval

Now, change your confidence level to 99% on the Excel spreadsheet for the same data.

1.   Find a 99% confidence interval for the true mean of heights. What is the interval? [Provide a Screenshot of your work from the t value Confidence Interval for µ from the Confidence Interval tab on the Week 6 Excel spreadsheet]

2.    Give a practical interpretation of the 99% confidence interval [Write a complete sentence].

Compare Margins of Error

1.   Would the margin of error be larger or smaller for the 99% CI? Explain your reasoning.

2.   As the confidence level increases, what happens to the Margin of Error, and why does this happen?

Save and Submit

Be sure your name is on the Word document, save it, and then submit it. In the assignment module, click “start assignment” and then “upload file” and “submit assignment”.