Description of this paper

Loading

PLEASE ANSWER EACH PARTS OF THE QUESTIONS AND WITH DETAILED-(Answered)

Description

Instant Solution ? Click "Buy button" to Download the solution File


Question

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

 

MTDR[pm]

 

ER [pe]

 

zb

 

b

 

A

 

n

 


 

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

 


 

AND

 

the classic formula for calculating the precision of an estimate under the normal distribution

 

?=?_? ?((?_?(1??_?))/?)

 


 

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

 

will open]

 


 

"Type

 

equation

 

here."

 


 

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.

 


 

a.

 

b

 

MTDR[pm]

 


 

5%

 


 

ER [pe]

 


 

0%

 


 

5%

 


 

n=

 


 

NORMAL APPROXIMATION TO THE BINOMIAL

 

b.

 

n

 

3%

 

formula

 


 

5%

 


 

n=

 


 

n

 

formula

 


 

2%

 


 

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 ,

 

NORM.S.INV(1-sided confidence)

 


 

"Attributes sample size",

 


 

 

Paper#9210629 | Written in 27-Jul-2016

Price : $19
SiteLock