Answered step by step
Verified Expert Solution
Question
1 Approved Answer
ALUMNI GIVING, I ONLY NEED QUESTION #5 ANSWERED THANK YOU Business Statistics Project- Critical Assignment Alumni Giving Joseph Randal has just been named the director
ALUMNI GIVING, I ONLY NEED QUESTION #5 ANSWERED THANK YOU
Business Statistics Project- Critical Assignment Alumni Giving Joseph Randal has just been named the director of alumni relationships at a local university. 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 ration might lead to a higher percentage of satisfied graduates, which in turn might lead to increases in percentage of alumni who make a donation Joseph is feeling an extra pressure to increase total giving to the university because of recent budget cuts. Joseph is also feeling pressured to increase the percentage of alumni to give. Joseph found this new metric called average alumni giving rate U.S. News&World Report To investigate further, Joseph needs to assemble the data on classes, graduation rates, and most important, alumni giving rates for top 123 colleges and universities based on alumni giving The attached data base shows data of the top 123 colleges ranked by U.S. News&World Report. Questions to be answered in your report: 1. Use methods of descriptive statistics to summarize the data 2 Develop and 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, % of Classes Under 20, and Student/Faculty Ratio as independent variables. Discuss your findings Which of the 123 schools has the most (least) impressive giving rate? Discuss your findings 5. Consider a school that similar to Joseph's university. Joseph's university has 65% graduation rate and a student-faculty ration of 19:1, 3796 of the classes have fewer than 20 students, 23% of the classes have more than 50 students, and have a freshman retention rate of 80%. Should Joseph's university giving rate be greater or less than 8%? 6. What conclusions and recommendations can you derive from your analysis? Exhibit 3 ALUMNI GIVING One Variabie Summary Alumni Giving Duta Alumni Giving Data Alumni Giving Data Alumni Giving Data Alumni Giving Data Alumni Giving Duta Source: Created by the case writer using StatTools, a statistics toolkit from the Palisade Corporation. ALUMNI GIVING Alumni Giving Database GIVE 5 23 California State University- Fresno 28 Florida International University 37 Indiana University-Bloomington 46 Louisiana State University-Baton Rouge 49 University of Louisiana-Monroe 10% 52 Miami University-Oxford 60 University of Michigan-Ann Arbor 61 University of Minnesota Twin Cities 64 North Carolina State University-Raleigh 71 University of North Carolina-Chapel Hill 81 Pennsylvania State University-University Park 82 Purdue University- West Lafayette 84 Rutgers, the State University of New Jersey-New Brunswick 87 Southern Methodist University 96 Texas A&M University College Station 98 Texas State University San Marcos 106 University of California-Los Angeles 5 Data source: .S. News & World Report, 2010 survey data, http://premium usnews.com best colleges accessed May 22, 2012). Exhibit 1 ALUMNI GIVING Descriptions of Variables Variable Description An identifier running from 1 to 123 (schools are listed in alphabetical order Name of the school School Percentage of classes with fewer than 20 students Percentage of classes with greater than 50 students FRR reshman retention ratc Business Statistics Project- Critical Assignment Alumni Giving Joseph Randal has just been named the director of alumni relationships at a local university. 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 ration might lead to a higher percentage of satisfied graduates, which in turn might lead to increases in percentage of alumni who make a donation Joseph is feeling an extra pressure to increase total giving to the university because of recent budget cuts. Joseph is also feeling pressured to increase the percentage of alumni to give. Joseph found this new metric called average alumni giving rate U.S. News&World Report To investigate further, Joseph needs to assemble the data on classes, graduation rates, and most important, alumni giving rates for top 123 colleges and universities based on alumni giving The attached data base shows data of the top 123 colleges ranked by U.S. News&World Report. Questions to be answered in your report: 1. Use methods of descriptive statistics to summarize the data 2 Develop and 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, % of Classes Under 20, and Student/Faculty Ratio as independent variables. Discuss your findings Which of the 123 schools has the most (least) impressive giving rate? Discuss your findings 5. Consider a school that similar to Joseph's university. Joseph's university has 65% graduation rate and a student-faculty ration of 19:1, 3796 of the classes have fewer than 20 students, 23% of the classes have more than 50 students, and have a freshman retention rate of 80%. Should Joseph's university giving rate be greater or less than 8%? 6. What conclusions and recommendations can you derive from your analysis? Exhibit 3 ALUMNI GIVING One Variabie Summary Alumni Giving Duta Alumni Giving Data Alumni Giving Data Alumni Giving Data Alumni Giving Data Alumni Giving Duta Source: Created by the case writer using StatTools, a statistics toolkit from the Palisade Corporation. ALUMNI GIVING Alumni Giving Database GIVE 5 23 California State University- Fresno 28 Florida International University 37 Indiana University-Bloomington 46 Louisiana State University-Baton Rouge 49 University of Louisiana-Monroe 10% 52 Miami University-Oxford 60 University of Michigan-Ann Arbor 61 University of Minnesota Twin Cities 64 North Carolina State University-Raleigh 71 University of North Carolina-Chapel Hill 81 Pennsylvania State University-University Park 82 Purdue University- West Lafayette 84 Rutgers, the State University of New Jersey-New Brunswick 87 Southern Methodist University 96 Texas A&M University College Station 98 Texas State University San Marcos 106 University of California-Los Angeles 5 Data source: .S. News & World Report, 2010 survey data, http://premium usnews.com best colleges accessed May 22, 2012). Exhibit 1 ALUMNI GIVING Descriptions of Variables Variable Description An identifier running from 1 to 123 (schools are listed in alphabetical order Name of the school School Percentage of classes with fewer than 20 students Percentage of classes with greater than 50 students FRR reshman retention ratcStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started