Basic Marketing Research with Excel 3rd Edition by Alvin Burns,Ronald Bush

Exercise 17

Morton O'Dell is the owner of Mort's Diner, which is located in downtown Atlanta, Georgia. Mort's opened up about twelve months ago, and it has experienced success, but Mort is always worried about what food items to order as inventory on a weekly basis. Mort's daughter, Mary, is an engineering student at Georgia Tech, and she offers to help her father. She asks him to provide sales data for the past ten weeks in terms of pounds of food bought. With some difficulty, Mort comes up with the following list.
Mary uses these sales figures to construct scatter diagrams that illustrate the basic relationships among the various types of food items purchased at Mort's Diner over the past ten weeks. She tells her father that the diagrams provide some help in his weekly inventory ordering problem. Construct Mary's scatter diagrams with Excel to indicate what assistance they are to Mort. Perform the appropriate correlation analyses with the XL Data Analyst and interpret your findings.