# HT WT CHOL 1 16 57 94.3 2 Percentiles (Source: Dr. Diane Kiernan, APM 510...

Transcribed Image Text:

# HT WT CHOL 1 16 57 94.3 2 Percentiles (Source: Dr. Diane Kiernan, APM 510 Reader Final Edition Fall Place functions to answer the questions in the yellow cells. AGE a. Find the percentile for Cholesterol (CHOL) for 123. 2 19 63.1 100.7 8 3 19 64.8 105.4 44 4 29 63.6 106.7 62 b. Find the Cholesterol value for the 58th percentile. 5 23 64.7 107.8 62 6 12 63.3 108.8 89 c. Find Q1, Q2 and Q3 for the Weight Column (WT). 7 40 58.6 110.2 94 8 27 59.6 111.7 98 9 27 65.1 112.9 98 10 23 66.7 114.8 112 11 31 63.4 119 123 12 41 64.3 123.1 125 13 25 59.8 124.2 126 14 32 61.4 124.3 130 15 36 63.2 127.1 146 16 34 60.5 130 149 17 37 65 130.4 149 18 37 60.6 135 173 19 31 66.7 135.5 175 20 32 66.4 136.1 181 Q1 Q2 Q3 d. Are there any outliers for the Weight data? Calculate the lower and upper limits of the outliers. Calc for outlier lower limit upper limit e. Calculate the mean, median and standard deviation for Weight and Cholesterol. mean median st dev weight cholesterol f. Calculate the z-scores for Sample number 32 with a weight of 179.9 and cholesterol reading of 318. weight cholesterol 21 48 67 141.4 207 z-score 22 23 61.3 147.8 223 23 24 62.6 149.3 237 24 52 67.6 149.9 254 25 17 64.3 156.3 264 26 25 62.3 159.7 267 27 29 68 160.1 271 28 45 60.2 161.9 280 29 47 58.2 162.8 293 30 23 62.7 163.1 301 31 59 63.5 174.1 309 32 56 63.4 179.9 318 33 22 60.7 181.2 325 34 55 62.3 182.4 384 35 45 61.9 188.3 447 36 40 66.8 195.6 462 37 41 67.9 218.8 531 38 32 64.1 238.4 596 39 57 63.4 255.9 600 # HT WT CHOL 1 16 57 94.3 2 Percentiles (Source: Dr. Diane Kiernan, APM 510 Reader Final Edition Fall Place functions to answer the questions in the yellow cells. AGE a. Find the percentile for Cholesterol (CHOL) for 123. 2 19 63.1 100.7 8 3 19 64.8 105.4 44 4 29 63.6 106.7 62 b. Find the Cholesterol value for the 58th percentile. 5 23 64.7 107.8 62 6 12 63.3 108.8 89 c. Find Q1, Q2 and Q3 for the Weight Column (WT). 7 40 58.6 110.2 94 8 27 59.6 111.7 98 9 27 65.1 112.9 98 10 23 66.7 114.8 112 11 31 63.4 119 123 12 41 64.3 123.1 125 13 25 59.8 124.2 126 14 32 61.4 124.3 130 15 36 63.2 127.1 146 16 34 60.5 130 149 17 37 65 130.4 149 18 37 60.6 135 173 19 31 66.7 135.5 175 20 32 66.4 136.1 181 Q1 Q2 Q3 d. Are there any outliers for the Weight data? Calculate the lower and upper limits of the outliers. Calc for outlier lower limit upper limit e. Calculate the mean, median and standard deviation for Weight and Cholesterol. mean median st dev weight cholesterol f. Calculate the z-scores for Sample number 32 with a weight of 179.9 and cholesterol reading of 318. weight cholesterol 21 48 67 141.4 207 z-score 22 23 61.3 147.8 223 23 24 62.6 149.3 237 24 52 67.6 149.9 254 25 17 64.3 156.3 264 26 25 62.3 159.7 267 27 29 68 160.1 271 28 45 60.2 161.9 280 29 47 58.2 162.8 293 30 23 62.7 163.1 301 31 59 63.5 174.1 309 32 56 63.4 179.9 318 33 22 60.7 181.2 325 34 55 62.3 182.4 384 35 45 61.9 188.3 447 36 40 66.8 195.6 462 37 41 67.9 218.8 531 38 32 64.1 238.4 596 39 57 63.4 255.9 600