Instructions:: In this assignment,you will calculate confidence intervals for th

Question

Instructions:: In this assignment,you will calculate confidence intervals for the quantitative variables in the Heart Rate database.

Steps:

1. Open the Heart Rate database in Excel and identify the quantitative variables

2. Make sure the data is sorted by category, e.g., male at-rest, female at-rest, etc.

3. Use the Data Analysis tools to construct 95% and 99% confidence intervals for all of the sorted quantitative variables. Please note that the statistic being used is the confidence interval of the means, which requires the use of the Standard Error of the mean (not the standard deviation of the mean)

4. Create a Word document, using your calculated Excel results, to describe the expected value and range for each of the variables. Make certain you note and explain any differences in the means of the variables, and any effect of changing the level of confidence.

Heart Rate Database

Heart rate before and after exercise M=0 F=1 Resting After Exercise 0 85.9 87.5 0 67.7 79.4 0 80.3 93.4 0 85.2 97.7 0 86.3 99.7 0 76.6 83.7 0 94.4 101.9 0 86.4 100.6 0 83.4 97.4 0 89.8 97.4 0 88.7 97.1 0 78.4 87.2 0 71.3 79.9 0 92.6 104.7 0 86.2 95.9 0 83.9 93.9 0 78.1 90.1 0 64.0 70.7 0 72.8 86.7 0 72.7 81.2 0 80.2 83.3 0 78.2 86.0 0 70.6 90.2 0 75.5 84.4 0 82.7 94.2 0 87.7 95.1 0 80.0 88.7 0 73.4 82.7 0 89.5 94.6 0 77.6 84.6 0 76.6 86.4 0 85.6 96.2 0 74.2 82.1 0 79.0 91.6 0 74.6 86.7 0 88.8 98.8 0 82.1 85.6 0 77.6 80.6 0 77.9 83.8 0 88.1 93.9 0 81.6 90.3 0 91.2 100.6 0 80.3 88.0 0 76.7 91.8 0 88.4 103.0 0 75.2 86.5 0 75.2 84.9 0 73.1 71.9 0 77.0 84.7 0 59.0 68.2 0 84.9 96.0 0 87.5 105.9 0 75.6 84.3 0 84.0 90.4 0 78.2 94.0 0 86.6 90.6 0 84.9 95.1 0 78.8 90.4 0 69.4 82.6 0 78.3 91.1 0 76.9 92.3 0 84.2 87.9 0 76.3 85.9 0 86.3 99.7 0 72.3 80.9 0 81.8 93.8 0 92.8 99.8 0 74.8 90.2 0 91.7 99.2 0 71.0 87.0 0 96.1 100.2 0 82.5 95.1 0 81.9 97.5 0 89.7 94.8 0 81.4 100.9 0 74.8 94.0 0 88.1 102.1 0 69.2 81.4 0 78.8 90.9 0 85.3 94.2 0 74.8 81.3 0 77.7 89.9 0 78.0 89.8 0 80.5 95.3 0 75.4 84.8 0 81.5 84.2 0 73.9 85.2 0 69.4 74.1 0 89.4 96.7 0 70.9 82.0 0 82.9 90.2 0 89.6 106.7 0 74.5 75.6 0 92.3 102.2 0 87.7 98.0 0 78.9 89.7 0 79.8 81.5 0 85.5 97.4 0 87.3 94.1 0 77.8 97.8 0 71.0 80.1 0 82.5 90.7 0 74.8 83.7 0 69.2 79.4 0 80.5 87.4 0 89.4 99.2 0 74.5 88.0 0 85.5 92.0 1 76.6 88.2 1 79.2 90.4 1 80.6 101.3 1 75.5 93.1 1 83.9 90.5 1 73.9 89.1 1 76.8 90.8 1 85.2 93.5 1 82.1 93.5 1 76.3 87.0 1 97.0 104.5 1 81.5 86.5 1 65.3 86.3 1 80.8 86.7 1 78.5 89.9 1 86.3 97.6 1 89.8 92.9 1 87.8 98.5 1 76.2 89.9 1 74.2 88.8 1 67.4 78.8 1 75.5 80.2 1 80.0 90.2 1 76.4 88.0 1 94.9 95.7 1 89.2 96.9 1 83.3 87.7 1 85.8 90.4 1 75.3 84.1 1 77.9 99.0 1 70.0 83.0 1 88.0 94.2 1 86.9 95.0 1 87.1 95.9 1 79.3 82.7 1 81.2 90.7 1 82.9 91.9 1 87.4 103.6 1 83.0 90.0 1 76.8 83.3 1 76.9 87.7 1 79.8 88.2 1 83.2 93.0 1 79.5 88.6 1 82.4 89.3 1 80.8 84.2 1 83.2 94.5 1 71.6 81.5 1 82.8 93.1 1 76.8 92.8 1 93.2 100.4 1 91.4 100.9 1 97.3 103.3 1 88.3 90.1 1 80.6 85.2 1 87.4 91.7 1 96.5 99.3 1 77.9 91.6 1 76.1 84.1 1 85.2 89.7 1 68.6 72.8 1 79.4 92.0 1 85.2 99.2 1 74.3 85.6 1 74.3 89.2 1 78.5 98.5 1 80.4 90.8 1 82.9 85.9 1 78.9 90.7 1 78.6 87.0 1 87.5 93.9 1 78.9 91.4 1 80.0 89.1 1 80.4 89.2 1 88.3 93.5 1 80.6 95.9 1 85.8 90.5 1 84.6 93.0 1 80.5 91.8 1 92.4 101.2 1 84.4 96.7 1 82.3 86.9 1 77.2 85.8 1 83.3 82.1 1 86.2 98.9 1 81.3 97.7 1 90.2 96.4 1 78.4 85.5 1 84.7 101.6 1 89.7 94.3 1 78.4 88.0 1 79.9 88.5 One Population Statistics Hypothesis test calculator Hypothetical Value Sample Statisticx-mean15enter enter 15 Sample Size n 150 enter Sample Standard Deviation enter 0 Difference between sample value and Hypothetical value Standard Error of Statistic SE 0.1633 -score 50% 50% 1.0000 value lower (Probability the mean is more than Hypothetical Value) p-value upper (Probaility the mean is less than Hypothetical value) Two-tailed test p-value z-score CL 1.6451 1.96| 2.576| 90% 95% 99% Only enter data in the dark-colored cells; the remaining cells are locked and calculate automatically. If you delete a formula, reload the calculator from your classroom, or a clean saved file Confidence Intervals using z-scores CL 90% upper 1.645lower 15.27 14.73 CL 95% upper 1.96 lower 15.32 14.68 CL 99% upper 2.576 lower 15.42 23 14.58

Explanation / Answer

In this assignment,you will calculate confidence intervals for the quantitative variables in the Heart Rate database.

Steps:

1. Open the Heart Rate database in Excel and identify the quantitative variables

The quantitative variable is heart rate before and after exercise.

Now we have to find 95% and 99% confidence interval for population mean difference.

95% confidence interval for population mean difference is,

d - E < D < d + E

where d is sample mean difference between before and after exercise.

E is margin of error.

By using excel we will find confidence interval.

95% CI for mean difference: (-10.304, -9.090)

99% CI for mean difference: (-10.498, -8.896)

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.