Question

identify the leading and lagging measures, find the correlation matrix, and purpose a cause and effect model using the strongest correlations

Myatt Steak House
		2010	2011	2012	2013	2014
Order Accuracy	X1	86.0%	86.0%	89.0%	90.0%	95.0%
Timeliness of Delivery	X2	84.0%	82.0%	86.0%	93.0%	95.0%
Table Cleanliness	X3	4.8	4.8	5.1	5.6	5.8
Customer Satisfication	X4	93.4%	93.2%	94.2%	95.3%	96.7%
Total # Complaints	X5	492	467	431	326	310
Customer Referrals	X6	6	12	24	48	96
Gross profit/seat	X7	$9,000	$8,000	$11,000	$13,000	$13,250
Market Share	X8	8.00%	8.10%	8.20%	8.50%	8.59%
Revenue per employee	X9	$33,741.00	$27,454.00	$31,299.00	$36,291.00	$41,240.00
Menu Shortages	X10	0.05%	0.04%	0.03%	0.03%	0.01%
Hourly Employee Turnover Rate	X11	108%	93%	95%	86%	84%
Hourly Employee Satisfaction	X12	61	64	63	75	78

Answer 1

please find the correlation matrix, it is done with the help of ms-excel

	X1	X2	X3	X4	X5	X6	X7	X8	X9	X10	X11	X12
X1	1
X2	0.912281	1
X3	0.935907	0.990521	1
X4	0.982279	0.971414	0.980136	1
X5	-0.89533	-0.97149	-0.99025	-0.9491	1
X6	0.98338	0.920316	0.94186	0.982419	-0.9136	1
X7	0.883737	0.968772	0.965383	0.932042	-0.94415	0.851263705	1
X8	0.914222	0.965276	0.989667	0.957917	-0.99789	0.93300822	0.932973	1
X9	0.860226	0.910702	0.862767	0.906226	-0.796	0.867086175	0.843208	0.793378	1
X10	-0.96539	-0.82784	-0.88588	-0.92298	0.867856	-0.94511206	-0.81665	-0.8949	-0.69939	1
X11	-0.75737	-0.7501	-0.82669	-0.77285	0.882512	-0.79286233	-0.72229	-0.89662	-0.45994	0.850668	1
X12	0.872415	0.947824	0.961327	0.933537	-0.97432	0.927305427	0.86534	0.976849	0.809539	-0.83331	-0.86842	1