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

Answer 1

Result:

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.

Sorted data

Male at-rest	Female at-rest	Male After Exercise	Female After Exercise
85.9	76.6	87.5	88.2
67.7	79.2	79.4	90.4
80.3	80.6	93.4	101.3
85.2	75.5	97.7	93.1
86.3	83.9	99.7	90.5
76.6	73.9	83.7	89.1
94.4	76.8	101.9	90.8
86.4	85.2	100.6	93.5
83.4	82.1	97.4	93.5
89.8	76.3	97.4	87
88.7	97	97.1	104.5
78.4	81.5	87.2	86.5
71.3	65.3	79.9	86.3
92.6	80.8	104.7	86.7
86.2	78.5	95.9	89.9
83.9	86.3	93.9	97.6
78.1	89.8	90.1	92.9
64	87.8	70.7	98.5
72.8	76.2	86.7	89.9
72.7	74.2	81.2	88.8
80.2	67.4	83.3	78.8
78.2	75.5	86	80.2
70.6	80	90.2	90.2
75.5	76.4	84.4	88
82.7	94.9	94.2	95.7
87.7	89.2	95.1	96.9
80	83.3	88.7	87.7
73.4	85.8	82.7	90.4
89.5	75.3	94.6	84.1
77.6	77.9	84.6	99
76.6	70	86.4	83
85.6	88	96.2	94.2
74.2	86.9	82.1	95
79	87.1	91.6	95.9
74.6	79.3	86.7	82.7
88.8	81.2	98.8	90.7
82.1	82.9	85.6	91.9
77.6	87.4	80.6	103.6
77.9	83	83.8	90
88.1	76.8	93.9	83.3
81.6	76.9	90.3	87.7
91.2	79.8	100.6	88.2
80.3	83.2	88	93
76.7	79.5	91.8	88.6
88.4	82.4	103	89.3
75.2	80.8	86.5	84.2
75.2	83.2	84.9	94.5
73.1	71.6	71.9	81.5
77	82.8	84.7	93.1
59	76.8	68.2	92.8
84.9	93.2	96	100.4
87.5	91.4	105.9	100.9
75.6	97.3	84.3	103.3
84	88.3	90.4	90.1
78.2	80.6	94	85.2
86.6	87.4	90.6	91.7
84.9	96.5	95.1	99.3
78.8	77.9	90.4	91.6
69.4	76.1	82.6	84.1
78.3	85.2	91.1	89.7
76.9	68.6	92.3	72.8
84.2	79.4	87.9	92
76.3	85.2	85.9	99.2
86.3	74.3	99.7	85.6
72.3	74.3	80.9	89.2
81.8	78.5	93.8	98.5
92.8	80.4	99.8	90.8
74.8	82.9	90.2	85.9
91.7	78.9	99.2	90.7
71	78.6	87	87
96.1	87.5	100.2	93.9
82.5	78.9	95.1	91.4
81.9	80	97.5	89.1
89.7	80.4	94.8	89.2
81.4	88.3	100.9	93.5
74.8	80.6	94	95.9
88.1	85.8	102.1	90.5
69.2	84.6	81.4	93
78.8	80.5	90.9	91.8
85.3	92.4	94.2	101.2
74.8	84.4	81.3	96.7
77.7	82.3	89.9	86.9
78	77.2	89.8	85.8
80.5	83.3	95.3	82.1
75.4	86.2	84.8	98.9
81.5	81.3	84.2	97.7
73.9	90.2	85.2	96.4
69.4	78.4	74.1	85.5
89.4	84.7	96.7	101.6
70.9	89.7	82	94.3
82.9	78.4	90.2	88
89.6	79.9	106.7	88.5
74.5		75.6
92.3		102.2
87.7		98
78.9		89.7
79.8		81.5
85.5		97.4
87.3		94.1
77.8		97.8
71		80.1
82.5		90.7
74.8		83.7
69.2		79.4
80.5		87.4
89.4		99.2
74.5		88
85.5		92

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)

	Male at-rest	Female at-rest	Male After Exercise	Female After Exercise
Mean	80.3852	81.7696	90.2843	91.2293
Standard Error	0.6786	0.6536	0.7525	0.6166
Median	80.1	80.8	90.35	90.6
Mode	74.8	80.6	97.4	93.5
Standard Deviation	7.0525	6.2688	7.8204	5.9138
Sample Variance	49.7372	39.2980	61.1587	34.9731
Kurtosis	-0.2050	0.3909	-0.1275	0.2781
Skewness	-0.1393	0.1816	-0.2864	-0.0363
Range	37.1	32	38.5	31.7
Minimum	59	65.3	68.2	72.8
Maximum	96.1	97.3	106.7	104.5
Sum	8681.6	7522.8	9750.7	8393.1
Count	108	92	108	92
Confidence Level(95.0%)	1.3453	1.2982	1.4918	1.2247
95%Lower limit	79.0399	80.4713	88.7925	90.0046
95%Upper limit	81.7305	83.0678	91.7760	92.4541
Confidence Level(99.0%)	1.7797	1.7195	1.9735	1.6221
99%Lower limit	78.6055	80.0501	88.3107	89.6072
99%Upper limit	82.1649	83.4891	92.2578	92.8515

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.

The mean Heart rate for male at rest is 80.3852. 95% confidence interval for male at rest is (79.0399, 81.7305). The 99% CI is (78.6055, 82.1649). 99% CI is wider than 95% CI.

The mean Heart rate for female at rest is 81.7696. 95% confidence interval for male at rest is (80.4713, 83.0678). The 99% CI is (80.0501, 83.4891). Female Rate is higher than males.

The mean Heart rate for male After Exercise is 90.2843. 95% confidence interval for male at rest is (88.7925, 88.7925). The 99% CI is (88.3107, 92.2578). 99% CI is wider than 95% CI.

The mean Heart rate for female After Exercise is 91.2293. 95% confidence interval for male at rest is (90.0046, 92.4541). The 99% CI is (89.6072, 92.8515). Female Rate is higher than males.