Module 7 Individual Assignment

Instructions

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 the Ritz-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)

Citations and References

Your assignment will be checked for copyright infringements. Please make sure that if you borrow ideas from other authors, you give appropriate credit to their work. If you need information on how to cite a source appropriately, go to the citation resource in our University Library.

Submission

For each question, you must show your work and not just present the final answer or conclusion.

The maximum page limit is 4 pages (minimum 1.5 line spacing, 12 point font, 1-inch margins) including any tables or figures.

Deadline

According to iMBA policy, late submissions will not be accepted. You have three attempts for your assignment submission before the deadline, but only the last attempt will be graded. Please make sure you have attached the correct file before you submit your assignment.

*** I have excel file with data, not sure how to send it to you