Scatterplots. In Exercises use the given paired data.

Coke Volume and Weight Refer to Data Set 19 in Appendix B, and use the volumes and weights of regular Coke. Does there appear to be a correlation between volume and weight? What else is notable about the arrangement of the points, and how can it be explained?

Solution 8BSC

Using excel, follow the steps below to obtain the scatter plot for the variables volumes and weights

1) Enter the data into Excel

2) Highlight both data columns and then click on the Insert tab

3) Choose "Scatter" and then choose the bottom option (Scatter with Straight Lines).

Scatter plot:

From the above scatter plot, it can be observed that as volume increases corresponding weight also increases, so there exist a positive correlation between these two variables, that is larger volumes tend to be more weight.