Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Information Modeling And Relational Databases

Authors: Terry Halpin, Tony Morgan

2nd Edition

0123735688, 978-0123735683

More Books

Students also viewed these Databases questions