(12 total points)Using the data in theFreshmen Dataworksheet in theBAN 530 - Week 11 - Homework #10 DATAworkbook, conduct statistical testing to determine the following:

a.(4 points)Do significant differences exist in the mean 1st-year retention rates for the different colleges across the university over the 4-year period? (You might need to conduct some data manipulation here.) Explain your methodology and results.

b.(4 points)Do significant differences exist in mean ACT scores among the different colleges? Explain your methodology and results.

c.(4 points)Do significant differences exist in mean SAT scores among the different colleges? Explain your methodology and results.

Link to data

https://docs.google.com/spreadsheets/d/1vsJWlPMQdVA5d_jOfCc0CnghpN8VatzbuqJYR2u_B3U/edit?usp=sharing