Question
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
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started