Question
Do the following to complete a lookup table that you will use to calculate the lower and upper control limits for batch samples sizes of
Do the following to complete a lookup table that you will use to calculate the lower and upper control limits for batch samples sizes of 2 up to 25:
-
In cell W10, calculate the lower control limit by returning the value of cell V5 minus the value of cell V10 times cell V6. Use absolute references for cells V5 and V6 and a relative reference for cell V10. Check your formula by verifying that cell W10 shows the value 598.45.
-
In cell X10, calculate the upper control limit by returning the value of cell V5 plus the value of cell V10 times cell V6. Once again, use absolute references for cells V5 and V6 and a relative reference for cell V10. Check your formula by verify that cell X10 shows the value 651.61.
Note: I just need the formula to use in these scenarios.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Data Analytics With Sas Explore Your Data And Get Actionable Insights With The Power Of Sas
Authors: Nishant Sidana
1st Edition
9355515979, 978-9355515971
