create
inseam
ExcelSkills.xlsxQuestion 1
| Salesperson | Region | Sales |
| Smith | South | 1000 |
| Jones | East | 1500 |
| Davis | West | 2500 |
| Allen | North | 1525 |
| Lewis | South | 1700 |
| Miller | West | 2000 |
| Austin | North | 2200 |
Question 2
| mpg | car name |
| 18 | chevrolet chevelle malibu |
| 15 | buick skylark 320 |
| 18 | plymouth satellite |
| 16 | amc rebel sst |
| 17 | ford torino |
| 15 | ford galaxie 500 |
| 14 | chevrolet impala |
| 14 | plymouth fury iii |
| 14 | pontiac catalina |
| 15 | amc ambassador dpl |
| 15 | dodge challenger se |
| 14 | plymouth 'cuda 340 |
| 15 | chevrolet monte carlo |
| 14 | buick estate wagon (sw) |
| 24 | toyota corona mark ii |
| 22 | plymouth duster |
| 18 | amc hornet |
| 21 | ford maverick |
| 27 | datsun pl510 |
| 26 | volkswagen 1131 deluxe sedan |
| 25 | peugeot 504 |
| 24 | audi 100 ls |
| 25 | saab 99e |
| 26 | bmw 2002 |
| 21 | amc gremlin |
| 10 | ford f250 |
| 10 | chevy c20 |
| 11 | dodge d200 |
| 9 | hi 1200d |
| 27 | datsun pl510 |
| 28 | chevrolet vega 2300 |
| 25 | toyota corona |
| 19 | amc gremlin |
| 16 | plymouth satellite custom |
| 17 | chevrolet chevelle malibu |
| 19 | ford torino 500 |
| 18 | amc matador |
| 14 | chevrolet impala |
| 14 | pontiac catalina brougham |
| 14 | ford galaxie 500 |
| 14 | plymouth fury iii |
| 12 | dodge monaco (sw) |
| 13 | ford country squire (sw) |
| 13 | pontiac safari (sw) |
| 18 | amc hornet sportabout (sw) |
| 22 | chevrolet vega (sw) |
| 19 | pontiac firebird |
| 18 | ford mustang |
| 23 | mercury capri 2000 |
| 28 | opel 1900 |
| 30 | peugeot 304 |
| 30 | fiat 124b |
| 31 | toyota corolla 1200 |
| 35 | datsun 1200 |
| 27 | volkswagen model 111 |
| 26 | plymouth cricket |
| 24 | toyota corona hardtop |
| 25 | dodge colt hardtop |
| 23 | volkswagen type 3 |
| 20 | chevrolet vega |
| 21 | ford pinto runabout |
| 13 | chevrolet impala |
| 14 | pontiac catalina |
| 15 | plymouth fury iii |
| 14 | ford galaxie 500 |
| 17 | amc ambassador sst |
| 11 | mercury marquis |
| 13 | buick lesabre custom |
| 12 | oldsmobile delta 88 royale |
| 13 | chrysler newport royal |
| 19 | mazda rx2 coupe |
| 15 | amc matador (sw) |
| 13 | chevrolet chevelle concours (sw) |
| 13 | ford gran torino (sw) |
| 14 | plymouth satellite custom (sw) |
| 18 | volvo 145e (sw) |
| 22 | volkswagen 411 (sw) |
| 21 | peugeot 504 (sw) |
| 26 | renault 12 (sw) |
| 22 | ford pinto (sw) |
| 28 | datsun 510 (sw) |
| 23 | toyouta corona mark ii (sw) |
| 28 | dodge colt (sw) |
| 27 | toyota corolla 1600 (sw) |
| 13 | buick century 350 |
| 14 | amc matador |
| 13 | chevrolet malibu |
| 14 | ford gran torino |
| 15 | dodge coronet custom |
| 12 | mercury marquis brougham |
| 13 | chevrolet caprice classic |
| 13 | ford ltd |
| 14 | plymouth fury gran sedan |
| 13 | chrysler new yorker brougham |
| 12 | buick electra 225 custom |
| 13 | amc ambassador brougham |
| 18 | plymouth valiant |
| 16 | chevrolet nova custom |
| 18 | amc hornet |
| 18 | ford maverick |
| 23 | plymouth duster |
| 26 | volkswagen super beetle |
| 11 | chevrolet impala |
| 12 | ford country |
| 13 | plymouth custom suburb |
| 12 | oldsmobile vista cruiser |
| 18 | amc gremlin |
| 20 | toyota carina |
| 21 | chevrolet vega |
| 22 | datsun 610 |
| 18 | maxda rx3 |
| 19 | ford pinto |
| 21 | mercury capri v6 |
| 26 | fiat 124 sport coupe |
| 15 | chevrolet monte carlo s |
| 16 | pontiac grand prix |
| 29 | fiat 128 |
| 24 | opel manta |
| 20 | audi 100ls |
| 19 | volvo 144ea |
| 15 | dodge dart custom |
| 24 | saab 99le |
| 20 | toyota mark ii |
| 11 | oldsmobile omega |
| 20 | plymouth duster |
| 19 | amc hornet |
| 15 | chevrolet nova |
| 31 | datsun b210 |
| 26 | ford pinto |
| 32 | toyota corolla 1200 |
| 25 | chevrolet vega |
| 16 | chevrolet chevelle malibu classic |
| 16 | amc matador |
| 18 | plymouth satellite sebring |
| 16 | ford gran torino |
| 13 | buick century luxus (sw) |
| 14 | dodge coronet custom (sw) |
| 14 | ford gran torino (sw) |
| 14 | amc matador (sw) |
| 29 | audi fox |
| 26 | volkswagen dasher |
| 26 | opel manta |
| 31 | toyota corona |
| 32 | datsun 710 |
| 28 | dodge colt |
| 24 | fiat 128 |
| 26 | fiat 124 tc |
| 24 | honda civic |
| 26 | subaru |
| 31 | fiat x1.9 |
| 19 | plymouth valiant custom |
| 18 | chevrolet nova |
| 15 | mercury monarch |
| 15 | ford maverick |
| 16 | pontiac catalina |
| 15 | chevrolet bel air |
| 16 | plymouth grand fury |
| 14 | ford ltd |
| 17 | buick century |
| 16 | chevroelt chevelle malibu |
| 15 | amc matador |
| 18 | plymouth fury |
| 21 | buick skyhawk |
| 20 | chevrolet monza 2+2 |
| 13 | ford mustang ii |
| 29 | toyota corolla |
| 23 | ford pinto |
| 20 | amc gremlin |
| 23 | pontiac astro |
| 24 | toyota corona |
| 25 | volkswagen dasher |
| 24 | datsun 710 |
| 18 | ford pinto |
| 29 | volkswagen rabbit |
| 19 | amc pacer |
| 23 | audi 100ls |
| 23 | peugeot 504 |
| 22 | volvo 244dl |
| 25 | saab 99le |
| 33 | honda civic cvcc |
| 28 | fiat 131 |
| 25 | opel 1900 |
| 25 | capri ii |
| 26 | dodge colt |
| 27 | renault 12tl |
| 17.5 | chevrolet chevelle malibu classic |
| 16 | dodge coronet brougham |
| 15.5 | amc matador |
| 14.5 | ford gran torino |
| 22 | plymouth valiant |
| 22 | chevrolet nova |
| 24 | ford maverick |
| 22.5 | amc hornet |
| 29 | chevrolet chevette |
| 24.5 | chevrolet woody |
| 29 | vw rabbit |
| 33 | honda civic |
| 20 | dodge aspen se |
| 18 | ford granada ghia |
| 18.5 | pontiac ventura sj |
| 17.5 | amc pacer d/l |
| 29.5 | volkswagen rabbit |
| 32 | datsun b-210 |
| 28 | toyota corolla |
| 26.5 | ford pinto |
| 20 | volvo 245 |
| 13 | plymouth volare premier v8 |
| 19 | peugeot 504 |
| 19 | toyota mark ii |
| 16.5 | mercedes-benz 280s |
| 16.5 | cadillac seville |
| 13 | chevy c10 |
| 13 | ford f108 |
| 13 | dodge d100 |
| 31.5 | honda accord cvcc |
| 30 | buick opel isuzu deluxe |
| 36 | renault 5 gtl |
| 25.5 | plymouth arrow gs |
| 33.5 | datsun f-10 hatchback |
| 17.5 | chevrolet caprice classic |
| 17 | oldsmobile cutlass supreme |
| 15.5 | dodge monaco brougham |
| 15 | mercury cougar brougham |
| 17.5 | chevrolet concours |
| 20.5 | buick skylark |
| 19 | plymouth volare custom |
| 18.5 | ford granada |
| 16 | pontiac grand prix lj |
| 15.5 | chevrolet monte carlo landau |
| 15.5 | chrysler cordoba |
| 16 | ford thunderbird |
| 29 | volkswagen rabbit custom |
| 24.5 | pontiac sunbird coupe |
| 26 | toyota corolla liftback |
| 25.5 | ford mustang ii 2+2 |
| 30.5 | chevrolet chevette |
| 33.5 | dodge colt m/m |
| 30 | subaru dl |
| 30.5 | volkswagen dasher |
| 22 | datsun 810 |
| 21.5 | bmw 320i |
| 21.5 | mazda rx-4 |
| 43.1 | volkswagen rabbit custom diesel |
| 36.1 | ford fiesta |
| 32.8 | mazda glc deluxe |
| 39.4 | datsun b210 gx |
| 36.1 | honda civic cvcc |
| 19.9 | oldsmobile cutlass salon brougham |
| 19.4 | dodge diplomat |
| 20.2 | mercury monarch ghia |
| 19.2 | pontiac phoenix lj |
| 20.5 | chevrolet malibu |
| 20.2 | ford fairmont (auto) |
| 25.1 | ford fairmont (man) |
| 20.5 | plymouth volare |
| 19.4 | amc concord |
| 20.6 | buick century special |
| 20.8 | mercury zephyr |
| 18.6 | dodge aspen |
| 18.1 | amc concord d/l |
| 19.2 | chevrolet monte carlo landau |
| 17.7 | buick regal sport coupe (turbo) |
| 18.1 | ford futura |
| 17.5 | dodge magnum xe |
| 30 | chevrolet chevette |
| 27.5 | toyota corona |
| 27.2 | datsun 510 |
| 30.9 | dodge omni |
| 21.1 | toyota celica gt liftback |
| 23.2 | plymouth sapporo |
| 23.8 | oldsmobile starfire sx |
| 23.9 | datsun 200-sx |
| 20.3 | audi 5000 |
| 17 | volvo 264gl |
| 21.6 | saab 99gle |
| 16.2 | peugeot 604sl |
| 31.5 | volkswagen scirocco |
| 29.5 | honda accord lx |
| 21.5 | pontiac lemans v6 |
| 19.8 | mercury zephyr 6 |
| 22.3 | ford fairmont 4 |
| 20.2 | amc concord dl 6 |
| 20.6 | dodge aspen 6 |
| 17 | chevrolet caprice classic |
| 17.6 | ford ltd landau |
| 16.5 | mercury grand marquis |
| 18.2 | dodge st. regis |
| 16.9 | buick estate wagon (sw) |
| 15.5 | ford country squire (sw) |
| 19.2 | chevrolet malibu classic (sw) |
| 18.5 | chrysler lebaron town @ country (sw) |
| 31.9 | vw rabbit custom |
| 34.1 | maxda glc deluxe |
| 35.7 | dodge colt hatchback custom |
| 27.4 | amc spirit dl |
| 25.4 | mercedes benz 300d |
| 23 | cadillac eldorado |
| 27.2 | peugeot 504 |
| 23.9 | oldsmobile cutlass salon brougham |
| 34.2 | plymouth horizon |
| 34.5 | plymouth horizon tc3 |
| 31.8 | datsun 210 |
| 37.3 | fiat strada custom |
| 28.4 | buick skylark limited |
| 28.8 | chevrolet citation |
| 26.8 | oldsmobile omega brougham |
| 33.5 | pontiac phoenix |
| 41.5 | vw rabbit |
| 38.1 | toyota corolla tercel |
| 32.1 | chevrolet chevette |
| 37.2 | datsun 310 |
| 28 | chevrolet citation |
| 26.4 | ford fairmont |
| 24.3 | amc concord |
| 19.1 | dodge aspen |
| 34.3 | audi 4000 |
| 29.8 | toyota corona liftback |
| 31.3 | mazda 626 |
| 37 | datsun 510 hatchback |
| 32.2 | toyota corolla |
| 46.6 | mazda glc |
| 27.9 | dodge colt |
| 40.8 | datsun 210 |
| 44.3 | vw rabbit c (diesel) |
| 43.4 | vw dasher (diesel) |
| 36.4 | audi 5000s (diesel) |
| 30 | mercedes-benz 240d |
| 44.6 | honda civic 1500 gl |
| 33.8 | subaru dl |
| 29.8 | vokswagen rabbit |
| 32.7 | datsun 280-zx |
| 23.7 | mazda rx-7 gs |
| 35 | triumph tr7 coupe |
| 2.4 | honda accord |
| 27.2 | plymouth reliant |
| 26.6 | buick skylark |
| 25.8 | dodge aries wagon (sw) |
| 23.5 | chevrolet citation |
| 30 | plymouth reliant |
| 39.1 | toyota starlet |
| 39 | plymouth champ |
| 35.1 | honda civic 1300 |
| 32.3 | subaru |
| 37 | datsun 210 mpg |
| 37.7 | toyota tercel |
| 34.1 | mazda glc 4 |
| 34.7 | plymouth horizon 4 |
| 34.4 | ford escort 4w |
| 29.9 | ford escort 2h |
| 33 | volkswagen jetta |
| 33.7 | honda prelude |
| 32.4 | toyota corolla |
| 32.9 | datsun 200sx |
| 31.6 | mazda 626 |
| 28.1 | peugeot 505s turbo diesel |
| 30.7 | volvo diesel |
| 25.4 | toyota cressida |
| 24.2 | datsun 810 maxima |
| 22.4 | buick century |
| 26.6 | oldsmobile cutlass ls |
| 20.2 | ford granada gl |
| 17.6 | chrysler lebaron salon |
| 28 | chevrolet cavalier |
| 27 | chevrolet cavalier wagon |
| 34 | chevrolet cavalier 2-door |
| 31 | pontiac j2000 se hatchback |
| 29 | dodge aries se |
| 27 | pontiac phoenix |
| 24 | ford fairmont futura |
| 36 | volkswagen rabbit l |
| 37 | mazda glc custom l |
| 31 | mazda glc custom |
| 38 | plymouth horizon miser |
| 36 | mercury lynx l |
| 36 | nissan stanza xe |
| 36 | honda accord |
| 34 | toyota corolla |
| 38 | honda civic |
| 32 | honda civic (auto) |
| 38 | datsun 310 gx |
| 25 | buick century limited |
| 38 | oldsmobile cutlass ciera (diesel) |
| 26 | chrysler lebaron medallion |
| 22 | ford granada l |
| 32 | toyota celica gt |
| 36 | dodge charger 2.2 |
| 27 | chevrolet camaro |
| 27 | ford mustang gl |
| 44 | vw pickup |
| 32 | dodge rampage |
| 28 | ford ranger |
| 31 | chevy s-10 |
Question 3
| car name | weight | mpg | |
| chevrolet chevelle malibu | 3504 | 18 | |
| buick skylark 320 | 3693 | 15 | |
| plymouth satellite | 3436 | 18 | |
| amc rebel sst | 3433 | 16 | |
| ford torino | 3449 | 17 | |
| ford galaxie 500 | 4341 | 15 | |
| chevrolet impala | 4354 | 14 | |
| plymouth fury iii | 4312 | 14 | |
| pontiac catalina | 4425 | 14 | |
| amc ambassador dpl | 3850 | 15 | |
| dodge challenger se | 3563 | 15 | |
| plymouth 'cuda 340 | 3609 | 14 | |
| chevrolet monte carlo | 3761 | 15 | |
| buick estate wagon (sw) | 3086 | 14 | |
| toyota corona mark ii | 2372 | 24 | |
| plymouth duster | 2833 | 22 | |
| amc hornet | 2774 | 18 | |
| ford maverick | 2587 | 21 | |
| datsun pl510 | 2130 | 27 | |
| volkswagen 1131 deluxe sedan | 1835 | 26 | |
| peugeot 504 | 2672 | 25 | |
| audi 100 ls | 2430 | 24 | |
| saab 99e | 2375 | 25 | |
| bmw 2002 | 2234 | 26 | |
| amc gremlin | 2648 | 21 | |
| ford f250 | 4615 | 10 | |
| chevy c20 | 4376 | 10 | |
| dodge d200 | 4382 | 11 | |
| hi 1200d | 4732 | 9 | |
| datsun pl510 | 2130 | 27 | |
| chevrolet vega 2300 | 2264 | 28 | |
| toyota corona | 2228 | 25 | |
| amc gremlin | 2634 | 19 | |
| plymouth satellite custom | 3439 | 16 | |
| chevrolet chevelle malibu | 3329 | 17 | |
| ford torino 500 | 3302 | 19 | |
| amc matador | 3288 | 18 | |
| chevrolet impala | 4209 | 14 | |
| pontiac catalina brougham | 4464 | 14 | |
| ford galaxie 500 | 4154 | 14 | |
| plymouth fury iii | 4096 | 14 | |
| dodge monaco (sw) | 4955 | 12 | |
| ford country squire (sw) | 4746 | 13 | |
| pontiac safari (sw) | 5140 | 13 | |
| amc hornet sportabout (sw) | 2962 | 18 | |
| chevrolet vega (sw) | 2408 | 22 | |
| pontiac firebird | 3282 | 19 | |
| ford mustang | 3139 | 18 | |
| mercury capri 2000 | 2220 | 23 | |
| opel 1900 | 2123 | 28 | |
| peugeot 304 | 2074 | 30 | |
| fiat 124b | 2065 | 30 | |
| toyota corolla 1200 | 1773 | 31 | |
| datsun 1200 | 1613 | 35 | |
| volkswagen model 111 | 1834 | 27 | |
| plymouth cricket | 1955 | 26 | |
| toyota corona hardtop | 2278 | 24 | |
| dodge colt hardtop | 2126 | 25 | |
| volkswagen type 3 | 2254 | 23 | |
| chevrolet vega | 2408 | 20 | |
| ford pinto runabout | 2226 | 21 | |
| chevrolet impala | 4274 | 13 | |
| pontiac catalina | 4385 | 14 | |
| plymouth fury iii | 4135 | 15 | |
| ford galaxie 500 | 4129 | 14 | |
| amc ambassador sst | 3672 | 17 | |
| mercury marquis | 4633 | 11 | |
| buick lesabre custom | 4502 | 13 | |
| oldsmobile delta 88 royale | 4456 | 12 | |
| chrysler newport royal | 4422 | 13 | |
| mazda rx2 coupe | 2330 | 19 | |
| amc matador (sw) | 3892 | 15 | |
| chevrolet chevelle concours (sw) | 4098 | 13 | |
| ford gran torino (sw) | 4294 | 13 | |
| plymouth satellite custom (sw) | 4077 | 14 | |
| volvo 145e (sw) | 2933 | 18 | |
| volkswagen 411 (sw) | 2511 | 22 | |
| peugeot 504 (sw) | 2979 | 21 | |
| renault 12 (sw) | 2189 | 26 | |
| ford pinto (sw) | 2395 | 22 | |
| datsun 510 (sw) | 2288 | 28 | |
| toyouta corona mark ii (sw) | 2506 | 23 | |
| dodge colt (sw) | 2164 | 28 | |
| toyota corolla 1600 (sw) | 2100 | 27 | |
| buick century 350 | 4100 | 13 | |
| amc matador | 3672 | 14 | |
| chevrolet malibu | 3988 | 13 | |
| ford gran torino | 4042 | 14 | |
| dodge coronet custom | 3777 | 15 | |
| mercury marquis brougham | 4952 | 12 | |
| chevrolet caprice classic | 4464 | 13 | |
| ford ltd | 4363 | 13 | |
| plymouth fury gran sedan | 4237 | 14 | |
| chrysler new yorker brougham | 4735 | 13 | |
| buick electra 225 custom | 4951 | 12 | |
| amc ambassador brougham | 3821 | 13 | |
| plymouth valiant | 3121 | 18 | |
| chevrolet nova custom | 3278 | 16 | |
| amc hornet | 2945 | 18 | |
| ford maverick | 3021 | 18 | |
| plymouth duster | 2904 | 23 | |
| volkswagen super beetle | 1950 | 26 | |
| chevrolet impala | 4997 | 11 | |
| ford country | 4906 | 12 | |
| plymouth custom suburb | 4654 | 13 | |
| oldsmobile vista cruiser | 4499 | 12 | |
| amc gremlin | 2789 | 18 | |
| toyota carina | 2279 | 20 | |
| chevrolet vega | 2401 | 21 | |
| datsun 610 | 2379 | 22 | |
| maxda rx3 | 2124 | 18 | |
| ford pinto | 2310 | 19 | |
| mercury capri v6 | 2472 | 21 | |
| fiat 124 sport coupe | 2265 | 26 | |
| chevrolet monte carlo s | 4082 | 15 | |
| pontiac grand prix | 4278 | 16 | |
| fiat 128 | 1867 | 29 | |
| opel manta | 2158 | 24 | |
| audi 100ls | 2582 | 20 | |
| volvo 144ea | 2868 | 19 | |
| dodge dart custom | 3399 | 15 | |
| saab 99le | 2660 | 24 | |
| toyota mark ii | 2807 | 20 | |
| oldsmobile omega | 3664 | 11 | |
| plymouth duster | 3102 | 20 | |
| amc hornet | 2901 | 19 | |
| chevrolet nova | 3336 | 15 | |
| datsun b210 | 1950 | 31 | |
| ford pinto | 2451 | 26 | |
| toyota corolla 1200 | 1836 | 32 | |
| chevrolet vega | 2542 | 25 | |
| chevrolet chevelle malibu classic | 3781 | 16 | |
| amc matador | 3632 | 16 | |
| plymouth satellite sebring | 3613 | 18 | |
| ford gran torino | 4141 | 16 | |
| buick century luxus (sw) | 4699 | 13 | |
| dodge coronet custom (sw) | 4457 | 14 | |
| ford gran torino (sw) | 4638 | 14 | |
| amc matador (sw) | 4257 | 14 | |
| audi fox | 2219 | 29 | |
| volkswagen dasher | 1963 | 26 | |
| opel manta | 2300 | 26 | |
| toyota corona | 1649 | 31 | |
| datsun 710 | 2003 | 32 | |
| dodge colt | 2125 | 28 | |
| fiat 128 | 2108 | 24 | |
| fiat 124 tc | 2246 | 26 | |
| honda civic | 2489 | 24 | |
| subaru | 2391 | 26 | |
| fiat x1.9 | 2000 | 31 | |
| plymouth valiant custom | 3264 | 19 | |
| chevrolet nova | 3459 | 18 | |
| mercury monarch | 3432 | 15 | |
| ford maverick | 3158 | 15 | |
| pontiac catalina | 4668 | 16 | |
| chevrolet bel air | 4440 | 15 | |
| plymouth grand fury | 4498 | 16 | |
| ford ltd | 4657 | 14 | |
| buick century | 3907 | 17 | |
| chevroelt chevelle malibu | 3897 | 16 | |
| amc matador | 3730 | 15 | |
| plymouth fury | 3785 | 18 | |
| buick skyhawk | 3039 | 21 | |
| chevrolet monza 2+2 | 3221 | 20 | |
| ford mustang ii | 3169 | 13 | |
| toyota corolla | 2171 | 29 | |
| ford pinto | 2639 | 23 | |
| amc gremlin | 2914 | 20 | |
| pontiac astro | 2592 | 23 | |
| toyota corona | 2702 | 24 | |
| volkswagen dasher | 2223 | 25 | |
| datsun 710 | 2545 | 24 | |
| ford pinto | 2984 | 18 | |
| volkswagen rabbit | 1937 | 29 | |
| amc pacer | 3211 | 19 | |
| audi 100ls | 2694 | 23 | |
| peugeot 504 | 2957 | 23 | |
| volvo 244dl | 2945 | 22 | |
| saab 99le | 2671 | 25 | |
| honda civic cvcc | 1795 | 33 | |
| fiat 131 | 2464 | 28 | |
| opel 1900 | 2220 | 25 | |
| capri ii | 2572 | 25 | |
| dodge colt | 2255 | 26 | |
| renault 12tl | 2202 | 27 | |
| chevrolet chevelle malibu classic | 4215 | 17.5 | |
| dodge coronet brougham | 4190 | 16 | |
| amc matador | 3962 | 15.5 | |
| ford gran torino | 4215 | 14.5 | |
| plymouth valiant | 3233 | 22 | |
| chevrolet nova | 3353 | 22 | |
| ford maverick | 3012 | 24 | |
| amc hornet | 3085 | 22.5 | |
| chevrolet chevette | 2035 | 29 | |
| chevrolet woody | 2164 | 24.5 | |
| vw rabbit | 1937 | 29 | |
| honda civic | 1795 | 33 | |
| dodge aspen se | 3651 | 20 | |
| ford granada ghia | 3574 | 18 | |
| pontiac ventura sj | 3645 | 18.5 | |
| amc pacer d/l | 3193 | 17.5 | |
| volkswagen rabbit | 1825 | 29.5 | |
| datsun b-210 | 1990 | 32 | |
| toyota corolla | 2155 | 28 | |
| ford pinto | 2565 | 26.5 | |
| volvo 245 | 3150 | 20 | |
| plymouth volare premier v8 | 3940 | 13 | |
| peugeot 504 | 3270 | 19 | |
| toyota mark ii | 2930 | 19 | |
| mercedes-benz 280s | 3820 | 16.5 | |
| cadillac seville | 4380 | 16.5 | |
| chevy c10 | 4055 | 13 | |
| ford f108 | 3870 | 13 | |
| dodge d100 | 3755 | 13 | |
| honda accord cvcc | 2045 | 31.5 | |
| buick opel isuzu deluxe | 2155 | 30 | |
| renault 5 gtl | 1825 | 36 | |
| plymouth arrow gs | 2300 | 25.5 | |
| datsun f-10 hatchback | 1945 | 33.5 | |
| chevrolet caprice classic | 3880 | 17.5 | |
| oldsmobile cutlass supreme | 4060 | 17 | |
| dodge monaco brougham | 4140 | 15.5 | |
| mercury cougar brougham | 4295 | 15 | |
| chevrolet concours | 3520 | 17.5 | |
| buick skylark | 3425 | 20.5 | |
| plymouth volare custom | 3630 | 19 | |
| ford granada | 3525 | 18.5 | |
| pontiac grand prix lj | 4220 | 16 | |
| chevrolet monte carlo landau | 4165 | 15.5 | |
| chrysler cordoba | 4325 | 15.5 | |
| ford thunderbird | 4335 | 16 | |
| volkswagen rabbit custom | 1940 | 29 | |
| pontiac sunbird coupe | 2740 | 24.5 | |
| toyota corolla liftback | 2265 | 26 | |
| ford mustang ii 2+2 | 2755 | 25.5 | |
| chevrolet chevette | 2051 | 30.5 | |
| dodge colt m/m | 2075 | 33.5 | |
| subaru dl | 1985 | 30 | |
| volkswagen dasher | 2190 | 30.5 | |
| datsun 810 | 2815 | 22 | |
| bmw 320i | 2600 | 21.5 | |
| mazda rx-4 | 2720 | 21.5 | |
| volkswagen rabbit custom diesel | 1985 | 43.1 | |
| ford fiesta | 1800 | 36.1 | |
| mazda glc deluxe | 1985 | 32.8 | |
| datsun b210 gx | 2070 | 39.4 | |
| honda civic cvcc | 1800 | 36.1 | |
| oldsmobile cutlass salon brougham | 3365 | 19.9 | |
| dodge diplomat | 3735 | 19.4 | |
| mercury monarch ghia | 3570 | 20.2 | |
| pontiac phoenix lj | 3535 | 19.2 | |
| chevrolet malibu | 3155 | 20.5 | |
| ford fairmont (auto) | 2965 | 20.2 | |
| ford fairmont (man) | 2720 | 25.1 | |
| plymouth volare | 3430 | 20.5 | |
| amc concord | 3210 | 19.4 | |
| buick century special | 3380 | 20.6 | |
| mercury zephyr | 3070 | 20.8 | |
| dodge aspen | 3620 | 18.6 | |
| amc concord d/l | 3410 | 18.1 | |
| chevrolet monte carlo landau | 3425 | 19.2 | |
| buick regal sport coupe (turbo) | 3445 | 17.7 | |
| ford futura | 3205 | 18.1 | |
| dodge magnum xe | 4080 | 17.5 | |
| chevrolet chevette | 2155 | 30 | |
| toyota corona | 2560 | 27.5 | |
| datsun 510 | 2300 | 27.2 | |
| dodge omni | 2230 | 30.9 | |
| toyota celica gt liftback | 2515 | 21.1 | |
| plymouth sapporo | 2745 | 23.2 | |
| oldsmobile starfire sx | 2855 | 23.8 | |
| datsun 200-sx | 2405 | 23.9 | |
| audi 5000 | 2830 | 20.3 | |
| volvo 264gl | 3140 | 17 | |
| saab 99gle | 2795 | 21.6 | |
| peugeot 604sl | 3410 | 16.2 | |
| volkswagen scirocco | 1990 | 31.5 | |
| honda accord lx | 2135 | 29.5 | |
| pontiac lemans v6 | 3245 | 21.5 | |
| mercury zephyr 6 | 2990 | 19.8 | |
| ford fairmont 4 | 2890 | 22.3 | |
| amc concord dl 6 | 3265 | 20.2 | |
| dodge aspen 6 | 3360 | 20.6 | |
| chevrolet caprice classic | 3840 | 17 | |
| ford ltd landau | 3725 | 17.6 | |
| mercury grand marquis | 3955 | 16.5 | |
| dodge st. regis | 3830 | 18.2 | |
| buick estate wagon (sw) | 4360 | 16.9 | |
| ford country squire (sw) | 4054 | 15.5 | |
| chevrolet malibu classic (sw) | 3605 | 19.2 | |
| chrysler lebaron town @ country (sw) | 3940 | 18.5 | |
| vw rabbit custom | 1925 | 31.9 | |
| maxda glc deluxe | 1975 | 34.1 | |
| dodge colt hatchback custom | 1915 | 35.7 | |
| amc spirit dl | 2670 | 27.4 | |
| mercedes benz 300d | 3530 | 25.4 | |
| cadillac eldorado | 3900 | 23 | |
| peugeot 504 | 3190 | 27.2 | |
| oldsmobile cutlass salon brougham | 3420 | 23.9 | |
| plymouth horizon | 2200 | 34.2 | |
| plymouth horizon tc3 | 2150 | 34.5 | |
| datsun 210 | 2020 | 31.8 | |
| fiat strada custom | 2130 | 37.3 | |
| buick skylark limited | 2670 | 28.4 | |
| chevrolet citation | 2595 | 28.8 | |
| oldsmobile omega brougham | 2700 | 26.8 | |
| pontiac phoenix | 2556 | 33.5 | |
| vw rabbit | 2144 | 41.5 | |
| toyota corolla tercel | 1968 | 38.1 | |
| chevrolet chevette | 2120 | 32.1 | |
| datsun 310 | 2019 | 37.2 | |
| chevrolet citation | 2678 | 28 | |
| ford fairmont | 2870 | 26.4 | |
| amc concord | 3003 | 24.3 | |
| dodge aspen | 3381 | 19.1 | |
| audi 4000 | 2188 | 34.3 | |
| toyota corona liftback | 2711 | 29.8 | |
| mazda 626 | 2542 | 31.3 | |
| datsun 510 hatchback | 2434 | 37 | |
| toyota corolla | 2265 | 32.2 | |
| mazda glc | 2110 | 46.6 | |
| dodge colt | 2800 | 27.9 | |
| datsun 210 | 2110 | 40.8 | |
| vw rabbit c (diesel) | 2085 | 44.3 | |
| vw dasher (diesel) | 2335 | 43.4 | |
| audi 5000s (diesel) | 2950 | 36.4 | |
| mercedes-benz 240d | 3250 | 30 | |
| honda civic 1500 gl | 1850 | 44.6 | |
| subaru dl | 2145 | 33.8 | |
| vokswagen rabbit | 1845 | 29.8 | |
| datsun 280-zx | 2910 | 32.7 | |
| mazda rx-7 gs | 2420 | 23.7 | |
| triumph tr7 coupe | 2500 | 35 | |
| honda accord | 2290 | 2.4 | |
| plymouth reliant | 2490 | 27.2 | |
| buick skylark | 2635 | 26.6 | |
| dodge aries wagon (sw) | 2620 | 25.8 | |
| chevrolet citation | 2725 | 23.5 | |
| plymouth reliant | 2385 | 30 | |
| toyota starlet | 1755 | 39.1 | |
| plymouth champ | 1875 | 39 | |
| honda civic 1300 | 1760 | 35.1 | |
| subaru | 2065 | 32.3 | |
| datsun 210 mpg | 1975 | 37 | |
| toyota tercel | 2050 | 37.7 | |
| mazda glc 4 | 1985 | 34.1 | |
| plymouth horizon 4 | 2215 | 34.7 | |
| ford escort 4w | 2045 | 34.4 | |
| ford escort 2h | 2380 | 29.9 | |
| volkswagen jetta | 2190 | 33 | |
| honda prelude | 2210 | 33.7 | |
| toyota corolla | 2350 | 32.4 | |
| datsun 200sx | 2615 | 32.9 | |
| mazda 626 | 2635 | 31.6 | |
| peugeot 505s turbo diesel | 3230 | 28.1 | |
| volvo diesel | 3160 | 30.7 | |
| toyota cressida | 2900 | 25.4 | |
| datsun 810 maxima | 2930 | 24.2 | |
| buick century | 3415 | 22.4 | |
| oldsmobile cutlass ls | 3725 | 26.6 | |
| ford granada gl | 3060 | 20.2 | |
| chrysler lebaron salon | 3465 | 17.6 | |
| chevrolet cavalier | 2605 | 28 | |
| chevrolet cavalier wagon | 2640 | 27 | |
| chevrolet cavalier 2-door | 2395 | 34 | |
| pontiac j2000 se hatchback | 2575 | 31 | |
| dodge aries se | 2525 | 29 | |
| pontiac phoenix | 2735 | 27 | |
| ford fairmont futura | 2865 | 24 | |
| volkswagen rabbit l | 1980 | 36 | |
| mazda glc custom l | 2025 | 37 | |
| mazda glc custom | 1970 | 31 | |
| plymouth horizon miser | 2125 | 38 | |
| mercury lynx l | 2125 | 36 | |
| nissan stanza xe | 2160 | 36 | |
| honda accord | 2205 | 36 | |
| toyota corolla | 2245 | 34 | |
| honda civic | 1965 | 38 | |
| honda civic (auto) | 1965 | 32 | |
| datsun 310 gx | 1995 | 38 | |
| buick century limited | 2945 | 25 | |
| oldsmobile cutlass ciera (diesel) | 3015 | 38 | |
| chrysler lebaron medallion | 2585 | 26 | |
| ford granada l | 2835 | 22 | |
| toyota celica gt | 2665 | 32 | |
| dodge charger 2.2 | 2370 | 36 | |
| chevrolet camaro | 2950 | 27 | |
| ford mustang gl | 2790 | 27 | |
| vw pickup | 2130 | 44 | |
| dodge rampage | 2295 | 32 | |
| ford ranger | 2625 | 28 | |
| chevy s-10 | 2720 | 31 |
Question 4
| Price | 5 | |
| Units Sold | 2000 | |
| Cost Per Unit | 4.75 | |
| Profit | 500 |
Question 5
| January | February | March | April | May | June | July | August |
| 1000 | 1050 | 1100 | 900 | 1100 | 1150 | 1200 | 1300 |
Question 6
| Salesperson | Month | Sales |
| Smith | Jan | 1000 |
| Davis | Jan | 1500 |
| Lewis | Jan | 2000 |
| Austin | Jan | 1750 |
| Smith | Feb | 1100 |
| Davis | Feb | 2000 |
| Lewis | Feb | 2500 |
| Austin | Feb | 1800 |
| Smith | Mar | 1200 |
| Davis | Mar | 1350 |
| Lewis | Mar | 1750 |
| Austin | Mar | 2000 |
