I am sorry as how this long list can look unclear and there is a picture of questions to it along with some part of the chart this list was supposed to be so if you scroll down and see the picture I would really appreciate you being able to help understand and take your time to please give me the right answers. A used car dealership sells sedans, SUVs, convertibles, minivans and coupes. Vehicles sold are mainly of American, German, and Japanese origin. Data on the last 274 completed sales showing origin, type, mileage (in km), and price ($) were extracted for analysis.Click this button to reveal/conceal the dataVehicleOriginTypeMileagePrice($)1Germanminivan7194198582Othersedan56956519453Americanminivan28488164474Germancoupe52751592325Japanesesedan55412448006Americancoupe26814481147Otherminivan58891256528Americanminivan38533278569OtherSUV514574724410AmericanSUV409374130711Germansedan296802541212Americansedan433761928013Japanesesedan356543310514Japanesecoupe215274046315Americancoupe114755825816Americansedan418421524317Germanconvertible109694456218JapaneseSUV546102021219Americansedan73192737820Americancoupe574604281521JapaneseSUV341505436522Americanminivan67273091823Japanesesedan388315491424Germansedan32663335725Americanminivan64712325326OtherSUV514503662327Americanminivan333443032528OtherSUV312004016129Germancoupe397134247430Japanesesedan244983091231Germanconvertible594126910332Japanesesedan403892857033Americanminivan454341979134Otherconvertible62275410335Japaneseconvertible462146696436Japanesesedan344485447337Japanesecoupe528725755038Othersedan263702017139AmericanSUV284572818840Americanconvertible315377841741Americansedan125382599342Germansedan500211873643Othercoupe420003503244Americansedan348682766345Americanminivan155322876846Germancoupe227475022647JapaneseSUV546302617948Japaneseminivan55963161549OtherSUV401173291250JapaneseSUV499833970551Germansedan581724018752Japaneseconvertible424687125953Americansedan340562835854Germanminivan521752243755Othersedan327301428456Japanesecoupe292954388857Japanesesedan239462349258Othersedan202011400759Americanminivan154191694360GermanSUV433403701761Americansedan206922392562Germanconvertible340306940163Germancoupe390524164464Germanminivan496983357065Japanesesedan132471792466JapaneseSUV169454627967Germanminivan531201775068Othercoupe298505088869Othercoupe564154084470AmericanSUV246084255271GermanSUV133503851172Japaneseconvertible138246726573Germancoupe87033972574JapaneseSUV477313993375Americancoupe136895837676OtherSUV54043250977Japaneseconvertible167975036478GermanSUV416115512579Germanconvertible454214636780Americancoupe353593378381Japanesecoupe166124305282Germansedan438185470483Otherminivan545752276484Americansedan239694601785Japanesecoupe309543160186Japaneseconvertible56247645287JapaneseSUV89653095188GermanSUV183404080389JapaneseSUV111334586790Americansedan582191473291Othersedan53564894292Japaneseminivan299433459993JapaneseSUV174844074494GermanSUV519623417095Americanminivan473703291396Germansedan18832564597JapaneseSUV357264233798Germansedan76933554299Japanesesedan4005317753100Otherconvertible1305763143101Americanminivan4665620655102AmericanSUV4408657648103Japanesesedan3578750056104Japanesecoupe2373558605105Americanminivan5098430694106Germanminivan1518321622107Germansedan5746715704108Americancoupe1986454973109JapaneseSUV4720755638110Americansedan1290632170111JapaneseSUV5493240316112Americansedan4672946360113Germanminivan4167532414114Japanesesedan4241630148115AmericanSUV3486539490116Japaneseminivan3516018826117JapaneseSUV5765134690118Americanconvertible1625866391119Americansedan3967754611120Japanesesedan3828515249121Americansedan1081249553122AmericanSUV3408756639123Americansedan4553522250124Japaneseminivan2215420549125Japaneseminivan1682629218126Otherconvertible2085171240127AmericanSUV342035921128Japaneseminivan1337027115129Americanminivan5035828514130Americansedan3366151729131Americansedan3747646170132Othersedan5281748468133Americancoupe1771958010134Americanminivan2923319686135Germansedan3092940698136Americansedan2932932445137Othersedan1335545015138Germanminivan1141625816139Americansedan2216116551140Americansedan3809534848141Americanminivan1154831820142Japanesecoupe5908655219143OtherSUV3555525173144AmericanSUV5824447458145Japanesesedan5489416285146Germansedan1011736020147Othersedan1049554637148Japaneseminivan103423331149Americancoupe3176145115150Germancoupe4579345751151Japaneseminivan2409020827152Othersedan899952000153Germansedan5045752925154Japanesesedan1009147559155Americansedan3252333606156Othersedan4470420499157AmericanSUV1462052103158AmericanSUV5619656729159Americancoupe4667539374160Japanesesedan3301744004161AmericanSUV2973446300162Otherminivan3286332534163Germansedan3714043504164Japanesecoupe1519953062165AmericanSUV315654171166Americanconvertible573863633167Japaneseconvertible1421446354168Japanesesedan4248844880169Germanminivan3204518246170Japaneseminivan1412326636171OtherSUV1652848375172Americancoupe4460041338173Japanesesedan2745120320174Germanconvertible3313665301175Americansedan3852127792176GermanSUV4744751054177GermanSUV5487623815178Germancoupe113559925179Germanminivan4549322906180JapaneseSUV5513436122181Otherminivan781031095182Othersedan2771047855183Germanminivan4675216314184AmericanSUV817145568185Germancoupe4237959821186OtherSUV3805538704187AmericanSUV2482221420188AmericanSUV5094027271189Germansedan3509341496190Germancoupe3714645786191Japanesecoupe4476531961192Germancoupe2578459505193Americancoupe1858535927194Othersedan1828851894195OtherSUV4068236257196Americansedan5100229448197Japaneseminivan2363221372198Japaneseminivan1103124422199Otherminivan2253715167200Japanesesedan3815833009201Japanesesedan3425721450202Americansedan375331366203Othercoupe4256851743204Americanminivan5275432911205Japanesesedan4735941333206GermanSUV402829327207Germanminivan1256715840208GermanSUV4113346650209JapaneseSUV1005446876210Othersedan826648125211Americanconvertible2828449093212JapaneseSUV1408924271213JapaneseSUV2696052899214Germansedan1544129998215Japanesesedan2700435712216AmericanSUV4195348824217Americansedan1993451321218Americanminivan648234703219Japanesesedan4531519394220Japaneseminivan4129719594221Otherconvertible2974966348222Germanminivan3844417653223Americanminivan5949826597224Americanconvertible2597975218225Germancoupe2693155914226Othersedan1709041147227Americanminivan1117424821228GermanSUV2774154182229JapaneseSUV3346429536230GermanSUV1112928227231AmericanSUV1187952379232Japanesecoupe1403757394233Otherconvertible5907475046234OtherSUV4791941222235Americansedan4459844576236Americansedan3923252466237AmericanSUV3397447672238JapaneseSUV317458340239AmericanSUV5208434480240Othercoupe3033741220241Japaneseminivan3259231481242Japaneseconvertible5259441669243JapaneseSUV5358828870244Otherminivan4997918087245Othercoupe3241655359246Americansedan2138615222247Americancoupe2157446283248Americancoupe2989635154249AmericanSUV5912329402250Otherminivan4122133986251GermanSUV2802735299252Americanminivan3218916016253Japaneseminivan5783733926254OtherSUV5550631575255Japaneseconvertible2042561593256Otherminivan3492216769257Otherminivan2476520403258JapaneseSUV3140721711259Americanminivan5000331707260AmericanSUV3477839003261JapaneseSUV5238345559262Americanminivan5639818849263JapaneseSUV691739610264Americanconvertible195879448265Japanesesedan1201640369266Americanconvertible2134041148267Japanesesedan4009135815268Japaneseconvertible2445348750269Japanesesedan5255139774270Japaneseminivan3506317969271Americanconvertible3902471949272AmericanSUV1344928232273GermanSUV5276545553274Othersedan3975149321

