Question: 1) List values for L11-L14 2) Formulas are required in each of the ereen cells. Cell reference is required for all formulas. Please have 4
1) List values for L11-L14 2) Formulas are required in each of the ereen cells. Cell reference is required for all formulas. Please have 4 decimal places for all green cells 3) Please make the UCL and LCL black lines and the p-bar line a dash line. Remove gridlines 4) Add tick marks to vertical axis. Make the major units as 0.005. Add Y-axis title: Number of retests; X-title: Sampl 5) Make all dots orpange and size of 10 6) Change the data label of the out of control sample as "out of control" on top of the dot 2. 1) List values for L11-L14 2) Formulas are required in each of the green cells. Cell reference is required for all formulas. Please have 4 3. decimal places for all green cells 3) Please make the UCL and LC. black lines and the p-bar line a dash line. Remove gridlines 3. 4) Add tick marks to vertical axis. Make the major units as 0.005. Add Y-axis title: Number of retests; X-title: SampI 6. 5) Make all dots organge and size of 10 6) Change the data label of the out of control sample as "out of control" on top of the dot ( ) \begin{tabular}{|c|c|c|} \hline 3 & Sample & Numberofretests \\ \hline 10 & 1 & 4 \\ \hline i1 & 2 & 2 \\ \hline v & 3 & 3 \\ \hline D & 4 & 0 \\ \hline 4 & 5 & 2 \\ \hline 15 & 6 & 1 \\ \hline w & 7 & 4 \\ \hline 11 & 8 & 0 \\ \hline 10 & 9 & 2 \\ \hline 4 & 10 & 3 \\ \hline 20 & 11 & 4 \\ \hline 21 & 12 & 2 \\ \hline 22 & 13 & 8 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|} \hline Fractionofretests & p-bar & UCL & ICL \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline \end{tabular} 1) List values for L11-L14 2) Formulas are required in each of the ereen cells. Cell reference is required for all formulas. Please have 4 decimal places for all green cells 3) Please make the UCL and LCL black lines and the p-bar line a dash line. Remove gridlines 4) Add tick marks to vertical axis. Make the major units as 0.005. Add Y-axis title: Number of retests; X-title: Sampl 5) Make all dots orpange and size of 10 6) Change the data label of the out of control sample as "out of control" on top of the dot 2. 1) List values for L11-L14 2) Formulas are required in each of the green cells. Cell reference is required for all formulas. Please have 4 3. decimal places for all green cells 3) Please make the UCL and LC. black lines and the p-bar line a dash line. Remove gridlines 3. 4) Add tick marks to vertical axis. Make the major units as 0.005. Add Y-axis title: Number of retests; X-title: SampI 6. 5) Make all dots organge and size of 10 6) Change the data label of the out of control sample as "out of control" on top of the dot ( ) \begin{tabular}{|c|c|c|} \hline 3 & Sample & Numberofretests \\ \hline 10 & 1 & 4 \\ \hline i1 & 2 & 2 \\ \hline v & 3 & 3 \\ \hline D & 4 & 0 \\ \hline 4 & 5 & 2 \\ \hline 15 & 6 & 1 \\ \hline w & 7 & 4 \\ \hline 11 & 8 & 0 \\ \hline 10 & 9 & 2 \\ \hline 4 & 10 & 3 \\ \hline 20 & 11 & 4 \\ \hline 21 & 12 & 2 \\ \hline 22 & 13 & 8 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|} \hline Fractionofretests & p-bar & UCL & ICL \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
