Question

Data were collected on the prices of parts at each shelf in auto parts showroom in Melbourne. The prices of parts at each shelf, are given below. 50 60 550 100 160 60 30 230 120 140 100 20 53 130 190 120 300 10 100 120 140 140430 230 240 250 120 170 200 250 400 139 180 200 260 320 630 200 140 530 450 170150190 300 250 140 270 280 290 120 400 130 140 300 130 420 200 150 310 Tasks: a. Construct a frequency distribution using 10 classes, stating the Frequency, Relative Frequency, Cumulative Relative Frequency and Class Midpoint b. Using (a), construct a histogram. You can draw it neatly by hand or use Excel) C. Based upon the raw data NOT the Frequency Distribution), what is the mean, median and mode? (Hint - first sort your data. This is usually much easier using Excel.)

please type it do not handwritten

Answer 1

11:21 AM 4 COD relative frequency class intervel= (max - min)/10 (630-10)/10 62 class (10-72) 73 135 136 197 10 198 261 11 262 324 frequency class boundaries frequency relative 7 9.5-72.5 0.12 11 72.5-135.5 11 0.18 15 135.5-197.5 11 197.5-261.5 11 0.1 8 261.5-324.5 0 324.5-387.5 5 387.5-450.5 0.08 0 450.5-513.5 2 513.5-576.5 0.03 1 576.5-639.5 0.15 12 325 387 13 388 450 14 451 513 15 576 514 577 16 639 0.02 17 18 total 60 60

relative frequency f/N (max - min)/10 (630-10)/10 62 41 11 es frequency relative frequency cumulative frequency class midpoint 7 0.116666667 0.116666667 0.183333333 0.3 104 15 0.25 0.55 166.5 11 0.183333333 0.733333333 229.5 0.866666667 0.866666667 356 0.083333333 0.95 419 O 0.95 482 0.033333333 0.983333333 545 1 0.016666667 1 608 293 0 PNO 60 50 33

11:22 AM "" 4G (76) relative frequency - Saved | LIV 54 31 180 55 32 6 33 190 190 200 57 34 58 35 200 59 36 160 37 200 200 230 230 161 38 62 39 63 40 240 64 41 250 65 42 66 43 67 44 68 45 | 69 46 250 260 270 280 290 300 300 70 47 71 48 72 49 73 50 300 74 51 310 5 52 320 76 53 77 54 78 55 79 56 400 400 420 430 450 530 550 80 57 81 58 82 59 83 60 1630 84 85 total | 12602 86 D | Y 贈9

Histogram LA S I 1.1 1.0 Facequency V V d 10 41 104 482 545 608 166.5 229.5 Mid point 295 356 419 (class Limits ) TA REDMI NOTE 6 PRO MI DUAL CAMERA

mean mode median sum (xi) 12602 60 20 30 mean sum (xi) /n 210.0333333 50 53 60 60 oo 100 100 100 10 11 120 12 120 13 120 14 120 15 120 130 mean median mode 210.0333333 175 140 16 17 130 18 130 19 139 20 21 140 22 140 23 140 24 140 25 140 150 26 27 150 28 160 29 170 30 170 180 31 32 190 33 190 34 200 200 25