Question 2

Suppose that before the sample in question 1 was taken, the manager asked you to determine the sample size required to be 95% confident of the final estimation result within a margin of error of 0.035 ounces.You assume the standard deviation of the filling machine is 0.20 based on the manufactures specifications.Based on the information above, determine the best sample size of cans to take to estimate the true mean fill level.Place your answers for Question 2 in the worksheet named Nagel 1.

a.2 Points: Calculate the appropriate value of Z in cell F26 using a built-in Excel function based off of 95% confidence.

b.2 Points: Input the assumed standard deviation in cell F27.

c.2 Points: Input the maximum allowed margin of error (MOE) in cell F28.

d.4 Points: Calculate the necessary sample size (n) in cell F29 by writing a formula that references the appropriate cells.

Can # Ounces

1 12.74

2 12.5445

3 12.8489

4 13.0553

5 13.0397

6 13.1466

7 12.3633

8 12.7532

9 13.019

10 12.5827

11 12.662

12 12.4619

13 12.4306

14 12.6045

15 12.6453

16 12.3764

17 12.6864

18 12.7192

19 12.827

20 12.7269

21 12.7346

22 12.726

23 13.0685

24 12.7829

25 12.7628

26 12.6974

27 13.1944

28 12.9731

29 13.2751

30 12.669

31 13.1323

32 12.4775

33 12.9078

34 12.9804

35 13.1838

36 12.7831

37 12.6952

38 12.935

39 12.7237

40 12.9515

41 12.5112

42 12.6306

43 12.4957

44 12.7274

45 12.7935

46 12.8056

47 12.7355

48 13.2389

49 12.4515

50 12.6527

51 12.2845

52 13.0895

53 12.544

54 12.6693

55 12.9515

56 12.8933

57 12.9749

58 12.9191

59 12.5256

60 12.5769

61 12.9388

62 12.8645

63 12.612

64 12.7518

65 12.8263

66 12.9116

67 12.8277

68 12.6178

69 13.177

70 12.8974

71 12.8144

72 12.966

73 12.9724

74 12.6727

75 12.6154

76 13.0222

77 12.5598

78 12.4882

79 12.9423

80 12.9277

81 13.2411

82 13.0888

83 13.0608

84 12.8226

85 12.8004

86 12.8907

87 12.7949

88 12.5891

89 12.445

90 12.9657

91 12.8888

92 12.9236

93 12.8427

94 12.5946

95 13.0476

96 12.7378

97 12.632

98 12.6358

99 12.7142

100 12.7093

Sample Size Inputs

Z =

s =

E =

n =

n =

Please show the excel formulas you used. Its the only way i can review and learn to do it on my own.

Thank!