I am looking to find the mean, range, standard deviation and interquartile range

Question

I am looking to find the mean, range, standard deviation and interquartile range of my data set. My stat project is to look at the correlation between high blood pressure and weight. Here is my data set:

High blood pressure:

1= yes and 3= no

weight in ponds

3, 4

1,140

3,190

3,210

3,170

3,150

3,160

1,190

3,125

1,185

3,180

1,210

1,144

1,165

3,145

3,120

1,225

3,180

3,190

3,125

1,185

3,180

1,234

3,145

1,188

1,95

3,180

3,150

3,175

3,180

3,160

3,130

1,240

3,214

3, 175

3,160

1,165

3,210

3,110

1,127

1,220

1,180

3,151

3,130

3,130

1,140

1,380

3,220

1,168

1,162

3,176

Explanation / Answer

Using Excel

Mean Weight (in pound) = 173.28 (Command "=Average(Select data range)")

Range = Max value - Min value = 380 - 95 = 285

Standard deviation = 44.6547 (Command "=STDEV.S(Select data range)")

First quartile = Q1 = 145 (Command "=QUARTILE(data range,1)")

Second quartile = Q2 = 172.5 (Command "=QUARTILE(data range,2)")

Third quartile = Q3 = 189.5 (Command "=QUARTILE(data range,3)")

Interquartile range = Q3 - Q1 = 189.5 - 145 = 44.5

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

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