Question: please answer this question and not just repost another one with different numbers!! Thank you! Excel Online Structured Activity: Statistical Control Stanley's Dell Twenty customers
please answer this question and not just repost another one with different numbers!! Thank you!
Excel Online Structured Activity: Statistical Control Stanley's Dell Twenty customers per hour were asked by the cashiernt Stanley's Deli if they liked the meal, and the fraction that said "no" are shown below, for a twelve-hour period. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. X . Open spreadsheet Questions a. Find P. Round your answer to three decimal places b. Find op. Do not round intermediate calculations. Round your answer to three decimal places, Find the 3-sigma LCL and UCL. Do not round intermediate calculations. If your answer is zero, entero" Round your answers to three decimal places. LOlp Up d. Choose the correct graph for the P chart, The correct graph is C D E F B Statistical Control - Stanley's Deli Sample size Number of samples 20 12 con AWN Average (p-bar) Standard Deviation LCLP UCLP Fraction Defective Standard Deviation LCLP Center UCLP 0.0 1 2 3 4 5 6 7 8 9 10 11 12 13 74 15 76 17 18 19 20 21 22 A Hour 1 2 3 4 5 6 7 8 9 10 11 12 0.4 0.4 0.1 0.1 0.3 0.3 0.3 0.0 0.3 0.4 0.2

Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
