Question
The provost at SWC, based on anecdotal evidence, is convinced that the student-faculty ratio (# of students divided by the number of faculty) is an
The provost at SWC, based on anecdotal evidence, is convinced that the student-faculty ratio (# of students divided by the number of faculty) is an important determinant of student success after graduation.The university president believes the overall prestige of the university is a bigger factor, and other administrators believe it is largely the academic quality of the students admitted that matters most.SWC has purchased some data that shows students' starting salaries along with various characteristics of the universities the students attended.The data set (found on the first tab of the provided spreadsheet, "Student Data") contains the following variables: the per semester cost of attendance, the region of the country in which the school is located, the total students enrolled, the number of faculty at the university, the average high school GPA of students admitted, the size of the school's library, and the school's national rank.Additionally, the university provost has compiled historical enrollment data from SWC, which can be found on the second tab in the provided spreadsheet ("Enrollment data").Specifically, the administrators want answers to the following questions:
What is the appropriate quantitative technique to determine how the variables are related?
Based on your analysis, how are students' starting salaries related to each of the explanatory variables in the data set?
Which variables are statistically important determinants of starting salaries?How did you arrive at this answer?
In your opinion, are any important variables missing from the data set?
Based on your analysis, what strategy or strategies would you recommend for improving the starting salaries of SWC graduates?
What techniques can SWC use to forecast enrollment for the next academic year?
Which forecasting method do you recommend using given the historical enrollment data provided?
In addition to the questions above, SWC has requested a data visualization component in the report.You are to use multiple diagrams and appropriately formatted charts following the principles.
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