The Monterey Fiesta Mexican Restaurant is trying to determine if its popular Pan Con Mucho Sabor breadsticks are correlated with the sales of margaritas. It has data on sales of breadstick baskets and margaritas for 25 weeks, shown in the Ch05Data.xlsx file for Prob05-17 on the Student Companion Site. Use the correlation utility, along with a scatter diagram, in Microsoft Excel to analyze these data. What do they indicate?

 

Monterey Fiesta Mexican Restaurant
Raw Data
	Breadstick
Week	Orders	Margaritas
1	860	1330				Correlation Matrix
2	850	1350				Week	Orders	Margaritas
3	800	1290			Week	1
4	850	1350			Orders	0.0711	1
5	880	1360			Margaritas	-0.0629	0.96807	1
6	780	1250
7	815	1275		Sorted	Data
8	780	1250		Orders	Margaritas
9	750	1160		645	1020
10	710	1140		650	1000
11	740	1140		675	1080
12	675	1080		710	1140
13	720	1140		720	1140
14	730	1150		730	1150
15	645	1020		730	1200
16	650	1000		740	1140
17	730	1200		750	1160
18	870	1380		780	1250
19	890	1390		780	1250
20	910	1380		800	1250
21	940	1400		800	1290
22	830	1250		815	1245
23	840	1250		815	1275
24	815	1245		830	1250
25	800	1250		840	1250
				850	1350
				850	1350
				860	1330
				870	1380
				880	1360
				890	1390
				910	1380
				940	1400