View the step-by-step solution to:

Project: Deliverable : Student last name: IT Project 2015 XmR Chart Your last name here Upper control limit for the range: Upper control limit for

See attached - need assistance in completing XmR chart. Supporting detail is required.  Thanks!

Project: IT Project 2015 Deliverable : XmR Chart Student last name: Your last name here Upper control limit for the range: Type in UCL-R ROUND ALL RESULTS TO 6 DECIMAL PLACES. Upper control limit for the individuals: Type in UCL-x Lower control limit for the individuals: Type in LCL-x Is there adequate discrimination? Explain your answer: Which chart did you use and exactly how many strata are there on that chart? How many Type your answer here. Include which chart you used, how many strata there are If the process is unstable, what process would you follow to determine what is causing the instability? Type your answer here. Objective: Earlier, you have made some progress as a result of the stem-and-leaf diagram. The team changed the process so that first-time requesters were processed ahead of the otherwise (first-in-first-out) process. This dramatically decreased the overall average response times. Many of the problems submitted by newer users were easier to resolve than the problems submitted by the more seasoned workers. The team also learned how to improve the process through the use of designed experiments. There were other improvements made through the use of other Six Sigma tools and techniques (aside from your project deliverables) and now the wait times are acceptable. Now, you want to ensure that they are staying that way and you want to practice "prevention" versus "detection." Part of your CONTROL strategy is to employ the use of an on-going capability study to ensure 'the plates are still spinning'--so-to-speak. And, the next deliverable will do that, but prior to performing a capability study, one must make sure the process is in statistical control. This is good, because the team decided to use a control chart as part of the CONTROL phase anyhow, so this will work out fine. In fact, let's do one now…just to make sure we are in statistical control.
Background image of page 1
Data: Average resolution times (in contiguous hours) in order of occurrence 1 10 2 17 Control Chart in Excel 2003 3 29 4 39 Control Chart Excel 2007 5 55 6 64 Help 7 28 8 6 "Don't I need special software?" 9 5 10 3 11 39 12 46 13 35 14 30 15 6 16 32 17 33 18 11 19 20 20 13 21 9 22 14 23 12 24 30 25 56 26 62 27 73 28 54 29 10 30 9
Background image of page 2
Sign up to view the entire interaction

Top Answer

View the full answer
9118570 (Calculations).xlsx

A
B
C
D
E
F
G
H
1
2
Control Chart Factors Table
3
Subgroup size
D3
D4
A2
4
2
0 3.267 1.880
5
3
0 2.575 1.023
6
4
0 2.282 0.729
7
5
0 2.114 0.577
8
6
0 2.004 0.483
9
7 0.076 1.924 0.419
10
8 0.136...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online