please do it with every step and formulas not excel one

2. An investigator is interested in the effects of noise on the ability of subjects to concentrate. She assigns subjects randomly to one of three Noise conditions: low noise, moderate noise, and loud noise. She administers a test of concentration while the noise is present. She predicts that there will be an overall effect of noise on the ability to concentrate. Theory A suggests that people in the low noise condition will have higher scores on concentration than subjects in the moderate noise condition, but that no difference in concentration will be observed between subjects in the moderate and loud noise groups. Theory B suggests that subjects in the moderate noise condition will have higher concentration scores than subjects in loud noise condition, but that no difference in concentration will be observed between subjects in the low noise and moderate noise conditions. Please use SPSS to test the investigator's prediction of an overall effect of noise on the ability to concentrate and the comparisons that she should conduct to determine whether Theory A or Theory B is better supported by the data b. Please write a paragraph that presents the conclusions that the investigator is entitled to draw from the results of these tests. Also provide the ANOVA table for these results. a. Low Noise Moderate Noise Loud Noise 10 11 13 12 5 4 4 6 3 3 5 in 2. An investigator is interested in the effects of noise on the ability of subjects to concentrate. She assigns subjects randomly to one of three Noise conditions: low noise, moderate noise, and loud noise. She administers a test of concentration while the noise is present. She predicts that there will be an overall effect of noise on the ability to concentrate. Theory A suggests that people in the low noise condition will have higher scores on concentration than subjects in the moderate noise condition, but that no difference in concentration will be observed between subjects in the moderate and loud noise groups. Theory B suggests that subjects in the moderate noise condition will have higher concentration scores than subjects in loud noise condition, but that no difference in concentration will be observed between subjects in the low noise and moderate noise conditions. Please use SPSS to test the investigator's prediction of an overall effect of noise on the ability to concentrate and the comparisons that she should conduct to determine whether Theory A or Theory B is better supported by the data b. Please write a paragraph that presents the conclusions that the investigator is entitled to draw from the results of these tests. Also provide the ANOVA table for these results. a. Low Noise Moderate Noise Loud Noise 10 11 13 12 5 4 4 6 3 3 5 in