259 American minivan 50003 31707 260 American SUV 34778 890OB 261 Japanese SUV 52383 19559 262 American minivan 56398 18849 263 Japanese SUV 6917 39610 264 American convertible 1958 79448 265 Japanese 12016 40369 266 American convertible 21340 41148 267 Japanese sedan 4009 1 35815 268 Japanese convertible 24453 18750 269 Japanese sedar 52551 39774 270 Japanese minivan 35063 17969 271 American convertible 39024 71949 272 American SUV 28232 273 German SUV 52765 45958 274 Other sedan 39751 49321 Download CSV file For the following questions, copy and paste software output results or report answers accurate to at least two decimal places. 1. Complete the following frequency distribution table for mileage. Report relative frequency as percent without the ":" symbol. Mileage Frequency Relative Frequency % D to 9,999 10.000 to 19,999 20,000 to 29,999 30.000 to 39.999 40.000 to 49,999 50.000 to 59,999 2. a) How many of vehicles sold are of Japanese origin? "b) What proportion of vehicles sold are sedans? c) What proportion of the American vehicles sold are SUVs? 3. a) What is the median mileage of all vehicles sold? km b) What is the mean mileage of German vehicles sold? c) What is the mean price of all sedans sold s d) What is the sample standard deviation for the price of a coupes sold? $ Question Help: 2 V dep | 308 2 0 03 0 co-message instructorRelative Mileage Frequency Frequency % 0 to 32 X 11.68 X 9,999 10,000 to 48 X 17.52 X 19,999 20,000 to 44 X 16.06 X 29,999 30,000 55 20.07 to 39,999