1. Use methods of descriptive statistics to summarize the data.

2. Develop an estimated simple linear regression model that can be used to predict the alumni giving rate, given the graduation rate. Discuss your findings.

3. Develop an estimated multiple linear regression model that could be used to predict the alumni giving rate using the Graduation Rate, % of Classes Under 20, and Student/Faculty Ratio as independent variables. Discuss your findings.

4. Based on the results in parts (2) and (3), do you believe another regression model may be more appropriate? Estimate this model, and discuss your results.

5. What conclusions and recommendations can you derive from your analysis? What universities are achieving a substantially higher alumni giving rate than would be expected, given their Graduation Rate, % of Classes Under 20, and Student/Faculty Ratio? What universities are achieving a substantially lower alumni giving rate than would be expected, given their Graduation Rate, % of Classes Under 20, and Student/Faculty Ratio? What other independent variables could be included in the model?

A B State MA MA RI CA PA OH 10 0 VA 11 University 1 2 Boston College 3 Brandeis University 4 Brown University 5 California Institute of Technology 6 Carnegie Mellon University 7 Case Western Reserve Univ. 8 College of William and Mary 9 Columbia University 10 Cornell University Dartmouth College 12 Duke University 13 Emory University 74 Georgetown University 15 Harvard University 46 Johns Hopkins University 77 Lehigh University 78 Massachusetts Inst. of Technology 19 New York University 20 Northwestern University 21 Pennsylvania State Univ. 22 Princeton University 23 Rice University 24 Stanford University 25 Tufts University 26 Tulane University 27 U. of California-Berkeley 28 U. of California-Davis 29 U. of California-Irvine 30 U. of California-Los Angeles 331 U. of California-San Diego 32 U. of California-Santa Barbara 33 U. of Chicago 34 U. of Florida 35 U. of Illinois-Urbana Champaign 36 U. of Michigan-Ann Arbor 37 U. of North Carolina-Chapel Hill 38 U. of Notre Dame 39 U. of Pennsylvania 40 U. of Rochester 41 U. of Southern California 42 U. of Texas-Austin 43 U. of Virginia 44 U. of Washington 45 U. of Wisconsin-Madison -46 Vanderbilt University 47 Wake Forest University 48 Washington University St. Louis 49 Yale University NY NY NH NC GA DC MA MD PA MA NY IL PA NJ TX CA MA LA CA CA CA CA CA CA IL FL IL MI NC IN PA NY CA TX VA WA WI TN NC MO CT D E Graduatio % of Classes Student- n Rate Under 20 Faculty Ratio 85 39 13 79 68 8 93 60 8 85 65 3 75 67 10 72 52 8 89 45 12 90 69 7 91 72 13 94 61 10 92 68 8 84 65 7 91 54 10 97 73 8 89 64 9 81 55 11 92 65 6 72 63 13 90 66 8 80 32 19 95 68 5 92 62 8 92 69 7 87 67 9 72 56 12 83 58 17 74 32 19 74 42 20 78 41 18 80 48 19 70 45 20 84 65 4 67 31 23 77 29 15 83 51 15 82 40 16 94 53 13 90 65 7 76 63 10 70 53 13 66 39 21 92 44 13 70 37 12 73 37 13 82 68 9 82 59 11 86 73 7 94 77 7 F Alumni Giving D 25 33 40 46 28 31 27 31 35 53 45 37 29 46 27 40 44 13 30 21 67 40 34 29 17 18 7 9 13 8 12 36 19 23 13 26 49 41 23 22 13 28 12 13 31 38 33 50 50