please use the chart to answer the questions .

State MA MA RI CA PA OH VA NY NY NH NC GA Student Faculty Ratio 13 8 8 3 10 8 12 7 13 10 8 7 10 8 9 11 6 13 = DC University Boston College Brandeis University Brown University California Institute of Technology Camegie Mellon University Case Western Reserve Univ. College of William and Mary Columbia University Cornell University Dartmouth College Duke University Emory University Georgetown University Harvard University Johns Hopkins University Lehigh University Massachusetts Inst. of Technology New York University Northwestem University Pennsylvania State Univ. Princeton University Rice University Stanford University Tufts University Tulane University U. of California-Berkeley U. of California Davis U. of California-Irvine U. of California-Los Angeles U. of California-San Diego U. of California-Santa Barbara U. of Chicago U. of Florida U. of Illinois-Urbana Champaign U. of Michigan-Ann Arbor U of North Carolina Chapel Hill U. of Notre Dame U. of Pennsylvania U. of Rochester U. of Southern California U. of Texas Austin U. of Virginia U. of Washington U. of Wisconsin-Madison Vanderbilt University Wake Forest University Washington University St. Louis Yale University 19 Alumni Giving Rate 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 Graduation Rate 85 79 93 85 75 72 89 90 91 94 92 84 91 97 89 81 92 72 90 80 95 92 92 87 72 83 74 74 78 80 70 84 67 77 83 82 94 90 76 70 66 92 70 73 82 82 86 94 % of Classes Under 20 39 68 60 65 67 52 45 69 72 61 68 65 54 73 64 55 65 63 66 32 68 62 69 67 56 58 32 42 41 48 45 65 31 29 SI 40 53 65 63 53 39 44 37 37 68 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 12 17 SUBURBUS 3826 SESUESES 20 18 13 20 23 ~ ~ = e 5 & # == 0 9 0 2 0 0 IS 16 13 12 36 19 23 13 26 49 41 23 22 13 28 12 13 31 38 33 SO 10 13 21 13 12 13 VA WA WI TN NC MO 59 73 77 Alumni donations are an important source of revenue for colleges and universities. If administrators could determine the factors that could lead to increases in the percentage of alumni who make a donation, they might be able to implement policies that could lead to increased revenues. Research shows that students who are more satisfied with their con-tact with teachers are more likely to graduate. As a result, one might suspect that smaller class sizes and lower student/faculty ratios might lead to a higher percentage of satisfied graduates, which in turn might lead to increases in the percentage of alumni who make a donation. The following table shows data for 48 national universities. The Graduation Rate column is the percentage of students who initially enrolled at the university and graduated. The % of Classes Under 20 column shows the percentages of classes with fewer than 20 students that are offered. The Student/Faculty Ratio column is the number of students enrolled divided by the total number of faculty. Finally, the Alumni Giving Rate column is the percentage of alumni who made a donation to the university. Submissions should include the excel file with the data runs and the managerial report. Please use the following when presenting your report. The Data Set should be located on this week called "AlumniGiving" Managerial Report 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 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? 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