##### 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*