9. Determine whether a batch is not in control because the batch average falls below the lower control limit. In cell R6, use an IF function to test whether the value of sample average in cell O6 is less than the value of lower control limit in cell P6. If the condition is true, display "Out of Control"; otherwise, display "In Control" in the cell. Extend the formula over the range R6:R55 to indicate which batches are falling below the lower control limit for the machinery. 10. Repeat Step 9 for cell S6 except test for the condition that sample average in cell 06 is greater than the value of the upper control limit in cell Q6. Extend the formula over the range $6:$55 to indicate which batches are operating above the upper control limit. 11. Add conditional formatting to the range R6:$55, displaying any cell containing the text "Out of Control" in a red font on a light red background. 12. In cell A58, write your conclusions indicating which of the 50 machines on the assembly line are not within the control parameters set by Liana and indicate in what ways those machines are failing. 13. Save the workbook, and then close it