View Zoom Add Category nsert Table Chart Text Shape Media Comment Collaborate Sheet1 #1 #2 #3 #4 #5 #6 Sheet CHANGES HAVE BEEN MADE TO THESE PROBLEMS. YOU CAN COPY AND PASTE FROM YOUR SPREADSHEETS Sheet Name YOU MAY HAVE TO CHANGE INPUTS IN ORANGE AND SOME FORMULAS IN GREY #1 Many biological measurements on the same species follow a Normal distribution quite closely. The weights of seeds of a variety of winged bean are approximately Normal with mean 545 milligrams (mg) and standard x1 x2 Background deviation 140 mg. mu mu Istdev stdev SE not needed yet SE Duplicate S b) Use Excel to answer the following questions. Type your answers into this box Z-value 4 =(x-mu)/SE Z-value Delete Sh What percent of seeds weigh between 300-400 mg? (use 2nd column for x2) prob lower prob 1-prob 1 upper tail 1-prob If we discard the heaviest 5% of all seeds, what is the highest weight among the remaining seeds (solve for x)? Z of heaviest 5% =NORM.S.INV() solve for x X-M , tn c) Type your answers into this box. n new input mu ame You take one SRS of 200 winged-bean seeds. What approximate range of individual weights stdev same x do you expect to see in your sample (consider the middle 99.7%)? SE = mu/sqrt(n) You look at many SRSs of size 200 from the population of winged-bean seeds. What for 99.7% approximate range of sample mean weights x_bar do you expect to see (consider the range of weights in sample middle 99.7%)? can you explain the difference in UL the range below? range of sample means m margin of error = Z*SE LL can you explain the difference in UL the range above