Havard University Create a 5 Bucket Gains Chart for Entertainment Website Excel Task

User Generated

ebhebh01

Business Finance

Havard university

Description

Only do question 6: Based on last week’s “That’s Entertainment” website, now create a 5 Bucket Gains Chart).

and you need to use "autos_mpg" file to finish it.

The answer for question 1-5 are in "assignment 6"

Unformatted Attachment Preview

autos_mpg mpg cylinders displacement horsepower weight 18 8 307 130 acceleration model_year origin car_name 3504 12 15 8 350 165 3693 11.5 70 1 buick skylark 320 18 8 318 150 3436 11 70 70 1 1 chevrolet chevelle malibu plymouth satellite 16 8 304 150 3433 12 70 1 amc rebel sst 17 8 302 140 3449 10.5 70 1 ford torino 15 8 429 198 4341 10 70 1 ford galaxie 500 14 8 454 220 4354 9 70 1 chevrolet impala 14 8 440 215 4312 8.5 70 1 plymouth fury iii 14 8 455 225 4425 10 70 1 pontiac catalina 15 8 390 190 3850 8.5 70 1 amc ambassador dpl 15 8 383 170 3563 10 70 1 dodge challenger se 14 8 340 160 3609 8 70 1 plymouth 'cuda 340 15 8 400 150 3761 9.5 70 1 chevrolet monte carlo 14 8 455 225 3086 10 70 1 buick estate wagon (sw) 24 4 113 95 2372 15 70 3 toyota corona mark ii 22 6 198 95 2833 15.5 70 1 plymouth duster 18 6 199 97 2774 15.5 70 1 amc hornet 21 6 200 85 2587 16 70 1 ford maverick 27 4 97 88 2130 14.5 70 3 datsun pl510 26 4 97 46 1835 20.5 70 2 volkswagen 1131 deluxe sedan 25 4 110 87 2672 17.5 70 2 peugeot 504 24 4 107 90 2430 14.5 70 2 audi 100 ls 25 4 104 95 2375 17.5 70 2 saab 99e 26 4 121 113 2234 12.5 70 2 bmw 2002 21 6 199 90 2648 15 70 1 amc gremlin 10 8 360 215 4615 14 70 1 ford f250 10 8 307 200 4376 15 70 1 chevy c20 11 8 318 210 4382 13.5 70 1 dodge d200 9 8 304 193 4732 18.5 70 1 hi 1200d 27 4 97 88 2130 14.5 71 3 datsun pl510 2264 15.5 4 140 25 4 113 25 28 4 98 90 95 ? 71 1 chevrolet vega 2300 2228 14 71 3 toyota corona 2046 19 71 1 ford pinto 19 6 232 100 2634 13 71 1 amc gremlin 16 6 225 105 3439 15.5 71 1 plymouth satellite custom 17 6 250 100 3329 15.5 71 1 chevrolet chevelle malibu 19 6 250 88 3302 15.5 71 1 ford torino 500 18 6 232 100 3288 15.5 71 1 amc matador 14 8 350 165 4209 12 71 1 chevrolet impala 14 8 400 175 4464 11.5 71 1 pontiac catalina brougham 14 8 351 153 4154 13.5 71 1 ford galaxie 500 14 8 318 150 4096 13 71 1 plymouth fury iii 12 8 383 180 4955 11.5 71 1 dodge monaco (sw) 13 8 400 170 4746 12 71 1 ford country squire (sw) 13 8 400 175 5140 12 71 1 pontiac safari (sw) 18 6 258 110 2962 13.5 71 1 amc hornet sportabout (sw) 22 4 140 72 2408 19 71 1 chevrolet vega (sw) 19 6 250 100 3282 15 71 1 pontiac firebird 18 6 250 88 3139 14.5 71 1 ford mustang 23 4 122 86 2220 14 71 1 mercury capri 2000 28 4 116 90 2123 14 71 2 opel 1900 30 4 79 70 2074 19.5 71 2 peugeot 304 30 4 88 76 2065 14.5 71 2 fiat 124b 31 4 71 65 1773 19 71 3 toyota corolla 1200 35 4 72 69 1613 18 71 3 datsun 1200 27 4 97 60 1834 19 71 2 volkswagen model 111 26 4 91 70 1955 20.5 71 1 plymouth cricket 24 4 113 95 2278 15.5 72 3 toyota corona hardtop 25 4 97.5 80 2126 17 72 1 dodge colt hardtop 23 4 97 54 2254 23.5 72 2 volkswagen type 3 20 4 140 90 2408 19.5 72 1 chevrolet vega 21 4 122 86 2226 16.5 72 1 ford pinto runabout 13 8 350 165 4274 12 72 1 chevrolet impala 14 8 400 175 4385 12 72 1 pontiac catalina 15 8 318 150 4135 13.5 72 1 plymouth fury iii 14 8 351 153 4129 13 72 1 ford galaxie 500 17 8 304 150 3672 11.5 72 1 amc ambassador sst 11 8 429 208 4633 11 72 1 mercury marquis 13 8 350 155 4502 13.5 72 1 buick lesabre custom 12 8 350 160 4456 13.5 72 1 oldsmobile delta 88 royale 13 8 400 190 4422 12.5 72 1 chrysler newport royal 19 3 70 97 2330 13.5 72 3 mazda rx2 coupe 15 8 304 150 3892 12.5 72 1 amc matador (sw) 13 8 307 130 4098 14 72 1 chevrolet chevelle concours (sw) 13 8 302 140 4294 16 72 1 ford gran torino (sw) 14 8 318 150 4077 14 72 1 plymouth satellite custom (sw) 18 4 121 112 2933 14.5 72 2 volvo 145e (sw) 22 4 121 76 2511 18 72 2 volkswagen 411 (sw) 21 4 120 87 2979 19.5 72 2 peugeot 504 (sw) 26 4 96 69 2189 18 72 2 renault 12 (sw) 22 4 122 86 2395 16 72 1 ford pinto (sw) 28 4 97 92 2288 17 72 3 datsun 510 (sw) 23 4 120 97 2506 14.5 72 3 toyouta corona mark ii (sw) 28 4 98 80 2164 15 72 1 dodge colt (sw) 27 4 97 88 2100 16.5 72 3 toyota corolla 1600 (sw) 13 8 350 175 4100 13 73 1 buick century 350 14 8 304 150 3672 11.5 73 1 amc matador 13 8 350 145 3988 13 73 1 chevrolet malibu 14 8 302 137 4042 14.5 73 1 ford gran torino 15 8 318 150 3777 12.5 73 1 dodge coronet custom 12 8 429 198 4952 11.5 73 1 mercury marquis brougham 13 8 400 150 4464 12 73 1 chevrolet caprice classic 13 8 351 158 4363 13 73 1 ford ltd 14 8 318 150 4237 14.5 73 1 plymouth fury gran sedan 13 8 440 215 4735 11 73 1 chrysler new yorker brougham 12 8 455 225 4951 11 73 1 buick electra 225 custom 13 8 360 175 3821 11 73 1 amc ambassador brougham 18 6 225 105 3121 16.5 73 1 plymouth valiant 16 6 250 100 3278 18 73 1 chevrolet nova custom 18 6 232 100 2945 16 73 1 amc hornet 18 6 250 88 3021 16.5 73 1 ford maverick 23 6 198 95 2904 16 73 1 plymouth duster 26 4 97 46 1950 21 73 2 volkswagen super beetle 11 8 400 150 4997 14 73 1 chevrolet impala 12 8 400 167 4906 12.5 73 1 ford country 4654 13 12 8 350 180 4499 12.5 73 1 oldsmobile vista cruiser 18 13 6 8 232 360 100 170 2789 15 73 73 1 1 amc gremlin plymouth custom suburb 20 4 97 88 2279 19 73 3 toyota carina 21 4 140 72 2401 19.5 73 1 chevrolet vega 22 4 108 94 2379 16.5 73 3 datsun 610 18 3 70 90 2124 13.5 73 3 maxda rx3 19 4 122 85 2310 18.5 73 1 ford pinto 21 6 155 107 2472 14 73 1 mercury capri v6 26 4 98 90 2265 15.5 73 2 fiat 124 sport coupe 15 8 350 145 4082 13 73 1 chevrolet monte carlo s 16 8 400 230 4278 9.5 73 1 pontiac grand prix 29 4 68 49 1867 19.5 73 2 fiat 128 24 4 116 75 2158 15.5 73 2 opel manta 20 4 114 91 2582 14 73 2 audi 100ls 19 4 121 112 2868 15.5 73 2 volvo 144ea 15 8 318 150 3399 11 73 1 dodge dart custom 24 4 121 110 2660 14 73 2 saab 99le 20 6 156 122 2807 13.5 73 3 toyota mark ii 11 8 350 180 3664 11 73 1 oldsmobile omega 20 6 198 95 3102 16.5 74 1 plymouth duster 2875 17 74 1 ford maverick 2901 16 74 1 amc hornet 21 6 200 19 6 232 100 15 6 250 100 3336 17 74 1 chevrolet nova 31 4 79 67 1950 19 74 3 datsun b210 2451 16.5 26 4 ? 122 80 74 1 ford pinto 32 4 71 65 1836 21 74 3 toyota corolla 1200 25 4 140 75 2542 17 74 1 chevrolet vega 16 6 250 100 3781 17 74 1 chevrolet chevelle malibu classic 16 6 258 110 3632 18 74 1 amc matador 18 6 225 105 3613 16.5 74 1 plymouth satellite sebring 16 8 302 140 4141 14 74 1 ford gran torino 13 8 350 150 4699 14.5 74 1 buick century luxus (sw) 14 8 318 150 4457 13.5 74 1 dodge coronet custom (sw) 14 8 302 140 4638 16 74 1 ford gran torino (sw) 14 8 304 150 4257 15.5 74 1 amc matador (sw) 29 4 98 83 2219 16.5 74 2 audi fox 26 4 79 67 1963 15.5 74 2 volkswagen dasher 26 4 97 78 2300 14.5 74 2 opel manta 31 4 76 52 1649 16.5 74 3 toyota corona 32 4 83 61 2003 19 74 3 datsun 710 28 4 90 75 2125 14.5 74 1 dodge colt 24 4 90 75 2108 15.5 74 2 fiat 128 26 4 116 75 2246 14 74 2 fiat 124 tc 24 4 120 97 2489 15 74 3 honda civic 26 4 108 93 2391 15.5 74 3 subaru 31 4 79 67 2000 16 74 2 fiat x1.9 19 6 225 95 3264 16 75 1 plymouth valiant custom 18 6 250 105 3459 16 75 1 chevrolet nova 15 6 250 72 3432 21 75 1 mercury monarch 3158 19.5 16 8 400 170 4668 11.5 75 1 pontiac catalina 15 15 8 6 350 250 145 72 4440 14 75 75 1 1 chevrolet bel air ford maverick 16 8 318 150 4498 14.5 75 1 plymouth grand fury 14 8 351 148 4657 13.5 75 1 ford ltd 17 6 231 110 3907 21 75 1 buick century 16 6 250 105 3897 18.5 75 1 chevroelt chevelle malibu 15 6 258 110 3730 19 75 1 amc matador 18 6 225 95 3785 19 75 1 plymouth fury 21 6 231 110 3039 15 75 1 buick skyhawk 20 8 262 110 3221 13.5 75 1 chevrolet monza 2+2 13 8 302 129 3169 12 75 1 ford mustang ii 29 4 97 75 2171 16 75 3 toyota corolla 23 4 140 83 2639 17 75 1 ford pinto 20 6 232 100 2914 16 75 1 amc gremlin 23 4 140 78 2592 18.5 75 1 pontiac astro 24 4 134 96 2702 13.5 75 3 toyota corona 25 4 90 71 2223 16.5 75 2 volkswagen dasher 24 4 119 97 2545 17 75 3 datsun 710 18 6 171 97 2984 14.5 75 1 ford pinto 29 4 90 70 1937 14 75 2 volkswagen rabbit 19 6 232 90 3211 17 75 1 amc pacer 23 4 115 95 2694 15 75 2 audi 100ls 23 4 120 88 2957 17 75 2 peugeot 504 22 4 121 98 2945 14.5 75 2 volvo 244dl 121 115 25 4 2671 13.5 75 2 saab 99le 33 4 91 53 1795 17.5 75 3 honda civic cvcc 28 4 107 86 2464 15.5 76 2 fiat 131 25 4 116 81 2220 16.9 76 2 opel 1900 25 4 140 92 2572 14.9 76 1 capri ii 26 4 98 79 2255 17.7 76 1 dodge colt 27 4 101 83 2202 15.3 76 2 renault 12tl 18 8 305 140 4215 13 76 1 chevrolet chevelle malibu classic 16 8 318 150 4190 13 76 1 dodge coronet brougham 16 8 304 120 3962 13.9 76 1 amc matador 15 8 351 152 4215 12.8 76 1 ford gran torino 22 6 225 100 3233 15.4 76 1 plymouth valiant 22 6 250 105 3353 14.5 76 1 chevrolet nova 24 6 200 81 3012 17.6 76 1 ford maverick 23 6 232 90 3085 17.6 76 1 amc hornet 29 4 85 52 2035 22.2 76 1 chevrolet chevette 25 4 98 60 2164 22.1 76 1 chevrolet woody 29 4 90 70 1937 14.2 76 2 vw rabbit 33 4 91 53 1795 17.4 76 3 honda civic 20 6 225 100 3651 17.7 76 1 dodge aspen se 18 6 250 78 3574 21 76 1 ford granada ghia 19 6 250 110 3645 16.2 76 1 pontiac ventura sj 18 6 258 95 3193 17.8 76 1 amc pacer d/l 30 4 97 71 1825 12.2 76 2 volkswagen rabbit 32 4 85 70 1990 17 76 3 datsun b-210 28 4 97 75 2155 16.4 76 3 toyota corolla 27 4 140 72 2565 13.6 76 1 ford pinto 20 4 130 102 3150 15.7 76 2 volvo 245 13 8 318 150 3940 13.2 76 1 plymouth volare premier v8 19 4 120 88 3270 21.9 76 2 peugeot 504 19 6 156 108 2930 15.5 76 3 toyota mark ii 17 6 168 120 3820 16.7 76 2 mercedes-benz 280s 17 8 350 180 4380 12.1 76 1 cadillac seville 13 8 350 145 4055 12 76 1 chevy c10 13 8 302 130 3870 15 76 1 ford f108 13 8 318 150 3755 14 76 1 dodge d100 32 4 98 68 2045 18.5 77 3 honda accord cvcc 30 4 111 80 2155 14.8 77 1 buick opel isuzu deluxe 36 4 79 58 1825 18.6 77 2 renault 5 gtl 26 4 122 96 2300 15.5 77 1 plymouth arrow gs 34 4 85 70 1945 16.8 77 3 datsun f-10 hatchback 18 8 305 145 3880 12.5 77 1 chevrolet caprice classic 17 8 260 110 4060 19 77 1 oldsmobile cutlass supreme 16 8 318 145 4140 13.7 77 1 dodge monaco brougham 15 8 302 130 4295 14.9 77 1 mercury cougar brougham 18 6 250 110 3520 16.4 77 1 chevrolet concours 21 6 231 105 3425 16.9 77 1 buick skylark 19 6 225 100 3630 17.7 77 1 plymouth volare custom 19 6 250 98 3525 19 77 1 ford granada 16 8 400 180 4220 11.1 77 1 pontiac grand prix lj 16 8 350 170 4165 11.4 77 1 chevrolet monte carlo landau 16 8 400 190 4325 12.2 77 1 chrysler cordoba 16 8 351 149 4335 14.5 77 1 ford thunderbird 29 4 97 78 1940 14.5 77 2 volkswagen rabbit custom 25 4 151 88 2740 16 77 1 pontiac sunbird coupe 26 4 97 75 2265 18.2 77 3 toyota corolla liftback 26 4 140 89 2755 15.8 77 1 ford mustang ii 2+2 31 4 98 63 2051 17 77 1 chevrolet chevette 34 4 98 83 2075 15.9 77 1 dodge colt m/m 30 4 97 67 1985 16.4 77 3 subaru dl 31 4 97 78 2190 14.1 77 2 volkswagen dasher 22 6 146 97 2815 14.5 77 3 datsun 810 22 4 121 110 2600 12.8 77 2 bmw 320i 22 3 80 110 2720 13.5 77 3 mazda rx-4 43 4 90 48 1985 21.5 78 2 volkswagen rabbit custom diesel 36 4 98 66 1800 14.4 78 1 ford fiesta 33 4 78 52 1985 19.4 78 3 mazda glc deluxe 39 4 85 70 2070 18.6 78 3 datsun b210 gx 36 4 91 60 1800 16.4 78 3 honda civic cvcc 20 8 260 110 3365 15.5 78 1 oldsmobile cutlass salon brougham 19 8 318 140 3735 13.2 78 1 dodge diplomat 20 8 302 139 3570 12.8 78 1 mercury monarch ghia 19 6 231 105 3535 19.2 78 1 pontiac phoenix lj 21 6 200 95 3155 18.2 78 1 chevrolet malibu 20 6 200 85 2965 15.8 78 1 ford fairmont (auto) 140 88 21 6 225 100 3430 17.2 78 1 plymouth volare 19 25 6 4 232 90 3210 2720 17.2 15.4 78 78 1 1 amc concord ford fairmont (man) 21 6 231 105 3380 15.8 78 1 buick century special 21 6 200 85 3070 16.7 78 1 mercury zephyr 19 6 225 110 3620 18.7 78 1 dodge aspen 18 6 258 120 3410 15.1 78 1 amc concord d/l 19 8 305 145 3425 13.2 78 1 chevrolet monte carlo landau 18 6 231 165 3445 13.4 78 1 buick regal sport coupe (turbo) 18 8 302 139 3205 11.2 78 1 ford futura 18 8 318 140 4080 13.7 78 1 dodge magnum xe 30 4 98 68 2155 16.5 78 1 chevrolet chevette 28 4 134 95 2560 14.2 78 3 toyota corona 27 4 119 97 2300 14.7 78 3 datsun 510 31 4 105 75 2230 14.5 78 1 dodge omni 21 4 134 95 2515 14.8 78 3 toyota celica gt liftback 23 4 156 105 2745 16.7 78 1 plymouth sapporo 24 4 151 85 2855 17.6 78 1 oldsmobile starfire sx 24 4 119 97 2405 14.9 78 3 datsun 200-sx 20 5 131 103 2830 15.9 78 2 audi 5000 17 6 163 125 3140 13.6 78 2 volvo 264gl 22 4 121 115 2795 15.7 78 2 saab 99gle 16 6 163 133 3410 15.8 78 2 peugeot 604sl 32 4 89 71 1990 14.9 78 2 volkswagen scirocco 30 4 98 68 2135 16.6 78 3 honda accord lx 22 6 231 115 3245 15.4 79 1 pontiac lemans v6 20 6 200 85 2990 18.2 79 1 mercury zephyr 6 22 4 140 88 2890 17.3 79 1 ford fairmont 4 20 6 232 90 3265 18.2 79 1 amc concord dl 6 21 6 225 110 3360 16.6 79 1 dodge aspen 6 17 8 305 130 3840 15.4 79 1 chevrolet caprice classic 18 8 302 129 3725 13.4 79 1 ford ltd landau 17 8 351 138 3955 13.2 79 1 mercury grand marquis 18 8 318 135 3830 15.2 79 1 dodge st. regis 17 8 350 155 4360 14.9 79 1 buick estate wagon (sw) 16 8 351 142 4054 14.3 79 1 ford country squire (sw) 19 8 267 125 3605 15 79 1 chevrolet malibu classic (sw) 19 8 360 150 3940 13 79 1 chrysler lebaron town @ country (sw) 32 4 89 71 1925 14 79 2 vw rabbit custom 34 4 86 65 1975 15.2 79 3 maxda glc deluxe 36 4 98 80 1915 14.4 79 1 dodge colt hatchback custom 27 4 121 80 2670 15 79 1 amc spirit dl 25 5 183 77 3530 20.1 79 2 mercedes benz 300d 23 8 350 125 3900 17.4 79 1 cadillac eldorado 27 4 141 71 3190 24.8 79 2 peugeot 504 24 8 260 90 3420 22.2 79 1 oldsmobile cutlass salon brougham 34 4 105 70 2200 13.2 79 1 plymouth horizon 35 4 105 70 2150 14.9 79 1 plymouth horizon tc3 32 4 85 65 2020 19.2 79 3 datsun 210 37 4 91 69 2130 14.7 79 2 fiat strada custom 28 4 151 90 2670 16 79 1 buick skylark limited 29 6 173 115 2595 11.3 79 1 chevrolet citation 115 6 173 34 4 151 90 2556 13.2 79 1 pontiac phoenix 42 27 4 98 76 2144 2700 14.7 12.9 80 79 2 1 vw rabbit oldsmobile omega brougham 38 4 89 60 1968 18.8 80 3 toyota corolla tercel 32 4 98 70 2120 15.5 80 1 chevrolet chevette 37 4 86 65 2019 16.4 80 3 datsun 310 28 4 151 90 2678 16.5 80 1 chevrolet citation 26 4 140 88 2870 18.1 80 1 ford fairmont 24 4 151 90 3003 20.1 80 1 amc concord 19 6 225 90 3381 18.7 80 1 dodge aspen 34 4 97 78 2188 15.8 80 2 audi 4000 30 4 134 90 2711 15.5 80 3 toyota corona liftback 31 4 120 75 2542 17.5 80 3 mazda 626 37 4 119 92 2434 15 80 3 datsun 510 hatchback 32 4 108 75 2265 15.2 80 3 toyota corolla 47 4 86 65 2110 17.9 80 3 mazda glc 28 4 156 105 2800 14.4 80 1 dodge colt 41 4 85 65 2110 19.2 80 3 datsun 210 44 4 90 48 2085 21.7 80 2 vw rabbit c (diesel) 43 4 90 48 2335 23.7 80 2 vw dasher (diesel) 36 5 121 67 2950 19.9 80 2 audi 5000s (diesel) 30 4 146 67 3250 21.8 80 2 mercedes-benz 240d 45 4 91 67 1850 13.8 80 3 honda civic 1500 gl 1835 17.3 80 2 renault lecar deluxe 67 2145 18 80 3 subaru dl 41 4 85 34 4 97 ? 30 4 89 62 1845 15.3 80 2 vokswagen rabbit 33 6 168 132 2910 11.4 80 3 datsun 280-zx 1 24 3 70 35 4 122 24 4 140 32 4 107 27 4 135 27 4 151 100 2420 12.5 80 3 mazda rx-7 gs 88 2500 15.1 80 2 triumph tr7 coupe 2905 14.3 80 1 ford mustang cobra 72 2290 17 80 3 honda accord ? 84 2490 15.7 81 1 plymouth reliant 84 2635 16.4 81 1 buick skylark 26 4 156 92 2620 14.4 81 1 dodge aries wagon (sw) 24 6 173 110 2725 12.6 81 1 chevrolet citation 30 4 135 84 2385 12.9 81 1 plymouth reliant 39 4 79 58 1755 16.9 81 3 toyota starlet 39 4 86 64 1875 16.4 81 1 plymouth champ 35 4 81 60 1760 16.1 81 3 honda civic 1300 32 4 97 67 2065 17.8 81 3 subaru 37 4 85 65 1975 19.4 81 3 datsun 210 mpg 38 4 89 62 2050 17.3 81 3 toyota tercel 34 4 91 68 1985 16 81 3 mazda glc 4 35 4 105 63 2215 14.9 81 1 plymouth horizon 4 34 4 98 65 2045 16.2 81 1 ford escort 4w 30 4 98 65 2380 20.7 81 1 ford escort 2h 33 4 105 74 2190 14.2 81 2 volkswagen jetta 2320 15.8 81 2 renault 18i 75 2210 14.4 81 3 honda prelude 35 4 100 34 4 107 ? 32 4 108 75 2350 16.8 81 3 toyota corolla 33 4 119 100 2615 14.8 81 3 datsun 200sx 32 4 120 74 2635 18.3 81 3 mazda 626 28 4 141 80 3230 20.4 81 2 peugeot 505s turbo diesel 31 6 145 76 3160 19.6 81 2 volvo diesel 25 6 168 116 2900 12.6 81 3 toyota cressida 24 6 146 120 2930 13.8 81 3 datsun 810 maxima 22 6 231 110 3415 15.8 81 1 buick century 27 8 350 105 3725 19 81 1 oldsmobile cutlass ls 20 6 200 88 3060 17.1 81 1 ford granada gl 18 6 225 85 3465 16.6 81 1 chrysler lebaron salon 28 4 112 88 2605 19.6 82 1 chevrolet cavalier 27 4 112 88 2640 18.6 82 1 chevrolet cavalier wagon 34 4 112 88 2395 18 82 1 chevrolet cavalier 2-door 31 4 112 85 2575 16.2 82 1 pontiac j2000 se hatchback 29 4 135 84 2525 16 82 1 dodge aries se 27 4 151 90 2735 18 82 1 pontiac phoenix 24 4 140 23 4 151 92 36 4 105 74 1980 15.3 82 2 volkswagen rabbit l 37 4 91 68 2025 18.2 82 3 mazda glc custom l ? 2865 16.4 82 1 ford fairmont futura 3035 20.5 82 1 amc concord dl 31 4 91 68 1970 17.6 82 3 mazda glc custom 38 4 105 63 2125 14.7 82 1 plymouth horizon miser 36 4 98 70 2125 17.3 82 1 mercury lynx l 36 4 120 88 2160 14.5 82 3 nissan stanza xe 36 4 107 75 2205 14.5 82 3 honda accord 34 4 108 70 2245 16.9 82 3 toyota corolla 38 4 91 67 1965 15 82 3 honda civic 32 4 91 67 1965 15.7 82 3 honda civic (auto) 38 4 91 67 1995 16.2 82 3 datsun 310 gx 25 6 181 110 2945 16.4 82 1 buick century limited 38 6 262 85 3015 17 82 1 oldsmobile cutlass ciera (diesel) 26 4 156 92 2585 14.5 82 1 chrysler lebaron medallion 22 6 232 112 2835 14.7 82 1 ford granada l 32 4 144 96 2665 13.9 82 3 toyota celica gt 36 4 135 84 2370 13 82 1 dodge charger 2.2 27 4 151 90 2950 17.3 82 1 chevrolet camaro 27 4 140 86 2790 15.6 82 1 ford mustang gl 44 4 97 52 2130 24.6 82 2 vw pickup 32 4 135 84 2295 11.6 82 1 dodge rampage 28 4 120 79 2625 18.6 82 1 ford ranger 31 4 119 82 2720 19.4 82 1 chevy s-10 2 Cust_ID TSLO NM_ORD DOLL_CR 1001 2 3 66 1002 4 1 26 1003 3 2 50 1004 12 3 56 1005 15 4 83 1006 5 9 220 1007 3 6 150 1008 2 7 155 1009 1 2 52 1010 2 2 42 1011 5 1 26 1012 4 2 42 1013 2 1 29 1014 4 3 77 1015 16 1 18 1016 18 2 36 1017 7 3 60 1018 4 7 160 1019 3 10 240 1020 9 2 38 1021 7 2 42 1022 4 1 27 1023 5 2 35 1024 9 4 84 1025 10 2 39 1026 3 4 86 1027 7 2 42 1028 1 1 31 1029 9 2 40 1030 7 2 42 1031 5 5 122 1032 12 3 55 1033 4 2 55 1034 3 3 76 1035 6 3 77 1036 6 6 133 1037 12 3 60 1038 8 3 60 1039 7 4 84 1040 5 1 21 1041 10 2 38 1042 4 5 114 ORDER 1 0 0 1 1 1 1 1 1 1 0 0 1 1 0 0 1 1 1 0 0 0 0 1 0 1 0 1 0 0 1 0 1 0 0 1 0 0 0 0 0 1 1043 10 2 40 1044 7 1 20 1045 6 1 21 1046 5 8 191 1047 7 7 158 1048 4 5 121 1049 2 2 46 1050 5 4 85 1051 1052 1053 1054 1055 1056 1057 1058 1059 1060 1061 1062 1063 1064 1065 1066 1067 1068 1069 1070 1071 1072 1073 1074 1075 1076 1077 1078 1079 1080 1081 1082 1083 1084 1085 3 10 240 2 7 155 3 6 150 2 3 66 1 2 52 3 2 50 2 2 46 2 2 42 1 1 31 2 1 29 4 7 160 4 5 121 4 5 114 3 4 86 4 3 77 3 3 76 4 2 42 4 2 55 4 1 27 4 1 26 5 9 220 5 8 191 6 6 133 5 5 122 5 4 85 6 3 77 5 2 35 5 1 26 5 1 21 6 1 21 7 7 158 7 4 84 9 4 84 7 3 60 8 3 60 0 0 0 1 0 1 1 1 1 0 0 0 1 0 0 1 0 0 0 1 1 0 1 0 1 0 1 0 0 1 0 0 0 1 0 0 0 0 1 0 0 1 0 1086 1087 1088 1089 1090 1091 1092 1093 1094 1095 1096 1097 1098 1099 1100 1101 1102 1103 1104 1105 1106 1107 1108 1109 1110 1111 1112 1113 1114 1115 1116 1117 1118 1119 1120 1121 1122 1123 1124 1125 1126 1127 1128 9 2 38 7 2 42 7 2 42 7 2 42 7 1 20 15 4 83 12 3 56 12 3 55 12 3 60 10 2 39 10 2 38 18 2 36 9 2 40 10 2 40 16 1 18 3 10 240 2 7 155 3 6 150 2 3 66 1 2 52 3 2 50 2 2 46 2 2 42 1 1 31 1 0 0 0 0 0 1 0 1 0 1 0 0 0 0 1 1 1 1 0 0 1 1 1 2 1 29 0 4 7 160 1 4 5 121 0 4 5 114 3 4 86 4 3 77 3 3 76 4 2 42 4 2 55 4 1 27 4 1 26 5 9 220 5 8 191 6 6 133 5 5 122 5 4 85 6 3 77 5 2 35 5 1 26 0 1 1 0 0 0 0 1 1 0 1 1 0 0 0 0 1129 1130 1131 1132 1133 1134 1135 1136 1137 1138 1139 1140 1141 1142 1143 1144 1145 1146 1147 1148 1149 1150 5 1 21 6 1 21 7 7 158 7 4 84 9 4 84 7 3 60 8 3 60 9 2 38 7 2 42 7 2 42 7 2 42 7 1 20 15 4 83 12 3 56 12 3 55 12 3 60 10 2 39 10 2 38 18 2 36 9 2 40 10 2 40 16 1 18 0 1 1 1 1 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 Q1 SUMMARY OUTPUT Regression Statistics Multiple R 0.429401 R Square 0.184386 Adjusted R Square 0.167626 Standard Error 0.448453 Observations 150 ANOVA df Regression Residual Total SS MS F Significance F 3 6.637882 2.212627 11.00205 1.48E-06 146 29.36212 0.20111 149 36 Coefficients Standard Error t Stat Intercept 0.360929 0.098407 3.667701 TSLO -0.03309 0.012258 -2.6992 NM_ORD 0.142981 0.162186 0.881588 DOLL_CR -0.00301 0.006855 -0.43958 P-value Lower 95% Upper 95%Lower 95.0% Upper 95.0% 0.000342 0.166442 0.555415 0.166442 0.555415 0.007771 -0.05731 -0.00886 -0.05731 -0.00886 0.379449 -0.17755 0.463517 -0.17755 0.463517 0.660891 -0.01656 0.010535 -0.01656 0.010535 Q2: Based on the output, the variables NM_ORD and DOLL_CR may be correlated as their p values are both non significant. The non significance may be due to multicolinearlity. Q3 TSLO TSLO NM_ORD DOLL_CR NM_ORD DOLL_CR 1 -0.1639 1 -0.23938 0.991825 1 Based on the correlation output, the variables DOLL_CR and NM_ORD are highly correlated as the =y hae a correlation value of 0.991. Based on the initial model, the variable DOLL_CR has a much larger p value and is therefore much weaker predictor. It is removed from the model. Q5 SUMMARY OUTPUT Regression Statistics Multiple R 0.428143 R Square 0.183306 Adjusted R Square 0.172195 Standard Error 0.447221 Observations 150 ANOVA df Regression Residual Total Intercept TSLO NM_ORD SS MS 2 6.599021 3.29951 147 29.40098 0.200007 149 36 Coefficients Standard Error t Stat 0.350383 0.095176 3.681417 -0.0298 0.009684 -3.0772 0.072075 0.016839 4.280319 F Significance F 16.497 3.43841E-07 P-value Lower 95% Upper 95%Lower 95.0% 0.000325 0.162292821 0.538473 0.162293 0.002493 -0.048935804 -0.01066 -0.04894 3.35E-05 0.038797745 0.105352 0.038798 Q4: The p value associated with TSLO is lower than 0.05. This indicates that the variable is a significant predictor of order status. The slope of the coefficient is 0.03. The slope indicates that order decreases by 0.03 for every 1 increase in TSLO. The p value associated with NM_ORD is lower than 0.05. This indicates that the variable is a significant predictor of order status. The slope of the coefficient is 0.07. The slope indicates that order increases by 0.07 for every 1 increase in NM_ORD. Upper 95.0% 0.538473 -0.01066 0.105352 Project • That's Entertainment is a club marketer of videos. They are testing a new music club concept. A 25,000 sample of names from the That's Entertainment database was test mailed for this brand new music club concept. For those names that joined the new club, they received 10 free CDs and agreed to purchase 2 more CD's over the next 12 months. The test had a response rate of 40% for the initial offer of 10 free CD's. All customer data was saved point-in-time of the promotion for future analysis purposes. • That's Entertainment has decided to roll-out with the new music club concept. They do not wish to promote all names on their customer database. As such, they have requested the build of a response model to help them select the names most likely to join the club. . FORTINO Global Education The Assignment . Using the frozen file, you will build a multiple regression response model predicting who is most likely to join the new music club. You will use Excel for this exercise and base the analysis on a sub sample of 150 names randomly drawn from the 25,000 sample. FORTINO Global Education Your Assignment . Using Excel(Go to HW folder for That's Entertainment excel sheet) and perform the following tasks: 1. Run a multiple regression model using all three variables simultaneously (TSLO, DOLL_CR, and NM_ORD) as your predictors and using the order indicator (ORDER) as the dependent variable. 2. Examine the output. Do you see any problems with the coefficients that may be due to multicollinearity? If so, run a correlation analysis to confirm. What do you notice? 3. If there is a problem with one of the variables being correlated with another, determine which variable to delete and rerun your model. Explain how you determined which variable to delete. 4. Once all issues of multicollinearity are taken care of, examine the p-values associated with your predictor coefficients and comment? 5. What is your final model? 6. Now do the same thing with the cars data set in SAS (from SASHelp library) with at least four variables as predictors and one dependent variable. Interpret results. Extra Credit: Compute a 5 Bucket gains chart Look into Stepwise/Backwards/Forward Regression and apply to this project. - FORTINO Global Education
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Please check it, there is still problem with 5 buckets gain chart, i'm trying to fix.... I need your review,

SUMMARY OUTPUT
Regression Statistics
Multiple R
0.822541082
R Square
0.676573831
Adjusted R Square
0.673281962
Standard Error
4.467558369
Observations
398
ANOVA
df
Regression
Residual
Total

Intercept
cylinders
displacement
horsepower
acceleration

4
393
397

SS
16408.65791
7843.917566
24252.57548

MS
F
4102.164478 205.5287586
19.95907778

Coefficients
48.23348594
-0.666101861
-0.025746521
-0.091821598
-0.419827778

Standard Error
2.761507615
0.426449649
0.008552061
0.015668056
0.114492605

t Stat
P-value
17.46635993 5.67992E-51
-1.561970712 0.119099754
-3.010563423 0.00277593
-5.860433417 9.78012E-09
-3.666854978 0.000279328

Q6:
The p value associated with displacement, horsepower and acceleration is
lower than 0.05. This indicates that these variable are significant predictor
of mpg.
The slope of displacement the coefficient is -0.02. It indicates that order
decreases by 0.02 for every 1 increase in displacemnt.

Significance F
6.27697E-95

Lower 95%
42.80431057
-1.504509809
-0.042560032
-0.122625287
-0.64492237

The slope of displacement the coefficient is -0.02. It indicates that order
decreases by 0.02 for every 1 increase in displacemnt.

Upper 95%
53.66266132
0.172306086
-0.008933011
-0.061017909
-0.194733186

Lower 95.0%
Upper 95.0%
42.80431057
53.66266132
-1.504509809
0.172306086
-0.042560032 -0.008933011
-0.122625287 -0.061017909
-0.64492237 -0.194733186

is

autos_mpg
mpg
18.0

cylinders

displacement
8

307

horsepower
130

acceleration
12

weight

model_year
3504

70

origin
1

car_name
chevrolet chevelle malibu

15.0

8

350

165

12

3693

70

1

buick skylark 320

18.0

8

318

150

11

3436

70

1

plymouth satellite

16.0

8

304

150

12

3433

70

1

amc rebel sst

17.0

8

302

140

11

3449

70

1

ford torino

198

10

15.0

8

429

4341

70

1

ford galaxie 500

14.0

8

454

220

9

4354

70

1

chevrolet impala

14.0

8

440

215

9

4312

70

1

plymouth fury iii

14.0

8

455

225

10

4425

70

1

pontiac catalina

15.0

8

390

190

9

3850

70

1

amc ambassador dpl

15.0

8

383

170

10

3563

70

1

dodge challenger se

14.0

8

340

160

8

3609

70

1

plymouth 'cuda 340

15.0

8

400

150

10

3761

70

1

chevrolet monte carlo

14.0

8

455

225

10

3086

70

1

buick estate wagon (sw)

24.0

4

113

95

15

2372

70

3

toyota corona mark ii

22.0

6

198

95

16

2833

70

1

plymouth duster

18.0

6

199

97

16

2774

70

1

amc hornet

21.0

6

200

85

16

2587

70

1

ford maverick

27.0

4

97

88

15

2130

70

3

datsun pl510

26.0

4

97

46

21

1835

70

2

volkswagen 1131 deluxe sedan

25.0

4

110

87

18

2672

70

2

peugeot 504

24.0

4

107

90

15

2430

70

2

audi 100 ls

25.0

4

104

95

18

2375

70

2

saab 99e

26.0

4

121

113

13

2234

70

2

bmw 2002

21.0

6

199

90

15

2648

70

1

amc gremlin

10.0

8

360

215

14

4615

70

1

ford f250

10.0

8

307

200

15

4376

70

1

chevy c20

11.0

8

318

210

14

4382

70

1

dodge d200

9.0

8

304

193

19

4732

70

1

hi 1200d

27.0

4

97

88

15

2130

71

3

datsun pl510

4

140

25.0

4

113

95

14

2228

71

3

toyota corona

25.0

28.0

4

98

102

90

19

16

2046

2264

71

71

1

1

ford pinto

chevrolet vega 2300

19.0

6

232

100

13

2634

71

1

amc gremlin

16.0

6

225

105

16

3439

71

1

plymouth satellite custom

17.0

6

250

100

16

3329

71

1

chevrolet chevelle malibu

19.0

6

250

88

16

3302

71

1

ford torino 500

18.0

6

232

100

16

3288

71

1

amc matador

14.0

8

350

165

12

4209

71

1

chevrolet impala

14.0

8

400

175

12

4464

71

1

pontiac catalina brougham

14.0

8

351

153

14

4154

71

1

ford galaxie 500

14.0

8

318

150

13

4096

71

1

plymouth fury iii

12.0

8

383

180

12

4955

71

1

dodge monaco (sw)

13.0

8

400

170

12

4746

71

1

ford country squire (sw)

13.0

8

400

175

12

5140

71

1

pontiac safari (sw)

18.0

6

258

110

14

2962

71

1

amc hornet sportabout (sw)

22.0

4

140

72

19

2408

71

1

chevrolet vega (sw)

19.0

6

250

100

15

3282

71

1

pontiac firebird

18.0

6

250

88

15

3139

71

1

ford mustang

23.0

4

122

86

14

2220

71

1

mercury capri 2000

28.0

4

116

90

14

2123

71

2

opel 1900

30.0

4

79

70

20

2074

71

2

peugeot 304

30.0

4

88

76

15

2065

71

2

fiat 124b

31.0

4

71

65

19

1773

71

3

toyota corolla 1200

35.0

4

72

69

18

1613

71

3

datsun 1200

27.0

4

97

60

19

1834

71

2

volkswagen m...


Anonymous
Goes above and beyond expectations!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags