regression memo

Sheet1

Assignment #11
You are preparing a report for your boss, Harriet Madison. Ms. Madison is the President of Centenary College.
For each NJ college and university the U.S. Department of Education publishes data which includes the median SAT sores for the freshman class and a school's 6 year graduation rate.
She has asked you to analyze whether the data indicates that requiring students to have higher SAT scores would increase the school's graduation rate.
She has asked you to analyze this data using regression analysis and write a memo
She would also like you to include an estimate of how much the graduation rate would increase if the median SAT score of the entering class was 20 points higher.
Combined median verbal and math SAT score	Graduation rate
1091	68%
1295	80%
1070	65%
1155	69%
975	50%
1280	74%
1025	53%
975	33%
1250	87%
1140	74%
1210	67%
1080	70%
1115	39%
1135	81%
1090	62%
1395	83%
1020	54%
940	32%
1200	62%
990	47%
1040	68%
1015	48%
935	61%
885	41%

The effects on SAT scores and graduation rates

1091 1295 1070 1155 975 1280 1025 975 1250 1140 1210 1080 1115 11 35 1090 1395 1020 940 1200 990 1040 1015 935 885 0.68 0.8 0.65 0.69 0.5 0.74 0.53 0.33 0.87 0.74 0.67 0.7 0.39 0.81 0.62 0.83 0.54 0.32 0.62 0.47 0.68 0.48 0.61 0.41

Combined median verbal and math SAT score

Graduation rate