Grading Rubric for Case Study Assignments Criteria Good 20 Fair 15 Unacceptable 0 Score Substance 25% of grade Answers are meaningful and reflect insight and careful analysis of the issues posed; contains rich and fully developed ideas which are extremely well written and presented. Answers are meaningful and reflect insight and analysis of the issues posed; contains fully developed ideas which are well written and presented. Answers are vague and reflect sloppy analysis of the issues posed; needs further development. Answers lack any worthwhile analysis. Results & Predictions 25% of grade Mathematical results are correct and clearly stated and explained. Intelligent predictions are made with full support of the correct data results. Proper graphs used, which are accurate for given scenario. Neat and easy to read. Includes all applicable labels and characteristics of a good graph. Correct mathematical results are stated and partially explained. Predictions are made with some support of the correct data results. Some incorrect mathematical results. Predictions made with incorrect mathematical results of the data. No mathematical results are discussed. No intelligent predictions are made based on the data results. Proper graphs used, which are accurate for given scenario. Neat and easy to read. Some omitted applicable labels and characteristic of a good graph. Improper graph used for given scenario; omitted labels and characteristic of a good graph. No appropriate graphs used. Writing 25% of grade The usage of grammar, sentence structure, and spelling, are excellent. Citations (if any) are properly cited using proper APA formatting. The usage of grammar, sentence structure and spelling contain minimal errors. Citations (if any) are properly cited using proper APA formatting. Prose and grammar need significant revisions. Grammar, sentence structure, spelling and citations (if any) are unacceptable. Total The usage of grammar, sentence structure, and spelling are improper and needs some revision. Improper citation (if any) formatting. Graphs 25% of grade Excellent 25 University Boston College Brandeis University Brown University California Institute of Technology Carnegie 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 Northwestern 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 State Graduation Rate 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 TN NC MO CT 87 77 91 87 77 74 90 91 93 93 93 82 92 95 89 79 94 74 90 81 95 90 91 86 72 85 73 76 80 81 70 83 67 79 83 84 96 88 77 70 67 93 72 75 82 82 86 95 % of Classes Under 20 37 69 58 64 68 50 47 70 71 62 66 66 53 71 66 56 67 65 64 31 67 64 67 69 57 60 32 40 42 48 47 64 30 29 49 41 53 65 65 51 39 45 37 35 70 61 74 76 Student-Faculty Alumni Ratio Giving Rate 13 8 8 3 10 8 12 7 13 10 8 7 10 8 9 11 6 13 8 19 5 8 7 9 12 17 19 20 18 19 20 4 23 15 15 16 13 7 10 13 21 13 12 13 9 11 7 7 25 35 39 46 26 29 25 29 35 54 44 36 27 45 29 39 46 14 29 22 69 42 32 30 17 16 6 10 11 10 13 38 20 21 15 28 47 40 24 22 12 27 12 11 30 40 33 48 A lumni G iving 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 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 following partial table shows a portion of the data for 48 US universities in the file \"Ch4 AlumniGiving\". 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. 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. 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