Student affairs departments at colleges provide programs andevents that offer students opportunities to learn outside oftraditional coursework. One popular avenue of engagement chosen bystudents is intramural sports. Does participation in intramuralsports improve freshmen academic indicators such as GPA andretention after the first year?

This Excel file Freshmen Intramurals has data on 745 intramuralparticipant/nonparticipant pairs of freshmen at a large midwesternuniversity. The student participant/nonparticipant pairs wereformed based on matching gender and high school GPA (to within0.25).

A claim frequently made by college academic advisors is thatfreshmen intramural participants have higher freshman-year GPA'sthan freshmen who do not participate in intramurals. Letμ_P be the mean freshmen year GPA of intramuralparticipants and μ_N be the mean freshmen year GPA ofintramural nonparticipants. Do these data support the claim thatfreshmen intramural participants have higher freshmen year meanGPA's than freshmen intramural nonparticipants? Perform theappropriate hypothesis test and answer the questions below(calculate the difference as participant freshmen year GPA -nonparticipant freshmen year GPA.

excel file-https://docs.google.com/spreadsheets/d/e/2PACX-1vS5eS0C7pu0kxQEOPYnJnrWThBOxuYztqXcdjp6xPL06Elf8r4OhwLsjPNk1xdads9Le3Xb2qsZroML/pubhtml?gid=0&single=true

copy the file into a browser

Question 1. What is the value of the teststatistic t? (use 2 decimal places in your answer)

Question 2. Select the correct choice below forthe P-value of this hypothesis test.

-0.005 < P-value < 0.01

-P-value > 0.10    

-0.05 < P-value < 0.10

-0.01 < P-value < 0.05

-0.001 < P-value < 0.005

-P-value < 0.0001

Question 3. What is an appropriate conclusionfor this hypothesis test? (1 submissionallowed)

-There is insufficient evidence to conclude that the meanfreshmen year GPA of intramural participants is greater than themean freshmen year GPA of intramural nonparticipant.

-There is sufficient evidence to conclude that the mean freshmenyear GPA of intramural participants is greater than the meanfreshmen year GPA of intramural nonparticipants.

-There is sufficient evidence to conclude that the mean freshmenyear GPA of intramural participants is less than the mean freshmenyear GPA of intramural nonparticipants.

Question 4. Estimate the mean difference(freshmen year intramural participant GPA - freshmen yearintramural nonparticipant GPA) in freshmen year GPA's with a95% confidence interval.

- lower bound of interval (use 4 decimal places)

- upper bound of interval (use 4 decimal places)