Question

2. Create a worksheet named "Stopwatch" and refer to your class notes and spreadsheets you constructed as part of independent work to properly create the calculator to the right a. Create an area into which at least fifty separate OBSERVATIONS 12.4 11.2 123 11.2 12.5 12.4 observations can be entered. And set up the rest of the structure shown. There will not be formulas in the observations area, but I needed the lines to make it clear Once at least two observations are entered (think IF and coUNT), use a formula to compute how many samples would be required to estimate the duration of the process to within 3% of the sample mean with a confidence of 93%, or any other reasonable user-provided values. The cell with the value for "n should be blank until the second value is entered. Create a cell for a user-entered performance rating and an allowance factor for the day. Enter initial values of .9 and 15% as shown. Add formulas to compute OT, NT, and ST as follows: i. 8 12.4 10 11.6 b. 12 13 Within 14|Confidenc" is 93% 16 n 17 18 PR 19 AF(day 20 0.9 21OT 22 NT c. 23 ST 12.09882 d. Assume that the mean of the required number of observations are the same as the mean of the samples shown ii. Compute normal time and standard time using the inputs above NOTES No other cells should be shown or referenced in your solution No errors should ever appear, even if there are no observations entered As a user enters observations or changes within, confidence, PR, or AF, relevant values should change. C D EF G H 3. Create a worksheet named "Work Sampling" and OBSERVATIONS refer to your class notes and spreadsheets you constructed as part of independent work to properly create the calculator to the right a. Create an area into which at least fifty separate 3 observations can be entered as either "T" for true or "F" for fale. And set up the rest of the structure shown. There will not be formulas in the observations area, but I needed the lines to make it clear Create cells to compute the number of observations with "F", the number with "T", the total number of cells with anything in them, and the estimated value of p-hat. Ensure that no matter how many observations are entered (including none), that no errors show Create a cell for a user-entered error and confidence level Compute the minimum number of observations necessary to achieve the given level of confidence within the given error limit. 10 b. 13 4 How Many F 15 How Many T 16 Total Values 17 P-HAT c. 19 Within 0 Confidence 21 22 n d.

Answer 1

2.

Formulae used:

For 'n'

=IF(COUNT(C3:H11)>=2,ROUNDUP((NORMSINV(1 - (1-B14)/2)*STDEV(C3:H11)/(B13*B21))^2,0),"")

For 'OT'

=IFERROR(AVERAGE(C3:H11),"")

For 'NT'

=IFERROR(B21*B18,"")

For 'ST'

=IFERROR(B22/(1-B19),"")