Question

Please solve this problem in Excel and submit your Excel spreadsheet. The problem is as follows: The state of Virginia has implemented a Standard of Learning (SOL) test that all public school students must pass before they can graduate from high school. A passing grade is 75. Montgomery County High School administrators want to gauge how well their students might do on the SOL test, but they don't want to take the time to test the whole student population. Instead, they selected 20 students at random and gave them the test The results are as follows: 83 79 56 93 48 92 37 45 72 71 92 71 66 83 81 80 58 95 67 78 Assume that SOL test sco Compute the mean and standard deviation for these data. b. Determine the probability that a student at the high school will pass the test. How many percent of students will receive a score between 75 and 957 d. What score will put a student in the bottom 15% in SOL score among all students who take the test? res are normally distributed. a. c. e. What score will put a student in the top 2% in SOL score among all students who take the test?

Answer 1

sdluton frem tha gwen data meom Iuu7 K3 872.35 528u.55 26-6774 PPashP1s)- 1-P(z75) 20-1 1-P275-72.35 16.6774 =P(260.16) 1- 0.5636 0.u364 P(Betroeam =r(75 9)=P 75 995 75-72.3 Z2 9S-72-35 16.677u 16.677u =P(0.16 21-3 -P(26136)-92Ok 0.9131-05636 0.3495 dAt beton 15 Z= -1.036 -72.3.5 1036 16.677u 55.072 2 55 987. batom i Here the tep 2y meams 22.054 Them fa batom 98 / 1-72-35- 2.054 16.677u 106-60Su Hens the S82e 107