How do you write a formula in Excel to find the upper and lower limits for population sample for questiona? Questions C & D requires excel normal distribution formula how is this formula written to answer the questions? I have attached the spreadsheet and instructions.

Data - Excel Spreadsheet Instructions - Word Document

a. 6 points: The population of possible sample means is assumed normally distributed since the underlying sample values were normally distributed. Since this is the case, we can use the Empirical Rule to determine the lower and upper limit (interval) of expected sample means based on samples of size 100. That is, we can use the interval to predict the range of possible values of sample means when the process is working correctly. Use the Empirical Rule to determine the two values between which we expect to see almost all sample means (of size 100) when the process is working. You must write a formula that references the assumed parameters. When we say almost all, we mean 99.7% of data, which is contained between 3 SE of the population mean. Write the formula for the lower limit in cell E19, and for the upper limit in F19. See equation 7.2 on page 320 of our text for guidance. b. 2 points: Based on comparing the sample mean of the process with your answer to part c, does it appear that the process is working properly? Write the word Yes or No in cell E21. c. 5 points: The engineering specifications provide that a gasket should be between 395 mm and 405 mm, otherwise a gasket is defective. Assuming the process is working correctly; find the probability that a randomly selected gasket is not defective. Use Excel's built-in function for the Normal distribution to answer the question, and place the value in cell J2. d. 5 points: The engineering specifications provide that a gasket should be between 395 mm and 405 mm, otherwise a gasket is defective. Assuming the process is working correctly; find the probability that a randomly selected gasket is defective. Use Excel's built-in function for the Normal distribution to answer the question, and place the value in cell J4. Grade = 100 Question Worth Points Lost 1a 1b 1c 1d 1e 1f 1g 1h 2a 2b 2c 2d 2e 3a 3b 3c 3d 3e 3f Total 4 4 9 10 5 14 2 2 3 7 2 4 4 8 4 6 2 5 5 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Sample No 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 Sample OD Measures (mm) 381.77 383.89 387.71 386.00 387.81 386.03 386.44 383.43 390.24 388.30 383.23 389.59 386.12 387.89 390.96 390.23 385.84 386.27 390.03 384.83 384.81 387.32 388.56 389.12 385.77 385.15 386.18 387.83 386.29 387.07 384.40 385.98 383.81 386.84 386.34 386.03 388.62 385.04 391.78 384.62 383.99 385.73 391.24 384.20 390.14 387.48 Sample Statistics Mean OD = Std Dev OD = Max OD = Min OD = 3a Grader 386.73 2.15 391.78 381.77 Assumed Parameters Mean = 400 Std Dev = 2 Std Err = 3b 0.22 Grader Lower Upper 3c Limits Grader 3d Grader 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 386.08 386.41 383.75 385.66 385.82 384.70 389.59 388.68 386.30 387.37 388.32 388.70 386.74 390.78 388.73 385.66 383.71 388.54 384.89 384.57 386.16 388.70 390.01 387.59 389.29 384.05 386.64 386.82 387.72 389.46 386.65 387.44 386.34 391.75 386.93 387.69 388.12 384.86 387.80 388.96 385.73 385.09 384.15 386.50 382.47 388.52 384.98 384.44 385.33 96 97 98 99 100 383.83 387.63 385.30 385.08 384.74 Grader 3e Prob = 3f Prob =