2018 SP331 CASE II - Compatibility Mode a s Q Search in Document AutoSave oFF Home Insert Design Layout References Mailings Review View Share Calibri Styles Pane Paste Normal No Spacing Heading1 Heading 2 Title 1. Use EXCEL or WORD documents ONLY 2. Use Excel or SPSS to solve these problems. Let Excel or SPSS do the calculations PROBLEM Alumni donations are an important source of revenue for colleees and universities,I administrators coukd 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 enroled divided by the total number of faculty. Finally, the column labeled Alurmni Giving Rate is the percentage of alumni that made a donation to the university. Data folder: Data Case lI (appears on BB under Assignments) PROBLEMS 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 lumni giving rate given the percentage of classes with fewer than 20 students. Plat the data with the regression line. Is a straight line appropriate for the data, Show all the steps next to the regression output. Use ?-0.01. Also, construct a 99% confidence interval for the slope of the regression line 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 next to the regression output. Use ? = 0.01. Also, construct a 99% confidence interval for the mean of Y Alumni Giving Rate for a student-faculty ratio of 12 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 alumnieiving rate even the two independent variables. Perform a global test and any additional test if necessary. Show all the steps next to the regression output. Use ? 0.01. 6. What conclusions and recommendations can you derive from your analysis? Page 1 of 1 451 words English (United States) + 100% 2018 SP331 CASE II - Compatibility Mode a s Q Search in Document AutoSave oFF Home Insert Design Layout References Mailings Review View Share Calibri Styles Pane Paste Normal No Spacing Heading1 Heading 2 Title 1. Use EXCEL or WORD documents ONLY 2. Use Excel or SPSS to solve these problems. Let Excel or SPSS do the calculations PROBLEM Alumni donations are an important source of revenue for colleees and universities,I administrators coukd 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 enroled divided by the total number of faculty. Finally, the column labeled Alurmni Giving Rate is the percentage of alumni that made a donation to the university. Data folder: Data Case lI (appears on BB under Assignments) PROBLEMS 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 lumni giving rate given the percentage of classes with fewer than 20 students. Plat the data with the regression line. Is a straight line appropriate for the data, Show all the steps next to the regression output. Use ?-0.01. Also, construct a 99% confidence interval for the slope of the regression line 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 next to the regression output. Use ? = 0.01. Also, construct a 99% confidence interval for the mean of Y Alumni Giving Rate for a student-faculty ratio of 12 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 alumnieiving rate even the two independent variables. Perform a global test and any additional test if necessary. Show all the steps next to the regression output. Use ? 0.01. 6. What conclusions and recommendations can you derive from your analysis? Page 1 of 1 451 words English (United States) + 100%