Submit your assignment in the form of a read only Excel spreadsheet. To save your spreadsheet as read-only, do the following:

Go to File>Save As

In the dialog box that opens, select the "read only" option. Do not enter a password.

You may need to change the name of the file if your file already has a name.

Please make sure to also add your explanations (if any) for each question either directly in the excel file as text, or in a separate word file.

Data for this assignment is in the spreadsheet that you can find with theRitz-Carlton case in the HBS coursepack. For an example of the analysis to be performed, please refer to the solved example.

All the following questions pertain to the Room Cleaning defect shown in the "Summary Counts" tab.

1.Verify from the given data that room cleaning is in statistical control. Identify the type of chart you selected and show your calculations for control limits. Analyze if observations are in control or out of control. Are there any weekly patterns that stand-out from your analysis? (4 points)

2.Consider the room cleaning defects on different days of the week. Are Sundays statistically different from other days of the week? (3 points)

3.Consider the Sunday data for room cleaning, is the process in statistical control on Sundays? If no, suggest at least three reasons that you think may be responsible for problems on Sunday. (3 points)

Excel can be provided with data once I hear from a tutor. I cannot attach Excel to this.