1. The following is a set of 30 scores achieved by students on an exam:

18 23 33 38 38 38 42 51 55 56 57 63 65 66 68 68 68 68 76 80 81 82 85 89 92 93 93 95 97 100

Determine the percentile rank for each of the following scores:

a) 20

b) 68

(Remember to round all percentiles up to the next whole number)

2. Use Excel to create a spreadsheet with the collected data presented in the Table 1.The data set were measured in a subsample of 10 participants who attended the fifth examination of a research institute.

Participant ID Systolic Blood Pressure Diastolic Blood Pressure Total Serum Cholesterol Weight (1b) Height (in) 141 76 199 138 63.00 119 64 150 183 69.75 122 62 227 153 65.75 127 81 227 178 70.00 125 163 161 70.50 123 210 206 70.00 105 205 235 72.00 113 275 151 60.75 106 67 208 213 69.00 131 7 159 142 61.00