Business statistics questions, using simple excel commands, help?

profilekool92
yolo.xls
Home>Information Systems homework help>Business statistics questions, using simple excel commands, help?

DATA

Length (in.) Width (in.) Height (in.) Wheelbase (in.) Weight Max. Cargo Load (lbs) Cargo volume (cu ft) Front Shoulder Room (in.) Front Leg Room (in.) Front Head Room (in.) HP MPG Acceleration Braking from 60 mpg dry (sec.) Braking from 60 mpg wet (sec.) AM Maximum speed (MPH) Turning Circle (ft.) Origin Vehicle Type Transmission
191 79 66 108 4595 1160 36 62 41 5 300 17 8.0 134 139 48.0 40 Asia 4 Door SUV Auto 5
181 74 65 104 4015 870 30 58 41 4 240 18 7.4 133 145 53.5 41 Asia 4 Door SUV Auto 5
194 73 57 110 4085 850 13 58 43 4 300 18 6.9 131 148 51.5 43 Asia Sedan Auto 5
195 74 57 109 3705 850 13 58 42 4 270 23 6.7 130 138 52.5 42 Asia Sedan Auto 5
169 77 56 102 3305 990 20 54 42 5 200 25 7.3 134 149 54.0 35 Europe 4 Door Hatchback Seq 6
194 71 57 112 4115 1100 16 56 42 3 255 21 7.7 129 144 52.0 40 Europe Sedan Auto 6
204 75 57 121 4505 1210 18 59 43 3 330 17 7.6 131 140 49.5 41 Europe Sedan Auto 6
200 78 68 118 5465 1325 37 58 42 4 350 15 8.2 138 146 46.0 40 Europe 4 Door SUV Auto 6
181 72 56 104 3920 1145 13 55 43 3 340 20 5.3 124 140 54.5 38 Europe Sedan Man 6
178 72 56 109 3485 1060 11 55 41 4 215 24 7.4 134 142 55.0 37 Europe Wagon Auto 6
191 73 58 114 3785 1100 14 57 41 4 300 22 5.8 138 149 51.5 39 Europe Sedan Auto 6
190 73 54 109 3885 840 13 57 43 4 360 19 5.6 122 133 55.5 40 Europe Coupe Auto 6
204 75 59 123 4505 1060 18 59 42 4 325 18 6.9 135 154 52.0 42 Europe Sedan Auto 6
180 73 66 110 4065 1005 33 55 42 4 260 19 7.9 129 140 55.0 39 Europe 4 Door SUV Auto 6
191 76 70 116 5025 1350 36 60 41 4 260 17 8.6 130 142 53.0 42 Europe 4 Door SUV Auto 6
161 70 50 98 3170 550 2 52 41 5 225 26 6.0 117 126 55.5 33 Europe Coupe Man 6
201 78 70 119 5100 1335 44 62 42 4 275 15 8.9 142 153 50.0 43 United States 4 Door SUV Auto 6
198 73 57 111 3565 915 16 57 41 2 200 18 9.0 146 160 50.0 40 United States Sedan Auto 4
203 74 58 116 4095 925 17 58 43 3 197 19 9.2 155 175 46.0 44 United States Sedan Auto 4
208 75 58 116 4085 1095 19 61 42 3 275 17 7.6 152 180 46.5 46 United States Sedan Auto 4
203 79 75 116 5810 1330 47 64 40 3 403 13 7.5 158 181 46.5 42 United States 4 Door SUV Auto 6
195 73 68 116 4730 1285 37 58 40 4 255 16 8.3 138 152 51.5 42 United States 4 Door SUV Auto 5
196 73 58 116 4000 890 14 58 42 3 255 18 7.1 131 146 51.5 40 United States Sedan Auto 5
178 72 50 106 3680 400 4 53 41 3 320 17 6.4 133 145 54.5 41 United States Coupe Auto 5
154 66 59 98 2560 860 7 53 40 5 103 27 11.2 137 146 51.5 35 United States Sedan Man 5
180 68 57 103 2920 890 14 53 41 4 145 23 8.8 141 152 50.5 37 United States Sedan Auto 4
175 73 49 106 3280 390 11 54 41 4 400 21 5.0 126 145 54.5 42 United States Coupe Man 6
189 71 69 113 3880 1115 37 56 41 4 185 18 9.1 146 153 49.5 43 United States 4 Door SUV Auto 5
176 69 65 104 3265 820 30 54 42 3 172 23 9.2 148 159 49.5 41 United States 4 Door SUV Auto 4
200 73 59 111 3710 945 19 58 41 4 242 20 7.8 141 155 50.0 41 United States Sedan Auto 4
222 79 77 130 5935 1460 61 65 42 4 320 14 9.1 147 165 45.0 45 United States 4 Door SUV Auto 4
202 79 77 116 5715 1580 51 65 41 7 320 14 9.0 151 168 44.0 42 United States 4 Door SUV Auto 4
192 75 75 113 4830 1020 39 59 40 3 291 15 9.1 152 159 49.5 39 United States 4 Door SUV Auto 4
205 72 72 121 4420 1410 51 59 40 4 240 18 8.8 135 153 51.5 43 United States Minivan Auto 4
197 74 58 120 4105 865 16 60 43 5 340 16 6.4 133 139 51.5 41 United States Sedan Auto 5
199 79 67 116 4720 1000 36 60 38 3 253 16 8.6 135 146 49.0 42 United States 4 Door SUV Auto 6
169 67 61 103 3350 865 32 54 41 2 180 20 8.1 143 165 51.0 41 United States Auto 4
191 73 59 109 3335 825 13 57 41 6 173 23 10.2 145 156 51.0 40 United States Sedan Auto 4
203 77 69 121 4755 1150 62 63 41 4 251 17 8.8 149 172 46.5 42 United States Minivan Auto 6
174 69 60 104 3185 865 20 54 42 6 172 22 10.3 141 157 51.5 39 United States 4 Door Hatchback CVT
200 75 58 120 3895 865 16 60 42 3 340 17 6.0 131 134 54.0 41 United States Sedan Auto 5
201 76 74 119 5150 1455 45 59 42 4 335 12 7.6 155 167 47.5 43 United States 4 Door SUV Auto 5
203 77 69 121 4600 1150 62 63 41 6 197 16 10.3 154 182 47.0 42 United States Minivan Auto 6
198 74 58 120 3950 865 30 54 42 3 250 19 8.8 138 166 48.0 41 United States Wagon Auto 4
179 73 69 109 4340 1150 40 57 42 4 210 16 9.1 142 167 46.5 39 United States 4 Door SUV Auto 4
176 75 48 99 3480 465 6 54 40 4 510 15 4.2 113 130 57.0 43 United States Coupe Man 6
186 76 67 111 4540 910 36 59 41 3 265 16 8.3 147 159 49.5 39 United States 4 Door SUV Auto 6
175 70 70 103 3605 1000 38 56 41 4 200 19 10.5 161 215 49.5 40 United States 4 Door SUV Auto 4
221 79 77 131 6325 1570 73 63 40 4 300 13 9.1 154 166 46.5 45 United States 4 Door SUV Auto 6
193 74 73 114 4905 1275 48 59 41 3 210 15 9.7 152 163 50.5 38 United States 4 Door SUV Auto 5
190 72 56 107 3480 850 16 58 41 3 221 20 8.0 136 143 52.5 42 United States Sedan Auto 6
188 74 55 107 3585 720 13 56 41 5 300 20 5.5 131 144 55.0 39 United States Coupe Man 5
200 75 67 113 4420 1150 38 59 39 3 263 16 8.5 147 152 52.0 42 United States Sedan Auto 6
177 69 57 106 2810 850 13 53 41 3 140 31 8.6 136 136 54.0 39 Asia Sedan Man 5
178 72 66 103 3505 850 26 57 41 4 166 21 10.6 135 139 53.5 39 Asia 4 Door SUV Auto 5
170 72 70 101 3650 675 47 57 41 8 166 21 10.4 140 162 51.5 36 Asia 4 Door SUV Auto 5
162 67 60 98 2370 850 24 53 41 6 109 34 9.9 134 144 56.0 36 Asia 4 Door Hatchback Man 5
201 77 69 118 4615 1320 67 63 42 5 255 19 8.6 136 144 50.0 40 Asia Minivan Auto 5
191 79 73 109 4510 1320 48 61 41 4 255 17 8.2 131 157 48.0 40 Asia 4 Door SUV Auto 5
162 69 51 95 2855 400 5 50 41 4 240 25 5.8 126 134 57.0 36 Asia Coupe Man 6
187 75 74 112 4940 940 38 54 42 4 220 14 11.5 149 170 45.5 37 United States 4 Door SUV Auto 4
169 67 58 98 2590 850 12 53 41 5 110 28 12.5 134 153 55.0 36 Asia Sedan Auto 4
193 73 59 109 3835 860 17 58 40 4 263 19 7.1 134 144 51.5 41 Asia Sedan Auto 5
177 70 58 104 2945 850 14 55 40 3 138 27 10.4 138 152 51.0 37 Asia Sedan Auto 4
184 74 68 106 4345 1120 38 60 41 3 242 18 8.5 131 139 51.5 39 Asia 4 Door SUV Auto 5
189 72 58 107 3345 860 16 57 40 6 162 23 10.5 129 133 54.0 39 Asia Sedan Auto 4
170 71 66 104 3800 860 31 56 41 5 173 18 10.1 132 143 51.0 39 Asia 4 Door SUV Auto 4
191 77 69 110 4610 1160 42 60 39 3 260 17 8.6 138 154 50.0 41 Asia 4 Door SUV Auto 6
187 70 57 112 3635 900 14 55 41 3 306 19 2.2 126 132 56.5 38 Asia Sedan Auto 5
193 71 59 114 3890 860 13 57 41 4 275 19 6.9 128 141 52.5 39 Asia Sedan Auto 5
192 72 56 115 3880 905 14 55 41 4 294 19 6.3 129 142 51.5 40 Asia Sedan Auto 6
200 73 57 119 3860 880 17 58 42 4 294 19 7.1 133 143 52.0 41 Asia Sedan Auto 6
189 82 52 108 3890 705 10 56 43 4 300 19 7.0 128 138 53.5 38 Asia Coupe Auto 6
189 75 72 110 5245 1100 39 59 42 5 330 13 7.3 148 160 44.5 41 United States 4 Door SUV Auto 5
173 69 65 104 3380 925 27 54 42 7 172 22 10.1 143 163 53.0 38 United States 4 Door SUV CVT
186 73 67 109 4690 1050 33 59 42 2 235 14 8.8 142 159 47.5 40 United States 4 Door SUV Auto 5
174 69 64 104 3575 925 30 55 41 4 172 20 10.8 146 168 48.0 38 United States 4 Door SUV CVT
173 74 71 116 4550 850 35 56 41 6 205 15 10.7 150 172 46.0 43 United States 4 Door SUV Auto 4
197 73 59 110 3870 860 16 58 41 3 200 18 9.1 143 160 50.0 41 Asia Sedan Auto 5
186 71 58 107 3430 825 15 56 41 3 162 23 9.2 136 142 53.5 39 Asia Sedan Auto 5
167 67 58 98 2615 850 9 54 40 5 110 28 12.8 132 150 55.5 35 Asia Sedan Auto 4
179 72 65 106 3660 825 33 57 40 6 182 21 9.6 140 163 52.0 39 Asia Wagon Auto 5
202 78 69 119 4725 1155 65 63 40 5 244 17 9.0 141 152 50.5 43 Asia Minivan Auto 5
181 73 68 107 4310 880 32 59 40 5 192 15 9.5 144 155 48.0 39 Asia 4 Door SUV Auto 4
176 68 58 103 2875 850 12 55 41 5 138 28 9.5 144 153 50.0 37 Asia Sedan Man 5
170 71 66 104 3750 860 31 56 40 4 173 18 11.3 148 172 52.5 38 Asia 4 Door SUV Auto 4
191 75 74 114 5705 1475 52 60 41 6 300 13 9.1 134 145 47.5 39 United States 4 Door SUV Auto 6
191 72 57 109 3670 900 15 56 42 3 272 23 6.4 131 140 50.5 39 Asia Sedan Auto 6
190 72 57 112 3915 815 13 56 42 2 245 20 7.4 133 147 51.0 38 Asia Sedan Auto 6
188 74 73 110 4825 1225 40 58 42 4 235 15 8.0 135 136 49.0 41 Asia 4 Door SUV Auto 5
180 71 56 108 3510 825 13 54 42 2 204 24 7.7 131 134 55.5 35 Asia Sedan Auto 6
203 74 58 122 4515 825 18 57 42 4 380 21 6.2 140 153 48.5 40 Asia Sedan Auto 8
186 73 66 107 4235 925 33 58 41 3 270 19 7.3 130 141 50.5 40 Asia 4 Door SUV Auto 5
179 72 53 103 3870 645 8 53 41 3 288 21 6.5 127 144 53.0 38 Asia Coupe Auto 6
187 76 67 111 4620 910 37 60 41 3 265 16 8.2 149 162 49.0 41 United States 4 Door SUV Auto 6
191 72 57 107 3625 875 16 57 41 2 263 20 6.9 134 135 53.0 42 United States Sedan Auto 6
208 79 78 119 6245 1525 57 63 40 4 300 13 8.8 149 167 48.0 42 United States 4 Door SUV Auto 6
215 78 59 118 4415 1100 21 61 42 3 239 17 8.7 143 154 47.5 42 United States Sedan Auto 4
149 68 44 91 2000 550 4 44 38 4 190 29 4.6 117 132 57.0 37 Europe Coupe Man 6
184 74 65 108 4025 850 28 58 42 3 244 18 9.1 128 140 51.0 41 Asia 4 Door SUV Auto 6
200 76 68 113 4585 1190 38 58 41 3 263 16 3.2 150 161 48.5 40 Asia 4 Door SUV Auto 6
157 68 49 92 2510 340 5 53 40 2 170 27 6.7 121 138 57.5 33 Asia Coupe Man 6
174 70 53 106 3085 680 8 55 40 2 238 18 6.7 117 130 56.0 38 Asia Coupe Man 6
178 69 58 104 2830 850 11 55 42 6 148 30 8.6 132 140 52.5 36 Asia Sedan Man 5
182 69 64 108 3480 1020 39 55 41 5 157 23 10.3 142 154 50.5 37 Asia Wagon Auto 4
187 70 57 105 3355 850 15 56 42 3 160 23 9.6 130 145 53.5 41 Asia Sedan Auto 4
194 74 55 112 4060 915 16 56 44 4 302 18 6.1 126 133 52.5 38 Europe Sedan Auto 7
190 72 58 112 3845 1010 16 55 43 4 268 21 6.5 136 152 54.0 38 Europe Sedan Auto 7
200 76 72 121 5575 1210 46 57 42 6 335 15 7.4 136 154 47.0 42 Europe 4 Door SUV Auto 7
189 75 70 115 4845 1165 41 58 42 6 268 16 7.8 134 143 48.5 38 Europe 4 Door SUV Auto 7
205 73 58 125 4490 1135 16 57 44 4 382 17 6.0 141 154 51.5 40 Europe Sedan Auto 7
179 72 51 101 4235 570 10 53 43 2 382 17 5.3 126 132 54.0 36 Europe Coupe Auto 7
161 70 51 96 3315 525 10 51 43 4 268 21 6.2 118 130 55.0 34 Europe Coupe Man 6
212 78 57 115 4180 1100 21 61 41 6 239 16 8.0 140 151 50.0 42 United States Sedan Auto 4
191 72 56 107 3320 850 16 58 41 5 160 23 9.5 144 144 52.5 40 United States Sedan Auto 5
146 66 55 97 2690 815 6 49 42 4 172 30 7.2 137 154 57.5 37 Europe Coupe Man 6
180 72 54 101 3345 660 16 55 42 3 162 23 9.3 139 149 50.5 42 Asia Coupe Man 5
190 74 70 108 4195 970 40 59 42 5 215 17 8.2 137 147 48.5 41 Asia 4 Door SUV Auto 4
190 72 58 108 3430 825 13 57 42 5 160 23 9.1 139 148 50.5 43 Asia Sedan Auto 4
183 71 66 105 3925 1155 34 56 41 5 220 19 8.3 132 142 52.5 38 Asia 4 Door SUV Auto 6
169 72 52 104 3640 450 4 53 41 5 287 20 6.2 124 130 57.0 37 Asia Coupe Man 6
190 71 58 109 3215 900 16 55 42 5 175 25 8.1 134 142 51.5 39 Asia Sedan CVT
208 79 76 123 5715 1375 59 65 42 6 317 13 7.2 132 140 46.0 44 Asia 4 Door SUV Auto 5
191 73 58 109 3555 900 14 56 42 4 255 21 6.8 135 150 53.0 44 Asia Sedan CVT
189 74 67 111 4190 900 31 60 41 3 245 19 8.0 134 146 50.0 40 Asia 4 Door SUV CVT
188 73 70 112 4875 1125 48 58 38 3 270 15 8.0 143 172 46.5 43 Asia 4 Door SUV Auto 5
204 78 70 124 4550 1205 60 64 40 6 235 18 8.4 141 153 50.0 45 Asia Minivan Auto 5
180 71 60 106 3010 850 13 57 41 6 140 26 9.6 149 164 49.5 38 Asia Sedan CVT
169 67 60 102 2780 860 18 54 40 5 122 29 9.5 163 187 52.0 37 Asia Sedan Man 6
179 73 75 106 4480 920 46 58 41 4 261 17 7.7 135 158 50.0 40 Asia 4 Door SUV Auto 5
189 71 57 112 3540 890 14 55 42 4 169 22 9.4 145 156 51.0 42 United States Sedan Auto 4
198 72 56 111 3630 915 16 58 42 4 200 20 8.3 153 169 49.0 41 United States Sedan Auto 4
157 71 50 95 2925 355 4 52 42 4 177 23 7.2 133 148 56.5 36 United States Coupe Man 5
173 70 61 102 3000 850 24 53 40 6 126 27 10.7 144 150 50.5 38 United States Wagon Auto 4
176 71 52 93 3305 660 5 51 43 4 355 20 4.4 113 127 59.5 37 Europe Coupe Man 6
172 70 51 95 3015 420 9 51 41 5 240 22 6.5 112 123 57.5 37 Europe Coupe Man 5
182 68 57 105 3370 930 15 55 41 3 210 23 8.0 131 136 53.5 37 United States Sedan Auto 5
190 71 57 106 3545 930 16 56 41 3 260 21 7.2 128 139 56.0 40 United States Sedan Auto 5
190 70 58 112 3335 915 16 55 41 4 224 20 8.1 140 160 51.0 42 United States Sedan Auto 4
201 78 70 119 5015 1320 49 62 41 4 275 16 8.8 142 162 50.0 42 United States 4 Door SUV Auto 6
161 71 50 95 3065 425 4 52 41 2 260 24 6.2 136 156 56.5 37 United States Coupe Man 5
180 73 67 107 3915 915 28 55 40 6 257 17 8.2 145 162 49.0 42 United States 4 Door SUV Auto 6
174 69 56 106 2890 865 13 54 41 2 160 26 8.8 136 147 51.0 37 Asia Coupe Man 5
167 69 64 102 3120 850 34 56 41 6 158 23 9.4 137 148 53.0 37 Asia Wagon Auto 4
177 68 65 99 3260 900 32 53 42 6 173 22 10.0 135 142 50.0 38 Asia 4 Door SUV Auto 4
186 68 56 105 3540 850 11 54 41 3 250 18 3.1 140 151 51.5 38 Asia Sedan Auto 5
189 70 63 105 3545 900 31 52 41 3 168 21 11.8 141 158 49.0 38 Asia Wagon Auto 4
192 74 66 108 4280 1155 36 58 42 4 256 16 8.6 139 162 49.0 40 Asia 4 Door SUV Auto 5
177 68 57 102 2840 875 12 55 42 5 126 27 9.5 147 157 49.5 36 Asia 4 Door Hatchback Man 5
177 71 67 104 3650 905 25 56 42 5 185 18 9.5 138 147 52.0 38 Asia 4 Door SUV Auto 5
163 69 63 98 2995 815 16 53 40 4 143 22 12.2 137 150 53.5 37 Asia 4 Door Hatchback Auto 4
197 72 69 112 4190 1190 37 56 41 6 252 17 7.7 137 147 51.5 44 Asia 4 Door SUV Auto 5
189 74 72 110 4345 1035 45 58 41 3 239 16 8.2 132 146 46.5 40 Asia 4 Door SUV Auto 4
197 73 59 111 3600 875 14 59 41 3 280 22 6.7 139 155 48.0 41 Asia Sedan Auto 5
189 72 58 109 3280 900 15 57 42 5 158 24 9.6 139 151 49.5 38 Asia Sedan Auto 5
193 72 56 107 3620 755 14 56 41 5 225 21 7.5 130 138 50.5 39 Asia Coupe Auto 5
178 67 58 102 2595 860 14 52 40 5 130 29 9.8 140 151 52.0 38 Asia Sedan Auto 4
184 75 72 106 4350 1190 34 59 40 5 239 17 8.0 138 157 45.5 44 Asia 4 Door SUV Auto 5
188 75 69 110 4490 1200 38 60 42 4 270 18 8.0 139 151 49.0 42 Asia 4 Door SUV Auto 5
175 68 58 106 2950 825 16 55 41 4 110 44 10.5 143 152 50.5 37 Asia 4 Door Hatchback CVT
181 72 66 105 3485 825 39 57 40 6 166 23 9.8 132 139 51.5 37 Asia 4 Door SUV Auto 4
201 77 69 119 4550 1050 71 64 41 4 266 18 7.7 138 147 50.0 39 Asia Minivan Auto 5
151 67 60 97 2410 845 9 51 40 4 106 34 9.3 163 186 51.5 34 Asia Sedan Man 5
166 69 58 102 3155 960 15 54 42 5 200 25 6.7 134 141 57.0 36 Europe 4 Door Hatchback Man 6
179 69 58 102 3330 970 16 55 42 4 150 24 9.4 140 146 55.0 36 Europe Sedan Auto 6
188 72 58 107 3465 975 14 55 43 4 200 24 7.7 135 145 52.5 38 Europe Wagon Auto 6
176 70 57 104 3245 950 14 55 42 3 168 23 9.4 135 148 52.0 37 United States Sedan Auto 5
180 71 56 107 3465 890 14 56 42 4 208 22 7.9 140 145 50.5 42 United States Sedan Auto 5
191 73 59 112 3850 905 15 57 41 4 235 20 8.6 139 158 50.5 39 United States Sedan Auto 6
178 70 57 104 3555 800 28 55 41 3 218 20 8.5 139 153 51.0 36 United States Wagon Auto 5
189 75 70 113 4950 1210 38 58 41 4 311 16 7.6 136 138 52.5 42 United States 4 Door SUV Auto 6