Question: How do i set this up in Excel? Myatt Steak House begin{tabular}{l|l|l|l|l|l|l|} hline & & 2010 & 2011 & 2012 & 2013 & 2014

How do i set this up in Excel?How do i set this up in Excel? Myatt Steak House \begin{tabular}{l|l|l|l|l|l|l|}

Myatt Steak House \begin{tabular}{l|l|l|l|l|l|l|} \hline & & 2010 & 2011 & 2012 & 2013 & 2014 \\ \hline Order Accuracy & X1 & 86.0% & 86.0% & 89.0% & 90.0% & 95.0% \\ \hline Timeliness of Delivery & X2 & 84.0% & 82.0% & 86.0% & 93.0% & 95.0% \\ \hline Table Cleanliness & X3 & 4.8 & 4.8 & 5.1 & 5.6 & 5.8 \\ \hline Customer Satisfication & X4 & 93.4% & 93.2% & 94.2% & 95.3% & 96.7% \\ \hline Total \# Complaints & X5 & 492 & 467 & 431 & 326 & 310 \\ \hline Customer Referrals & X6 & 6 & 12 & 24 & 48 & 96 \\ \hline Gross profitseat & X7 & $9,000 & $8,000 & $11,000 & $13,000 & $13,250 \\ \hline Market Share & X8 & 8.00% & 8.10% & 8.20% & 8.50% & 8.59% \\ \hline Revenue per employee & X9 & $33,741.00 & $27,454.00 & $31,299.00 & $36,291.00 & $41,240.00 \\ \hline Menu Shortages & X10 & 0.05% & 0.04% & 0.03% & 0.03% & 0.01% \\ \hline Hourly Employee Turnover Rate & X11 & 108% & 93% & 95% & 86% & 84% \\ \hline Hourly Employee Satisfaction & X12 & 61 & 64 & 63 & 75 & 78 \\ \hline \end{tabular} Question: HOW DO I SET THIS UP IN EXCEL? THANK YOU The Excel file Myatt Steak House provides five years of data on key business results for a restaurant. Identify the leading and lagging measures, find the correlation matrix, and propose a cause-and-effect model using the strongest correlations

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!