HLTH 501
E
XCEL
E
XERCISE
W
EEK
1
Locate the Descriptives tab in the Excel Assignment Spreadsheet and answer the following
questions.
What is the mean for Systolic BP_2_Grp2? Answer:166.62
What is the median for Diastolic_1_Grp_1? Answer: 101
What is the Standard Deviation for Wt_Grp_3? Answer: 23.22
What is the Minimum value for Ht_Grp_2? Answer: 62
Based on the coefficient of variation – which variable is the least heterogeneous? Answer: Weight Group 3
Which Systolic Blood Pressure has the highest mean value? Answer: Systolic BP 2 Group 2
Which age group has the smallest Confidence Interval? Answer: Age Group 3
Based on the coefficient of variation—which of the 18 blood pressure measures has the least
variation? Answer: Diastolic 2 Group 3 Which weight group had the heaviest patient? Answer: Weight Group 3
Which group had the tallest patient? Answer: Height Group 1
