Question

Body size typically has an effect on an individual's resting heart rate, with increased body mass negatively correlated with heart rate. To determine the influence of sex and age on this relationship, you measured the body mass and heart rate of a population of adolescent and adult males and females using a standard ECG. Your results are listed in this table.

Sex	Age Group	Resting Heart Rate (bpm)	Body Mass (kg)
Female	adolescent	72	40.91
Female	adolescent	70	52.85
Female	adolescent	68	36.36
Female	adolescent	77	42.73
Female	adolescent	85	34.00
Female	adolescent	80	31.82
Female	adolescent	62	40.00
Female	adolescent	58	43.70
Female	adult	60	54.55
Female	adult	66	50.00
Female	adult	62	72.00
Female	adult	57	68.18
Female	adult	38	59.09
Female	adult	54	56.82
Female	adult	58	55.45
Female	adult	82	77.01
Male	adolescent	51	72.73
Male	adolescent	75	36.36
Male	adolescent	72	40.91
Male	adolescent	79	40.91
Male	adolescent	80	53.00
Male	adolescent	82	34.98
Male	adolescent	69	40.00
Male	adolescent	48	48.32
Male	adult	70	65.33
Male	adult	55	79.55
Male	adult	44	78.18
Male	adult	83	70.35
Male	adult	59	81.82
Male	adult	66	84.09
Male	adult	56	90.91
Male	adult	72	75.23

Answer the following multi-part questions:

What is the mean heart rate for all participants in this study?

What is the standard error of heart rate for all participants in this study?

What is the mean heart rate for females in this study?

What is the standard deviation of heart rate for males in this study?

What is the standard error of heart rate for adolescents in this study?

What is the mean body mass for all participants in this study?

Is body mass significantly different between males and females?

Is body mass significantly different between adults and adolescents?

Is body mass significantly different between adolescents males and females?

Is heart rate significantly correlated with body mass?

Construct a graph in a new sheet that shows the mean ± SEM of males and females

Construct a graph in a new sheet that shows the mean ± SEM of all four groups

Construct a graph in a new sheet that shows the relationship between body mass and heart rate for all individuals

Construct a graph in a new sheet that shows the relationship between body mass and heart rate for all males and for females.

Answer 1

I used Excel to solve this question.

First import this data in excel sheet.

Que.1

Mean heart rate for all participants in this study = AVERAGE(C2:C33) = 65.9375

Que.2

Standard error of heart rate for all participants in this study =

where SD = standard deviation is computed using function =STDEV(C2:C33) =12.16271

SE = 12.616271 / srqt(32) = 2.15008

Que.3

To compute Mean heart rate for females in this study, use filter to SEX variable.

Select SEX = Female in the filtering condition, then compute mean for heart rate.

Mean =AVERAGE(C2:C17) = 65.5625

Que.4

To compute standard deviation of heart rate for males in this study, Select SEX = Male

Standard deviation =STDEV(C18:C33) = 12.62125

Que.5

To compute Standard error of heart rate for adolescents in this study, Select Age group = 'Adolescent'

SE = =STDEV(C2:C25)/SQRT(16) = 3.0719

Que.6

Mean body mass for all participants in this study = =AVERAGE(D2:D33) = 56.50438