Questions 1 , 2 and 3 by using Excel please explaining every step happened in Excel with its formula.

A B C D E F G I Alumni Giving 1 2 3 4 5 6 5 7 8 9 10 11 12 13 14 15 16 17 Alumni donations are an important source of revenue for colleges and universities. If admin- istrators 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 contact with teachers are more likely to graduate. As a result, one might suspect that smaller class sizes and lower stu- dent/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 offered with fewer than 20 students. 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. A B 10 Stat University Graduatio n Rate 13 31 64 20 Boston College 21 Brandeis 22 Brown 23 California 24 Carnegie Mellon 25 Case Western 26 College of 27 Columbia 28 Cornell 29 Dartmouth 30 Duke University Emory 32 Georgetown 33 Harvard 34 Johns Hopkins 35 Lehigh 36 Massachusetts 37 New York 38 Northwestern 39 Pennsylvania 40 Princeton 41 Rice University 42 Stanford 43 Tufts University 44 Tulane 45 U. of 46 U. of 47 U. of 48 U. of 49 U. of 50 U. of 51 U. of Chicago 52 U. of Florida 53 U. of 54 U. of 55 U. of North 56 U. of Notre 57 U. of 58 U. of Rochester 59 U. of Southern 60 U. of 61 U. of Virginia 62 U. of 63 U. of 64 Vanderbilt 65 Wake Forest 66 Washington 67 Yale University MA MA RI CA PA OH VA 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 IN NC MO 85 79 93 85 75 72 89 90 91 94 92 84 91 97 89 81 92 72 90 SO 95 92 92 87 72 83 74 74 78 80 70 84 67 77 83 82 94 6 or Student- Alumni Classes Under Faculty Giving 20 Ratio Rate 39 13 25 68 8 33 60 8 40 65 3 67 10 28 52 8 31 45 12 27 69 7 31 72 13 35 61 10 53 68 8 45 65 7 37 54 10 29 73 8 46 9 27 55 11 40 65 63 13 13 66 8 30 32 19 21 68 5 67 62 8 40 69 7 34 67 9 29 56 12 17 58 17 18 32 19 7 20 9 41 18 13 48 19 8 45 20 12 65 4 36 31 23 19 29 15 23 51 15 13 40 16 26 53 13 49 65 7 41 63 10 23 53 13 22 39 21 13 44 13 28 37 12 12 37 13 13 68 9 31 59 11 38 73 7 33 77 7 30 90 76 70 66 92 70 73 82 82 86 94 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 the Graduation Rate, % of Classes Under 20, and Student/ Faculty Ratio as independent variables. Discuss your findings