Question: please answer 21 and 22 in excel and show steps for explanation. once correct and complete I will rate thumbs up. thank you. 21 z=

please answer 21 and 22 in excel and show steps for explanation. once correct and complete I will rate thumbs up. thank you.

21 z= Use the data below to calculate the control limits for an Xbar chart and R chart. (Manager's step in control chart preparation) There are 11 samples with 6 in each sample. 3 1 2 3 4 5 6 7 8 9 10 X1 9.20 9.18 9.23 9.20 9.20 9.18 9.23 9.20 9.20 9.20 X2 9.28 9.28 9.24 9.22 9.24 9.28 9.28 9.24 9.28 9.23 X3 9.20 9.19 9.23 9.21 9.20 9.23 9.21 9.20 9.23 9.20 X4 9.27 9.27 9.23 9.22 9.23 9.22 9.23 9.22 9.28 9.22 X5 9.20 9.28 9.28 9.20 9.18 9.20 9.28 9.18 X6 9.26 9.20 9.28 9.28 9.20 9.28 9.19 9.23 9.22 9.24 11 9.20 9.26 9.21 9.24 9.22 9.28 9.23 9.20 UCLX LCL = UCLR LCLR= 22 AFTER you created the control chart limits as shown above, the employees in the process took samples as specified. Remember, the employees always use the control limits they are given by management. Use the control limits from above. Create a Xbar chart and a R chart graph for the data points below by inserting rows and place the charts below the three data points shown. State your conclusions for each of the samples 12 13 14 9.24 9.23 9.28 X2 9.22 9.21 9.26 X3 9.24 9.20 9.23 X 9.28 9.23 9.27 X 9.28 9.21 9.29 9.24 9.20 9.29 Xb = R- CLX- UCL, LCL- CLR- UCLR LCLR

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

please answer 21 and 22 in excel and show steps for explanation. once correct and complete I will rate thumbs up. thank you. 21 z= Use the data below to calculate the control limits for an Xbar chart...

Can you please answer a and b? Can you please show me the solution step by step in excel sheet? Thank you. For this assignment, please use excel file group_assignment_1_portfolios.xls posted on...

Please answer the question FULLY with detailed and neat steps to solve, will rate thumbs up for the correct solution. PLEASE USE THE SOFTWARE/PROGRAM MINITAB (if needed, please use Excel, but prefer...

2. We want to create a one variable data table that will display values of Taxable Income (cell O3), versus Federal Tax (cell F18) and Average Tax Rate (cell F19). Begin by filling in the range of...

please, help me with my financial mathematics on excel questions a to d Enkel Beleggings / Single Investments Probleem 5/ Problem 5 Bereken die kumulatiewe eindbedrag aan die einde van 5 jaar vir: /...

please answer 26-28 in excel with steps for explanation. once correct and complete I will rate with thumbs up. thanks! SCENARIO A team playing the Customer Responsiveness simulation by Littlefield...

Please show all your work. This is my last chance to post a question. Please help me. Thank you so much in advance. I'll give you an upvote. 2 Instructions: 3 4 1) Complete the requirements shown...

*To ensure I did this correctly, please answer the following questions along with filling in the table showing all work with a detailed explanation (: Thank you in advance Option #1: Cost Duration...

PLEASE Include Formulas for each box with the same numbers as the question. Thank you in advance! Sullivan Ranch Corporation has purchased a new tractor and has provided you with the information...

Ms. Marcia Brady lives and works in Prince Edward Island. She owns and operates a No Frills grocery store, which is an HST registrant. During the current year, her business has total revenue of...

1. What role does the doctrine of precedent play in this case? Which of the earlier cases discussed by this court are actually binding upon it? 2. Do you think that this outcome is fair, or do you...

Part 1 B Attempt 1 5 for 1 0 pts . Shareholders are and managers are in the shareholder - manager relationship. principals; agents principals; principals agents; principals agents; agents

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...