Question

In this assignment, you will test for a significant difference between the average resting heart rate of males and the average resting heart rate of females in your heart rate data. You have observed that the mean rates are not exactly the same but are they significantly different? You may use either of the two methods for testing a hypothesis illustrated in Realizeit: compare the two confidence intervals or use the data analysis tool to run a two-sample test with unequal variances as shown in the topic of testing two-samples. Steps Write the null hypotheses being tested Run the analysis either by using data analysis and the two-sample test or by comparing the two confidence intervals Interpret your data to determine if the resting male heart rate is the same as the resting female heart rate. Remember we are looking for whether the difference is a significant one, not just whether they are not the same.

Heart rate before and after exercise
M=0 F=1	Resting	After Exercise
0	60.1	78.0
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

1	66.6	88.2
1	79.2	90.4
1	80.5	101.3
1	75.4	93.1
1	83.7	90.5
1	73.9	89.1
1	76.0	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	60.8	86.7
1	78.5	89.9
1	60.4	97.6
1	89.8	92.9
1	87.8	98.5

Answer 1

The hypothesis being tested is:

H0: µ1 = µ2

H1: µ1 > µ2

The Excel output is:

t-Test: Two-Sample Assuming Unequal Variances
	Male	Female
Mean	81.44167	77.77778
Variance	94.08265	96.70771
Observations	12	18
Hypothesized Mean Difference	0
df	24
t Stat	1.007961
P(T<=t) one-tail	0.161764
t Critical one-tail	1.710882
P(T<=t) two-tail	0.323528
t Critical two-tail	2.063899

The p-value is 0.1620.

Since the p-value (0.1620) is greater than the significance level (0.05), we fail to reject the null hypothesis.

Therefore, we can conclude that the resting male heart rate is the same as the resting female heart rate.