How do I set up 7a?

Q Thu Apr 29 8:08 PM Excel File Edit View Insert Format Tools Data Window Help Q AutoSave OFF A A E Y C ... Unit3ProblemsSet(Spring 2021) (1) Share Comments Home Insert Draw Page Layout Formulas Data Review View Tell me Ap. Ov Arial A ab Wrap Text v General J v ~ % " Conditional Format Cell Insert Delete Format Sort & Find & Analyze Styles Filter Select Paste BIUV Merge & Center v Data Formatting as Table M167 X V fx M N G H A B E OCT 159 7. An educational study in 2020 found that the average score on a normalized achievement exam given nationally to fifth grade students was 38.6. 160 A state school board, after implementing new curriculum, believes the average score is significantly higher for the fifth grade students in their 161 state, possibly due to this new curriculum. In an effort to statistically establish this claim, the state board randomly samples forty fifth graders 162 examining their scores on the achievement exam. The scores appear below. Is there sufficient evidence at the 0.10 level to substantiate the 163 state school board's claims? 164 45 165 47 35 37 49 41 41 36 37 166 22 55 41 38 40 40 41 50 32 29 53 52 167 51 30 43 33 46 44 49 41 36 168 40 43 22 32 48 38 35 30 43 53 169 170 172 a. Give the null and alternative hypotheses for this test. 173 Ho: 174 H1: b. Determine the value of the test statistic. 180 181 c. Determine the appropriate critical value(s). 182 183 184 185 d Determine the P-value. 186 187 188 189 e. Based upon your work above, should you "Reject the null hypothesis" or "Fail to reject the null hypothesis?" Explain why. 190 191 Unit 3 Problems Set Templates + + 125% Ready 29 w X