Many cities, towns, and college campuses use a rotary broom to sweep debris and snow from sidewalks. the pressure created by the broom is one measure of how effective the machine will be in removing debris. random samples of rotary brooms from four manufacturers were obtained, and the pressure of each broom was measured (in psi). the data is in the file excel homework 7- problem l do the samples give enough evidence to conclude that at least two population mean pressures are different? use a 0.05 create the output [2 points] download the data file from the blackboard page for the course make your header - enter your name and information into cells al to a5 (just as you did for the previous excel homework assignments) . from the menu select: data -» data analysis -> anova: single factor complete the necessary information in the dialog box. the "input range" should include the column names. position the output beneath the data (e. g. a16) o before printing make sure the output will fit on one page. from the menu select: view -> page break preview and drag the dashed page break so as to fit all the output onto one page note - when printing, if your excel spreadsheets look as though the content you typed has had extra spaces inserted, then see the comment on excel homework 1 * * questions - write your answers to the following directly on your output. be neat and label your answers (a) give the null and alternative hypotheses. [2 points] (b) find and circle the test statistic and the p-value for this test. [1 point (c) give the rejection region for the test. (be sure to describe a region; simply giving a number is not enough.) [1 point] (d) give the decision for the test. write a conclusion that relates your decision to the context of the problem. [2 points] (e) which manufacturer would you recommend? why? [2 points]