Construct a control -chart using the excel templates

Question

Construct a control -chart using the Excel templates available to you. Answer the following questions in your excel file and load it to Moodle.

1- What are the chart types you will use? Explain Why?

2- Is the average completion time for forms in this process in control? Why? Explain all reasons.

3- Is the variation in completion times in control? Why? Mention all your reasons. Explain all reasons.

4- Summarize the problems of this process and explain how we can fix these problems.

Attachment:- Chart.rar

Answer 1

By using the Microsoft excel paper, prepare a control -chart using the Excel templates available to you. Answer the given questions in your excel file. Question 1: Illustrate what are the chart types you will make use of Describe. Explain why? Question 2: Is the average completion time for forms in this procedure in control? Illustrate why? Describe all reasons. Question 3: Is the variation in completion times in control? Explain why? Cite all your reasons. Describe all reasons. Question 4: Sum up the problems of this process and describe how we can fix such problems.