Utilizing the Mexican Restaurant Survey file attached, answer and perform the following questions and summarizations.

Before attempting the assignment, familiarize yourself with the survey questions listed as a worksheet. This will assist you in understanding the information better and why you are statistically analyzing the different question.

Within the excel file, use a different worksheet for each question and label each worksheet with the appropriate question number. With each question, fully interpret your results and explain what it all means.

Develop a regression analysis of Friendly Employees, Fun Place to Eat, Large Size Portions, Fresh Food, Reasonable Prices, Attractive Interior, Excellent Food Taste, Knowledgeable Employees, Proper Food Temperature, and Quick Service (variables X12 to X21) as independent variables with satisfaction as the dependent variable. Interpret the results.

Develop a regression analysis of Friendly Employees, Fun Place to Eat, Large Size Portions, Fresh Food, Reasonable Prices, Attractive Interior, Excellent Food Taste, Knowledgeable Employees, Proper Food Temperature, and Quick Service (variables X12 to X21) as independent variables with likely to Return as the dependent variable. Interpret the results.

Calculate the mean and the standard deviation for ALL customer's satisfaction. Calculate the mean and standard deviation for just Jose's Southwestern Café and just Santa Fe Grill. Is there a significant difference in the means between the two groups? Interpret the results.

Is there a significant difference of how attractive the interior of Santa Fe Grill between males and females? Interpret the results.

Is there a significant difference of likely to return to the restaurants by the different grouping of distance driven from home? Interpret the results.

Attachment:- mexican_restaurants_survey.rar