Assignment

Excel Exercise Week 1

Locate the Descriptives tab in the Excel Assignment Spreadsheet and answer the following questions. Note that the tabs on located at the bottem of the Excel sheet—clicking on each tab will take you to different sheets within the same file. Also, for all your Excel Exercises, there is no need to compute any answers. The goal is to find the answers within the Excel Assignment Spreadsheet. It’s like a scavenger hunt, you go to the right tab, you find the right column and row, you read off the answer.

What is the mean for Systolic BP_2_Grp2? ____ 1 pt

What is the median for Diastolic_1_Grp_1? ____ 1 pt

What is the Standard Deviation for Wt_Grp_3? ____ 1 pt

What is the Minimum value for Ht_Grp_2? ___ 1 pt

Based on the coefficient of variation (scroll far off to the right of the sheet) – which variable is the least heterogeneous (smallest coefficient of variation value)? __ ___ 1 pt

Which Systolic Blood Pressure has the highest mean value? __ ___ 1 pt

Which age group has the smallest Confidence Interval? ___ ___ 1 pt

Based on the coefficient of variation—which of the 18 blood pressure measures has the greatest variation? __ ___ 1 pt

Which weight group had the heaviest patient? _ __ 1 pt

58 inches was the shortest patient in which height group?_ __ 1 pt