(a) Use Excel to make a scatter plot of these vehicle data, placing Weight on the X-axis and City MPG on the Y-axis, Add titles and modify the default colors, fonts, etc., as you judge appropriate to make the scatter plot effective. (b) Describe the relationship (if any) between X and Y. Weak? Strong? Negative? Positive? Linear? Nonlinear?
Weight and MPG for 20 Randomly Selected Vehicles | ||
Vehicle | City MPG | Weight (lbs.) |
Acura TSX | 23 | 3,320 |
BMW 3-Series | 19 | 3,390 |
Chevrolet Corvette | 19 | 3,255 |
Chevrolet Silverado 1500 | 14 | 4,935 |
Chrysler Pacifica | 17 | 4,660 |
Dodge Caravan | 18 | 4,210 |
Ford Focus | 26 | 2,760 |
Infiniti FX | 16 | 4,295 |
Jaguar XJ8 | 18 | 3,805 |
Lexus IS300 | 18 | 3,390 |
Lincoln Aviator | 13 | 5,000 |
Mazda 6 | 19 | 3,355 |
Land Rover Freelander | 17 | 3,640 |
Mercedes-Benz S-Class | 17 | 4,195 |
Nissan 350Z | 20 | 3,345 |
Nissan Xterra | 16 | 4,315 |
Pontiac Vibe | 28 | 2,805 |
Pontiac Grand Am | 25 | 3,095 |
Toyota Sienna | 19 | 4,120 |
Volvo C70 | 20 | 3,690 |
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.