Consider the data set in the Problem 1 worksheet of the Test 1 Data file. a. Fin
ID: 3302197 • Letter: C
Question
Consider the data set in the Problem 1 worksheet of the Test 1 Data file.
a. Find the mean, median and mode.
b. Find the range, variance, and standard deviation.
c. Find the lower quartile, upper quartile, and inter-quartile range
29 -384 110 14 -329 125 66 212 -148 76 198 174 128 217 62 292 -83 -60 97 -304 -84 -1336 125 201 41 -25 -73 110 199 -229 0 85 -175 21 -867 268 261 -95 201 178 -170 7 -192 -540 127 -279 -224 229 522 -68 -213 30 136 -103 -234 -152 1479 -87 94 -101 -9 -232 -341 -49 220 103 -34 -360 -72 -244 -147 -317 -378 -194 220 -348 282 -259 -373 -180 -353 -162 -219 136 297 219 162 117 9 -286 267 260 228 232 -199 236 -243 -29 -394 281Explanation / Answer
The sorted data is
-1336,-867,-540,-394,-384,-378,-373,-360,-353,-348,-341,-329,-317,-304,-286,-279,-259,-244,-243,-234,-232,-229,-224,-219,-213,-199,-194,-192,-180,-175,-170,-162,-152,-148,-147,-103,-101,-95,-87,-84,-83,-73,-72,-68,-60,-49,-34,-29,-25,-9,0,7,9,14,21,29,30,41,62,66,76,85,94,97,103,110,110,117,125,125,127,128,136,136,162,174,178,198,199,201,201,212,217,219,220,220,228,229,232,236,260,261,267,268,281,282,292,297,522,1479
a) mean = -25.94, median = -4.5, mode = 125, 220, 136, 201, 110, each appeared 2 times
b) range = 2815, variance =92165.693333333, standard deviation =303.58803226302
c) Lower quartile = -209.5, Upper quartile = 171, inter quartile range = 380.5