(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?

Transcribed Image Text:

Weight and MPG for 20 Randomly Selected VehiclesCityMPG City MPG 3 Chevrolet Silverado 1500 Chrysler Pacifica Land Rover Freelander Mercedes-Benz S-Class 5 Pontiac Grand Am Toyota Sienna