DATA - https://uillinoisedu-my.sharepoint.com/:x:/g/personal/inw3_illinois_edu/ERxWrMcuInlKu7Xd7skB5-kBLqss6w2FljucqgqwgkiPIA?e=RPgr8P

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.