Question
You have been asked as an Accountant to assist with predicting the Graduation Rate based on the following: Class size, Faculty to Student ratio, and
You have been asked as an Accountant to assist with predicting the Graduation Rate based on the following: Class size, Faculty to Student ratio, and Alumni giving. (NOTE: You can cut and copy information below into Excel)
School | # of Class Sizes Under 30 | Student/Faculty Ratio | Alumni Giving Rate | Graduation Rate |
University 1 | 39 | 13 | 25 | 85 |
University 2 | 68 | 8 | 33 | 79 |
University 3 | 60 | 8 | 40 | 93 |
University 4 | 65 | 3 | 46 | 85 |
University 5 | 67 | 10 | 28 | 75 |
University 6 | 52 | 8 | 31 | 72 |
University 7 | 45 | 12 | 27 | 89 |
University 8 | 69 | 7 | 31 | 90 |
University 9 | 72 | 13 | 35 | 91 |
University 10 | 61 | 10 | 53 | 94 |
University 11 | 68 | 8 | 45 | 92 |
University 12 | 65 | 7 | 37 | 84 |
University 13 | 54 | 10 | 29 | 91 |
University 14 | 73 | 8 | 46 | 97 |
University 15 | 64 | 9 | 27 | 89 |
University 16 | 55 | 11 | 40 | 81 |
University 17 | 65 | 6 | 44 | 92 |
University 18 | 63 | 13 | 13 | 72 |
University 19 | 66 | 8 | 30 | 90 |
University 20 | 32 | 19 | 21 | 80 |
University 21 | 68 | 5 | 67 | 95 |
University 22 | 62 | 8 | 40 | 92 |
University 23 | 69 | 7 | 34 | 92 |
University 24 | 67 | 9 | 29 | 87 |
University 25 | 56 | 12 | 17 | 72 |
University 26 | 58 | 17 | 18 | 83 |
University 27 | 32 | 19 | 7 | 74 |
University 28 | 42 | 20 | 9 | 74 |
University 29 | 41 | 18 | 13 | 78 |
University 30 | 48 | 19 | 8 | 80 |
University 31 | 45 | 20 | 12 | 70 |
University 32 | 65 | 4 | 36 | 84 |
University 33 | 31 | 23 | 19 | 67 |
University 34 | 29 | 15 | 23 | 77 |
University 35 | 51 | 15 | 13 | 83 |
University 36 | 40 | 16 | 26 | 82 |
University 37 | 53 | 13 | 49 | 94 |
University 38 | 65 | 7 | 41 | 90 |
University 39 | 63 | 10 | 23 | 76 |
University 40 | 53 | 13 | 22 | 70 |
University 41 | 39 | 21 | 13 | 66 |
University 42 | 44 | 13 | 28 | 92 |
University 43 | 37 | 12 | 12 | 70 |
University 44 | 37 | 13 | 13 | 73 |
University 45 | 68 | 9 | 31 | 82 |
How would you rank each variables significance? Class Size Answer Class size is a significant variableClass size is NOT a significant variable Faculty Ratio Answer Faculty ratio is a significant variableFaculty ratio is NOT a significant variable Alumni Giving Answer Alumni giving is a significant variableAlumni giving is NOT a significant variable Based on the information presented, provide the function or regression equation: (Round answer to the second decimal place) y = Answer x constant Answer +- Answer x # of class size under 30 Answer +- Answer x Student/Faculty Ratio Answer +- Answer x Alumni Giving Rate (Round all numbers to the second decimal place)
Step 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