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 275 completed sales showing origin, type, mileage (in km), and price ($) were extracted for analysis. Click this button to reveal/conceal the data Vehicle Origin Type Mileage Price($) 1 Japanese minivan 27290 19570 2 Japanese sedan 38983 34525 3 American sedan 35847 15177 4 American sedan 28835 17150 5 American minivan 36987 19193 6 German SUV 21258 22453 7 Japanese sedan 50286 35892 8 German sedan 24425 34469 9 Japanese coupe 48273 59031 10 German minivan 48552 31526 11 Japanese minivan 15902 16752 12 German coupe 59388 51925 13 German sedan 3282 47959 14 German sedan 28763 25630 15 Japanese minivan 49468 22461 16 German convertible 25260 43294 17 German sedan 8870 50712 18 Other coupe 12332 39885\f94 American sedan 17939 41983 95 American SUV 5544 56627 96 German SUV 29571 30909 97 German minivan 11469 32839 98 German coupe 13988 49478 99 Other sedan 28904 15863 100 American convertible 30291 61174 101 Japanese minivan 10876 33467 102 American sedan 30677 28252 103 Japanese SUV 5814 38136 104 Japanese sedan 15705 41502 105 Japanese SUV 37784 52350 106 Japanese convertible 48463 59808 107 Japanese SUV 8642 24788 108 American coupe 57277 48170 109 American SUV 4221 56760 110 Other SUV 7957 58150 111 Japanese minivan 6773 16377 112 German minivan 47918 30843 113 Other SUV 39106 39989 114 German minivan 25991 16578 115 Japanese coupe 56383 53608 116 German SUV 34598 58755 117 Japanese sedan 9034 48267 118 Japanese coupe 56043 47009\f144 German SUV 23721 54998 145 Japanese SUV 56594 34032 146 Other sedan 41738 33422 147 American convertible 32947 67903 148 German minivan 15281 31983 149 Other SUV 4471 55650 150 Other sedan 30920 39951 151 Japanese SUV 55949 26600 152 American sedan 26522 26978 153 German sedan 30089 50718 154 Japanese sedan 36694 54243 155 German sedan 16541 22362 156 Other minivan 24575 21785 157 Other sedan 3138 37638 158 American minivan 11319 26968 159 American coupe 34244 49279 160 American sedan 21874 25966 161 American sedan 10542 52295 162 Japanese minivan 43099 27396 163 Japanese SUV 12697 50193 164 American SUV 27195 19271 165 American SUV 27651 19465 166 Other minivan 9841 33298 167 Japanese minivan 40605 32991 168 American SUV 34102 58276169 American sedan 18669 24462 170 German SUV 46158 52591 171 American SUV 5449 21672 172 German coupe 33678 47747 173 Japanese convertible 42549 66900 174 Other minivan 43185 17267 175 German minivan 55471 17486 176 Japanese sedan 45024 37770 177 Japanese sedan 42964 22480 178 American sedan 37028 37757 179 American minivan 26822 29349 180 Japanese minivan 51846 16601 181 Japanese SUV 46267 26997 182 German SUV 59814 20174 183 German coupe 52595 59973 184 Japanese coupe 26765 45232 185 Japanese SUV 7445 51779 186 American minivan 29289 22099 187 American minivan 12575 20908 188 Japanese minivan 50645 24619 189 Other SUV 43591 20671 190 American sedan 1357 14965 191 Japanese SUV 56199 33136 192 Japanese coupe 24899 39412 193 American sedan 48981 36703244 American convertible 29995 41346 245 American sedan 18763 43889 246 German sedan 37692 45051 247 American sedan 33843 21889 248 American minivan 54948 27786 249 Other minivan 23572 26982 250 Japanese sedan 28468 31349 251 American convertible 24058 51055 252 Japanese SUV 32447 33121 253 German coupe 12590 47340 254 German minivan 41854 22306 255 American minivan 31592 20862 256 Japanese minivan 56188 27963 257 American minivan 1000 30797 258 Japanese convertible 29931 57997 259 Other minivan 44646 25534 260 German coupe 40245 33601 261 German convertible 39745 48725 262 Japanese sedan 42520 16743 263 Other minivan 20197 16945 264 American coupe 12801 42260 265 Japanese minivan 10854 31114 266 German sedan 52656 16850 267 Other coupe 41511 37648 268 German SUV 17090 49336269 American SUV 39391 25516 270 Other convertible 18347 44849 271 German SUV 2749 26940 272 American coupe 44091 33629 273 German sedan 4658 30580 274 American sedan 1898 43503 275 Other minivan 59793 20255 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 % 0 to 9,999 42 15.2727272 10,000 to 19,999 51 18.5454545: 20,000 to 29,999 58 21.0909090!% 30,000 to 39,999 44 16 40,000 to 49,999 43 15.6363636A retail store has recently started paying attention to customer analytics. The store collected data from a sample of 133 walk-in customers about registration in the store's points program, purchase level, and payment method. Click this button to reveal the data Customer Registration Purchase Level Payment Method 1 Unregistered Medium Mobile 2 Unregistered Medium Debit 3 Unregistered Medium Mobile 4 Unregistered Large Cash 5 Unregistered Large Cash 6 Registered Small Mobile 7 Unregistered Small Mobile 8 Registered Large Debit 9 Unregistered Large Cash 10 Registered Small Other 17 Registered Medium Debit 12 Registered Small Mobile 13 Unregistered Large Cash 14 Unregistered Small Mobile 15 Registered Medium Mobile 16 Unregistered Large Credit 17 Unregistered Medium Mobile 18 Unregistered Medium Mobile19 Unregistered Medium Debit 20 Registered Small Mobile 21 Unregistered Medium Debit 22 Unregistered Large Cash 23 Unregistered Small Mobile 24 Registered Large Cash 25 Unregistered Mediu Screen Shot 2022-06-11 at 4.16.34 AM 26 Registered Large Cash 27 Unregistered Small Other 28 Registered Small Mobile 29 Registered Medium Debit 30 Registered Large Credit 31 Unregistered Medium Debit 32 Unregistered Large Cash 33 Unregistered Large Credit 34 Unregistered Medium Mobile 35 Unregistered Large Cash 36 Unregistered Small Other 37 Registered Small Mobile 38 Unregistered Small Mobile 39 Unregistered Small Other 40 Registered Small Other 41 Unregistered Small Other 42 Registered Small Other 43 Registered Medium Debit44 Unregistered Small Other 45 Registered Small Other 46 Unregistered Large Cash 47 Unregistered Large Credit 48 Unregistered Large Credit 49 Registered Small Mobile 50 Unregistered Small Mobile 51 Unregistered Small Mobile 52 Registered Medium Debit 53 Unregistered Medium Credit 54 Unregistered Medium Credit 65 Registered Medium Mobile 56 Registered Large Credit 57 Unregistered Medium Debit 58 Unregistered Medium Debit 59 Unregistered Small Mobile 60 Unregistered Small Other 61 Unregistered Small Other 62 Registered Small Mobile 63 Registered Medium Debit 64 Unregistered Medium Debit 65 Registered Medium Debit 66 Unregistered Small Mobile 67 Unregistered Large Credit 68 Unregistered Medium Mobile69 Unregistered Large Credit 70 Unregistered Medium Mobile 71 Registered Small Mobile 72 Unregistered Large Cash 73 Unregistered Small Other 74 Unregistered Small Other 75 Registered Medium Debit 76 Unregistered Small Mobile 77 Unregistered Medium Debit 78 Unregistered Small Mobile 79 Unregistered Large Cash 80 Registered Large Cash 81 Registered Large Debit 82 Unregistered Small Other 83 Unregistered Medium Mobile 84 Unregistered Small Mobile 85 Unregistered Medium Mobile 86 Unregistered Medium Debit 87 Registered Large Cash 88 Registered Large Cash 89 Registered Small Other 90 Unregistered Small Mobile 91 Unregistered Medium Debit 92 Registered Small Mobile 93 Registered Medium Debit94 Registered Medium Mobile 95 Registered Large Debit 96 Unregistered Medium Debit 97 Unregistered Medium Mobile 98 Unregistered Large Cash 99 Registered Large Credit 100 Unregistered Large Credit 101 Unregistered Small Mobile 102 Unregistered Medium Debit 103 Unregistered Small Other 104 Unregistered Large Credit 105 Unregistered Large Cash 106 Unregistered Medium Debit 107 Unregistered Large Credit 108 Unregistered Small Mobile 109 Unregistered Large Cash 110 Unregistered Large Credit 111 Registered Large Credit 112 Unregistered Medium Debit 113 Unregistered Large Credit 114 Unregistered Small Other 115 Registered Large Cash 116 Unregistered Small Other 117 Unregistered Large Cash 118 Unreaistered Small Mobile119 Registered Small Other 120 Registered Large Cash 121 Registered Small Other 122 Unregistered Large Credit 123 Unregistered Medium Debit 124 Unregistered Medium Mobile 125 Unregistered Medium Debit 126 Registered Large Credit 127 Registered Large Cash 128 Registered Medium Debit 129 Registered Large Cash 130 Unregistered Medium Debit 131 Registered Large Cash 132 Unregistered Medium Mobile 133 Unregistered Medium Debit Download CSV file Download the .csv file or copy/paste the data into Excel or Google Sheets and use the Pivot Table function to generate the tables needed to answer the following questions: 1. How many purchases in the sample are large? 44 2. How many customers paid with mobile? 391. How many purchases in the sample are large? 44 2. How many customers paid with mobile? | 39 3. How many unregistered customers' purchases are large? | 26 4. How many registered customers paid with debit? 13 X Round percentages to two decimal places. 5. What percent of all customers are registered and paid with debit? 9.77 6. What percent of all customers are unregistered and made a large purchase? 19.55 % 7. What percent of unregistered customers' purchases are large? |29.89 8. What percent of registered customers paid with debit? 28.26 x 7%4o ooo to 49 999 -3 .5. 53535359 -: 2. a] How manv of vehicles sold are of American origin? I b} What proportion of vehicles sold are convertibles? I % . c} What proportion of the German vehicles sold are sedans? 9% . 3. a] What is the median mileage of all vehicles sold? -.km b} What is the mean mileage of Japanese 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 minivans sold? $ 5541.95 9