- B Alumni Donations Are An Important Source Of Revenue For Colleges And Universities If Administrators Could Determine 1 (28.3 KiB) Viewed 22 times
- B Alumni Donations Are An Important Source Of Revenue For Colleges And Universities If Administrators Could Determine 2 (27.67 KiB) Viewed 22 times
- B Alumni Donations Are An Important Source Of Revenue For Colleges And Universities If Administrators Could Determine 3 (4.61 KiB) Viewed 22 times
- B Alumni Donations Are An Important Source Of Revenue For Colleges And Universities If Administrators Could Determine 4 (13.5 KiB) Viewed 22 times
- B Alumni Donations Are An Important Source Of Revenue For Colleges And Universities If Administrators Could Determine 5 (8.77 KiB) Viewed 22 times
FORMUALS. THANK YOU!
B. Alumni donations are an important source of revenue for colleges and universities. If administrators could determine the factors that influence 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 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 Alumni data file shows data for 48 national universities (America's Best Colleges, Year 2000 Edition). The column labeled % of Classes Under 20 shows the percentage of classes offered with fewer than 20 students. The column labeled Student/Faculty Ratio is the number of students enrolled divided by the total number of faculty. Finally, the column labeled Alumni Giving Rate is the percentage of alumni that made a donation to the university. Data file: Alum_Data appears on BB under Assignments.
1. Develop numerical and graphical summaries of the data. Use EXCEL. 2. Use regression analysis to develop an estimated regression equation that could be used to predict the alumni giving rate given the percentage of classes with fewer than 20 students. Plot the data with the regression line. Is a straight line appropriate for the data. Show all the steps. 3. Use regression analysis to develop an estimated regression equation that could be used to predict the alumni giving rate given the student-faculty ratio. Plot the data with the regression line. Is a straight line appropriate for the data. Show all the steps. 4. Which of the two estimated regression equations provides the best fit? For this estimated regression equation, perform an analysis of the residuals and discuss your findings and conclusions. 5. Use regression analysis to develop an estimated regression equation that could be used to predict the alumni giving rate given the two independent variables. Perform first an overall test, next an individual one if needed. 6. What conclusions and recommendations can you derive from your analysis?
This is Alumni Data % Classes refers to % of classes under 20 S/F Ratio refers to Student/Faculty Ratio Alum Giving refers to Alumni Giving Rate
B S/F Ratio 13 1 2 3 4 5 NM W COCO ON 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 A % Classes 39 68 60 65 67 52 45 69 72 61 68 65 54 73 64 55 65 63 66 3 10 8 12 7 13 10 8 7 10 8 9 9 11 6 13 8 19 5 8 8 7 9 12 17 19 20 с Alum Giving 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 32 DVOU 68 62 69 67 56 58 32 42
30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 41 48 45 65 31 29 51 40 53 65 63 53 39 44 37 37 68 59 73 77 18 19 20 4 23 15 15 16 13 7 10 13 21 13 12 13 9 11 7 7 7 13 8 12 36 19 23 13 26 49 41 23 22 13 28 12 13 31 38 33 50