The Excel file Myatt Steak House provides five years of data on key business results for...

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.

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

Solutions

Expert Solution

Solution:

orchestra answered 1 year ago

Next > < Previous

Related Solutions

Consider the data in the Excel file Olympic Track and Field Results. The Olympic records in...

Consider the data in the Excel file Olympic Track and Field Results. The Olympic records in Discus Throw, High Jump and Long Jump all show a clear increasing trend. Can one be predicted from the others(s)? Run a regression analysis using Discus Throw as the dependent variable and High Jump as the independent variable. Interpret the key regression results. Dataset - https://easyupload.io/wc1oz2

the excel file cereal data provides a variety of nutritional information about 67 cereals and their...

the excel file cereal data provides a variety of nutritional information about 67 cereals and their shelf location. Use regression analysis to find the best model that explains the relationship between calories and the other variables. Investigat the model assumptions and clearly explain your conclusion. Keep in mind the principle of parsimony! DATA: Cereal Data Product Cereal Name Manufacturer Calories Sodium Fiber Carbs Sugars 1 100% Bran Nabisco 70 130 10 5 6 2 AlI-Bran Kellogg 70 260 9 7...

The Excel file Store and Regional Sales Database provides sales data for computers and peripherals showing...

The Excel file Store and Regional Sales Database provides sales data for computers and peripherals showing the store identification number, sales region, item number, item description, unit price, units sold, and month when the sales were made during the fourth quarter of last year.3 Modify the spreadsheet to calculate the total sales revenue for each of the eight stores as well as each of the three sales regions.

1\ The Excel file HATCO1 consists of data related to predicting the level of business (Usage...

1\ The Excel file HATCO1 consists of data related to predicting the level of business (Usage Level) obtained from a survey of purchasing managers of customers of an industrial supplier, HATCO. The following are the independent variables. • Delivery Speed—amount of time it takes to deliver the product once an order is confirmed. • Price Level—perceived level of price charged by product suppliers. • Price Flexibility—perceived willingness of HATCO representatives to negotiate price on all types of purchases. • Manufacturing...

The Exel file Accounting Professionals.xls provides the results of a survey of 27 employees in a...

The Exel file Accounting Professionals.xls provides the results of a survey of 27 employees in a tax division of a Fortune 100 company. Use PivotTables to find a cross tabulation of the following. Copy and Paste your results and write 1-2 sentences summarizing your findings. The number of employees of each gender who have or do not have a CPA The number of employees in each age group who have or do not have a CPA Employee Gender Years of...

how to export source data to excel file in python?

In the Excel data file, the tab labeled Question 1 contains data on the number of...

In the Excel data file, the tab labeled Question 1 contains data on the number of times boys and girls raise their hands in class. Conduct the t-test: Two-Sample Assuming Equal Variances. Males 9,8,4,9,3,8,10,8,9,10,7,6,12 Females 3,5,1,2,6,4,3,6,7,9,7,3,7,6,8,8 a. What is the null hypothesis? b. What is the research hypothesis? c. Why run a Two-Sample Assuming Equal Variances t-test? d. Interpret the findings. What are the results of the hypothesis test? Can you reject the null hypothesis?

You bought your house five years ago and you believe you will be in the house...

You bought your house five years ago and you believe you will be in the house only about five more years before it gets too small for your family. Your original home value when you bought it was $500,000, you paid 10 percent down, and you financed closing costs equal to 3 percent of the mortgage amount. The mortgage was a 25-year fixed- rate mortgage with a 5 percent annual interest rate. Rates on 30-year mortgages are now at 3...

The worksheet title “Table 1” in the Excel file “Dayton Software Inc Table 1” provides an...

The worksheet title “Table 1” in the Excel file “Dayton Software Inc Table 1” provides an overview of the market research data K2 generated. The table shows the four market segments, the anticipated size of each segment, and each segment’s willingness to pay for the two different versions of Integrated. It also includes projected costs of production and marketing. You can see the estimated production completion cost for each version, the variable cost per unit sold for each version and...

The data set for this question set (Tab Q1 in the Excel data file) comes from...

The data set for this question set (Tab Q1 in the Excel data file) comes from a research project that tracks the elderly residents in a community to monitor their cognitive function and general health. Based on the literature, education is considered a protective factor against dementia, and memory decline is usually the first sign of dementia. So the researchers would like to know whether education level (measured in number of years of formal schooling) is correlated with memory function...

Subjects