0 pt) The following data show the advertising expenditures ($ millions), shipments in millions

of barrels (bbls.), and brewing company for 5 major brands of beer.

Brand Advertising Expenditures Shipments in bbls. Brewing

($ millions) (millions) Company

________ ___________________ ________________ ____________

Bud Light 68.7 20.7 Anheuser-Busch

Budweiser 120.0 36.3 Anheuser-Busch Coors Light 76.6 13.2 Molson Coors

Miller Genuine Draft 21.5 5.6 Miller

Miller Lite 100.1 15.9 Miller

a. Using Excel, creating a pie chart illustrating the percent frequencies of the 3 different

brewing companies (Anheuser-Busch, Molson Coors, and Miller).

[Make sure to show the percent frequency distribution that you used to make the pie chart.]

b. Using Excel, develop a scatter diagram for the relationship between the advertising

expenditures and the shipments in bbls (with advertising expenditures on the horizontal axis).

c. Comment on the relationship between the two variables from part b.

d. Compute and interpret the sample covariance for the above data.

e. Compute and interpret the sample correlation coefficient for the above data.

For parts d and e, make sure to show all your work