(a) Use Excel to make a scatter plot of the data for bottled water sales for 10 weeks, placing Price on the X-axis and Units Sold 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:

Unit PriceUnits Sold 1.15 0.94 1.04 1.05 1.08 1.33 0.99 1.25 1.16 1.11 186 216 173 182 183 150 190 165 190 201