Managing for Quality and Performance Excellence 9th Edition by James Evans,William Lindsay

Exercise 48

Note: Data sets for many problems in this chapter are available in the Excel workbook C09Data.xlsx on the Student Companion Site. Click the appropriate worksheet tab as noted in the problem ( e.g. Prob. 9-12, etc.) to access the data. We also recommend using the ASQ Learn about Quality Excel templates noted in this chapter to facilitate your solutions to appropriate problems.
The Cabo Fiesta Mexican Restaurant is trying to determine whether sales of its popular Pan Con Mucho Sabor breadsticks are correlated with the sales of margaritas. It has data on sales of bread-stick baskets and margaritas for 25 weeks, shown in the worksheet Prob. 9-20. Plot a scatter diagram and compute the correlation using Excel tools. What do your results indicate?