Vehicle Origin Type Mileage Price($) 1 convertible 13466 45344 2 American convertible 54850 42476 asaunder sedan 63500 41407 German SUV 57518 55390 German coupe 69323 43380 6 agaunder sedan 34329 41650 German minivan 63925 34271 German minivan 66834 30055 German sedan 37696 15565 10 German sedan 26553 37536 11 American minivan 54092 25512 12 Other SUV 5301 57956 13 German minivan 24360 30884 14 Other SUV 30815 28682 15 German coupe 42972 44761 American minivan 34148 25134 17 German sedan 47073 22540 18 asaunder minivan 58746 24316 19 Other convertible 54277 58921 20 Other coupe 66341 57542 21 Other sedan 41841 39424 22 EGBUBde minivan 37740 34909 23 asaunder coupe 57881 38814 24 German SUV 19137 48463 25 asaunder SUV 22500 42513 26 Other SUV 47384 21344 27 American sedan 50784 18903 28 aGauedEr sedan 42011 51063 29 German COUDE 37078 34918 30 Other sedan 53872 24588 31 Other SUV 54392 57044 32 American SUV 45798 30541 American SUV 37985 57321 34 Other minivan 13535 33940 35 German coupe 13442 59842 36 American sedan 8291 47283 37 SUV 5465 45164 3.8 German minivan 52728 16964 39 Other coupe 47911 39382 40 American convertible 24444 47248 41 Other SUV 55673 55583 42 American SUV 20328 40812 43 American SUV 68856 40399 44 Japanese sedan 12115 3777745 coupe 55841 58005 46 Japanese sedan 34259 20633 47 EGBUedEr coupe 51411 30306 48 German SUV 59949 23128 49 Japanese coupe 39270 56784 50 American minivan 13011 31151 51 American SUV 9467 36992 52 Other sedan 6410 17051 53 American sedan 37729 48923 54 American sedan 22300 22753 55 American sedan 51693 44962 56 American minivan 58088 32125 57 German sedan 18505 25773 58 American SUV 30211 54812 59 BGBWBde SUV 39337 24584 60 American SUV 12202 21088 61 American sedan 16833 17473 62 American coupe 22388 32372 63 asaunder COUDE 20927 31439 64 German SUV 54192 57526 65 Japanese SUV 10278 44394 66 German SUV 32841 39250 67 Other minivan 37162 18170 68 aGaveder minivan 55280 23270 69 Other SUV 34942 54470 70 German sedan 28697 52567 71 American sedan 50844 31664 72 minivan 14758 22116 73 American sedan 24810 34495 74 German SUV 42143 50369 75 Japanese minivan 32918 31788 76 American sedan 12361 18345 77 minivan 63032 33271 78 German sedan 66434 21901 79 German SUV 38283 23993 Other sedan 36667 54912 81 agaunder sedan 66734 39899 82 Japanese convertible 60787 60605 83 American sedan 32114 52662 84 American SUV 7247 22248 85 aGBweder minivan 59880 26765 86 German convertible 21885 65623 87 Other SUV 55373 21247 American SUV 65642 37303A used car dealership sells sedans, SUVs, convertibles, minivans and coupes. Vehicles sold are mainly of American, German, and Japanese origin. Partial data on the last 176 completed sales showing origin, type, mileage (in km), and price ($) were extracted for analysis. Click this button to reveal/conceal the data Download CSV file For the following questions, copy and paste software output results or report answers accurate to two (2) decimal places. 1. Complete the following frequency distribution table for the price of sedans sold only. Report relative frequency as percent without the "%" symbol. Price ($) Frequency Relative Frequency % $10,000 to $19,999 20 $20,000 to $29,999 $30,000 to $39,999 $40,000 to $49,999 $50,000 to $59,999 2. a) What proportion of the vehicles sold are of American origin? 31.25 % . b) What proportion of the Japanese vehicles sold are coupes? % . 3. a) What is the median mileage of all vehicles sold? km b) What is the mean mileage of German vehicles sold? km c) What is the mean price of all convertibles sold? $ d) What is the sample standard deviation for the price of all sedans sold? $89 American SUV 43449 37650 90 American sedan 45847 15622 91 American convertible 61150 75758 92 American sedan 59002 47403 93 American coupe 29772 34548 Other sedan 34482 44056 95 Japanese SUV 17920 57253 96 Other sedan 54044 49241 97 Other coupe 18780 41141 EGBUBder SUV 60649 29122 99 American sedan 5349 42752 100 American convertible 40347 72483 101 American minivan 24787 28991 102 Other convertible 48439 56484 103 German minivan 34815 21071 104 American sedan 68035 15015 105 Other SUV 19655 35984 106 Japanese sedan 55860 47908 107 German coupe 57902 37126 108 asaunder coupe 48407 30427 109 Other sedan 54746 14683 110 Other minivan 9609 27390 111 German minivan 36175 19340 112 German SUV 50444 43094 113 American minivan 65195 18068 114 German sedan 31691 42226 115 German convertible 29872 42275 116 American coupe 42254 38419 117 American coupe 22411 43491 118 American sedan 58115 32634 119 American sedan 51891 16657 120 Japanese SUV 32900 56056 121 Other sedan 37089 23183 122 American SUV 7248 30457 123 American minivan 58224 24280 124 BGBunder convertible 36603 58572 125 American minivan 51790 18025 126 agaunder SUV 65502 46157 127 asBUBde sedan 43257 50026 128 American sedan 12701 14434 129 Other minivan 65564 30847 130 Other sedan 46273 29397 131 German convertible 56323 50023 132 Japanese sedan 24724 22681133 adno 25883 58687 134 German minivan 37474 25407 135 American SUV 2180 21295 136 agaunder minivan 56358 17665 137 Other sedan 11605 21342 138 American sedan 49742 48765 139 German minivan 23175 16879 140 German convertible 6147 55719 141 German minivan 28778 15272 142 American sedan 50457 48409 143 agawede convertible 47321 51925 144 American coupe 57366 40349 145 Japanese sedan 21704 50723 146 asaunder SUV 30287 50981 147 German sedan 64013 41212 148 Other sedan 62044 34266 149 American convertible 31380 65161 150 German convertible 45636 67828 151 German SUV 12479 42112 152 asaunder convertible 17316 67821 153 acqueder sedan 61932 45081 154 German sedan 63465 29943 155 Japanese SUV 23820 25696 156 German coupe 61214 35131 157 German convertible 55850 72696 158 Other SUV 66772 55951 159 Other sedan 67246 23641 160 aGauBder coupe 48891 30654 161 German sedan 57902 19712 162 Other minivan 66390 32738 163 Other minivan 54280 33276 164 American SUV 52685 28224 165 Other minivan 8079 19175 166 asaunder sedan 37826 22803 167 American minivan 16335 30820 168 German SUV 6950 29234 169 German sedan 18522 52456 170 American coupe 52725 30993 171 German coupe 34816 44191 172 asaunder SUV 52439 52727 173 American SUV 27987 23284 174 WESUBWAY minivan 12353 34509 175 Other minivan 16281 22773 176 American sedan 48978 31448