Instant Solution ? Click "Buy button" to Download the solution File
PLEASE ANSWER EACH PARTS OF THE QUESTIONS AND WITH DETAILED ANSWERS. THERE ARE TWO DIFFERENT FILES WITH TWO DIFFERENT ASSIGNMENTS. THEY ARE NOT RELATED TO EACH OTHER.?
In this spreadsheet solve for and enter the formula that will calculate sample sizes for tests of control.
The procedure is to be based on the normal approximation to the binomial distribution
is maximum tolerable deviation rate
is expected deviation rate (must be less than MTDR)
is one-tail deviate of the normal distribution for risk b
is risk of overreliance, a 1-sided risk
is implied precision of estimate [ pm - pe ]
is the sample size
the classic formula for calculating the precision of an estimate under the normal distribution
This also illustrates the use of the
Insert--> Equation feature of Ex
1. Solve the above formula for sample size. Enter it here.
[When you left click here,
an equation text box
2. Enter the formula in D30 and G30 to calculate sample size [n] for the indicated b, MTDR and ER
Use the formula you solved in part 1 to calculate the sample size and enter it in cells E36 and I36.
NORMAL APPROXIMATION TO THE BINOMIAL
If you compare these results with the sample sizes calculated by the Excel workbook "Attributes sample size",
you will see that the the results may be close, but not necessarliy not be the same
tests of control.
so illustrates the use of the
-> Equation feature of Excel
MTDR and ER
s E36 and I36.
To do this part properly, you will
need to use an appropriate Excel
function [in Formulas] to calculate zb ,
"Attributes sample size",
Paper#9210629 | Written in 27-Jul-2016Price : $17.85