Concept explainers
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 table shows data for 48 national universities. 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 with fewer than 20 students that are offered. 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?
1.
Summarize the data using the methods of descriptive statistics.
Answer to Problem 1C
The numerical summaries of the data are as follows:
Explanation of Solution
Calculation:
The data is related to the Alumni Giving Rate for 48 national universities.
Descriptive Statistics:
Step-by-step procedure to get the descriptive statistics using EXCEL software:
- Open an EXCEL sheet named as AlumnniGiving.
- Select Data > Data Analysis > Descriptive Statistics.
- Click OK.
- Under Input Range, enter $C$1:$F$49.
- Choose Grouped By as Columns.
- Select Labels in the first row.
- Select Summary statistics.
- Under Output Range, enter $J$1.
- Click OK.
Output obtained using EXCEL software is given below:
According to the output, it is found that mean, standard deviation, and median of the Graduate Rate are 83.042, 8.61, and 83.5, respectively.
The mean, standard deviation, and median of % of classes Under 20 are 55.73, 13.19, and 59.5, respectively.
The mean, standard deviation, and median for the Student–Faculty Ratio are 11.54, 4.85, and 10.5, respectively.
Step-by-step procedure to obtain the correlation coefficient using EXCEL software:
- Select Data > Data Analysis > Descriptive Statistics.
- Click OK.
- Under Input Range, enter $C$1:$F$49.
- Choose Grouped By as Columns.
- Select Labels in the first row.
- Click Ok.
Output obtained using the EXCEL software is given below:
On observing the output of the correlation, it is clear that the graduate rate is positively related with the % of class under 20 and the Alumni Giving Rate and the graduate rate are negatively related with the Student–Faculty Ratio. The % of classes Under 30 is negatively related with the Student–Faculty Ratio and the % of classes Under 20 is positively related with the Alumni Giving Ratio. Finally, the Student–Faculty Ratio is negatively related to the Alumni Giving Rate.
2.
Obtain the estimated simple linear regression model that can be used to predict the alumni-giving rate, given the graduation rate and provide comments about the findings.
Answer to Problem 1C
The estimated regression equation that could be used to predict t, the alumni-giving rateis
Explanation of Solution
Calculation:
In this situation, the Graduation rateis the independent variable
Regression of the Alumni-giving rate using the Graduation rate:
Step-by-step procedure to obtain the regression equation using EXCEL software:
- Select Data>Data Analysis>Regression.
- Click OK.
- Under Input Y Range, enter $F$1:$F$49.
- Under Input X Range, enter $C$1:$C$49.
- Click the box of Labels.
- Under New Worksheet.
- Click OK.
Output obtained using EXCEL software is given as follows:
Thus, the estimated regression equation that could be used to predict the alumni-giving rate, given the graduation rate is
From the output, the slope, b=1.18, which is positive. The positive value of slope depicts that the alumni giving rate is expected to increase or decrease by 1.18 percentage as the graduation rate increases or decreases by one.
R2 (R-squared):
The coefficient of determination (R2) is defined as the proportion of variation in the observed values of the response variable that is explained by the regression. The squared correlation gives the fraction of variability of the response variable (y) accounted for by the linear regression model.
From the output, R square=57.15%.
Thus, only 57.15% variability in the alumni-giving rateis explained by the variability in the graduation rate.
3.
Create an estimated multiple linear regression model that could be used to predict the alumni-given rate using the Graduation Rate, % of Classes Under 20, and Student/Faculty Ratio as independent variables and provide the comments about the findings.
Answer to Problem 1C
The estimated multiple linear regression model that could be used to predict the alumni-given rate using the Graduation Rate, % of Classes Under 20, and Student/Faculty Ratio as independent variables is
Explanation of Solution
Calculation:
In this given problem, the Graduation rate
Step-by-step procedure to obtain the estimated regression equation using EXCEL:
- In Data, select Data Analysis and choose Regression.
- In Input Y Range, select $F$1:$F$49.
- In Input X Range, select $C$1:$E$49.
- Select Labels.
- Click on Confidence Levels and type 95.
- Select the Residuals plot check box.
- Click OK.
Output obtained using EXCEL is given below:
Residual plot for Graduation Rate and % of Classes Under 20:
Thus, the estimated multiple linear regression model that could be used to predict the alumni-given rate using the Graduation Rate, % of Classes Under 20, and Student/Faculty Ratio as independent variables is
Graduation Rate:
From the output, the slope,
% of classes Under 20:
From the output, the slope,
Student–Faculty Ratio:
From the output, the slope,
R2 (R-squared):
From the output, R square=69.99%.
Thus, only 69.99% variability in the alumni-giving rate (response variable) is explained by the explanatory variables in the regression equation.
4.
State whether it is believed that another regression model may be more appropriate, if so, estimate the model and discuss the findings.
Answer to Problem 1C
The estimated multiple linear regression model that could be used to predict the alumni-given rate using the Graduation Rate and Student/Faculty Ratio as independent variables is
The second-order quadratic model is
Explanation of Solution
Calculation:
For Graduation rate:
Consider that
Null hypothesis:
That is, there is no significant relationship between the Alumni giving rate and graduation rate.
Alternative hypothesis:
That is, there is a significant relationship between the Alumni giving rate and graduation rate.
From the output in Part (3), it is found that the t-test statistic corresponding to comfort is 4.51 with p value of approximately 0.00005.
Level of significance:
The assumed level of significance is
Conclusion:
Here, the p value is less than the level of significance.
That is,
Thus, the decision is “reject the null hypothesis”.
Therefore, the data provide sufficient evidence to conclude that there is a significant relationship between the Alumni-giving rate and graduation rate at 0.05 level of significance.
For % of classes under 20:
Consider that
Null hypothesis:
That is, there is no significant relationship between the alumni-giving rate and % of classes under 20.
Alternative hypothesis:
That is, there is a significant relationship between the alumni-giving rate and % of classes under 20.
From the output in Part (a), it is found that the t-test statistic corresponding to % of classes under 20 is 0.2084 with p value of approximately 0.8358.
Conclusion:
Here, the p value is greater than the level of significance.
That is,
Thus, the decision is “fail to reject the null hypothesis”.
Therefore, the data do not provide sufficient evidence to conclude that there is a significant relationship between the alumni-giving rate and % of classes under 20 at 0.05 level of significance.
For Student–Faculty Ratio:
Consider that
Null hypothesis:
That is, there is no significant relationship between the alumni-giving rate and student faculty ratio.
Alternative hypothesis:
That is, there is a significant relationship between the alumni-giving rate and student faculty ratio.
From the output in Part (a), it is found that the t-test statistic corresponding to in-house dining is -3.082 with p value of approximately 0.0035.
Conclusion:
Here, the p value is less than the level of significance.
That is,
Thus, the decision is “reject the null hypothesis”.
Therefore, the data provide sufficient evidence to conclude that there is a significant relationship between the alumni-giving rate and student faculty ratio at 0.01 level of significance.
Now, by comparing the results based on the p-value, it is clear that “% of class under 20” in the regression model in not a good predictor.
In this situation, remove “% of class under 20” variable from the model and rerun the test by considering “Graduation rate” and “student faculty ratio” as the explanatory variable and the “alumni-giving rate” as the response variable.
The estimated regression model will be as given below:
In this given problem, the Graduation rate
Step-by-step procedure to obtain the estimated regression equation using EXCEL:
- In Data, select Data Analysis and choose Regression.
- In Input Y Range, select $F$1:$F$49.
- In Input X Range, select $D$1:$E$49.
- Select Labels.
- Click on Confidence Levels and type 95.
- Select the Residuals plot check box.
- Click OK.
Output obtained using EXCEL is given below:
Residual plot for the Graduation Rate and Student–Faculty Ratio:
Thus, the estimated multiple linear regression model that could be used to predict the alumni-given rate using the Graduation Rate and Student/Faculty Ratio as independent variables is
Graduation Rate:
From the output, the slope,
Student–Faculty Ratio:
From the output, the slope,
R2 (R-squared):
From the output, R square=69.96%.
Thus, only 69.96% variability in the alumni-giving rate (response variable) is explained by the explanatory variables in the regression equation.
Based on output, it is observed that the R-squared value decreases by 0.04% after removing the % of class under 20 from the dataset, which indicates that the relationship between the alumni-giving rate and the graduation rate may be non-linear. Therefore, it is appropriate to estimate the second-order quadratic relationship between the two variables.
The second-order quadratic model will be as given below:
Step-by-step procedure to obtain the second-order quadratic regression equation using EXCEL:
- Insert a new column “Graduate Rate^2” in between C and D.
- In cell D, Enter “=C2^2”.
- Drag the cursor till the end of the dataset.
- In Data, select Data Analysis and choose Regression.
- In Input Y Range, select $F$1:$F$49.
- In Input X Range, select $C$1:$E$49.
- Select Labels.
- Click on Confidence Levels and type 95.
- Select the Residuals plot check box.
- Click OK.
Output obtained using EXCEL is given below:
Residual plot for the Graduation Rate, Graduation Rate^2, and Student–Faculty Ratio:
The second-order quadratic model is as follows:
R2(R-squared):
From the output, R square=75.13%.
Thus, only 75.13% variability in the alumni-giving rate (response variable) is explained by the explanatory variables in the regression equation.
5.
Discuss about the universities that are achieving a substantially higher alumni-giving rate than the expected, given that the graduation rate, % of classes under 20, and student/faculty ratio.
Discuss about the universities that are achieving a substantially loweralumni-giving rate than the expected, given that the graduation rate, % of classes under 20, and student/faculty ratio.
Also explain the other independent variables that could be included in the model.
Explanation of Solution
Using the output corresponding to the second-order quadratic model, the residual explain about the predicts the universities that are achieving a substantially higher and loweralumni giving rate and is given as below:
On observing the results of residual, the Alumni-giving rate at the Wake Forest University, U. of Florida, Dartmouth College, Lehigh University, U. of Notre Dame, Princeton University is approximately greater than 9% from the model predicts. Therefore, the presidents of those Universities will be glad with the determinations of the offices of Alumni Affairs.
Also, the results of residual reveal that the Alumni-giving rate at U. of Washington, Georgetown University, Columbia University, Johns Hopkins University, Stanford University,and North-western University, U. of Michigan–Ann Arbor is below 8% from the predicted model. Therefore, the presidents of those Universities will be suggested to do hard work with the determinations of the offices of Alumni Affairs.
Want to see more full solutions like this?
Chapter 4 Solutions
Essentials Of Business Analytics
- Please show as much work as possible to clearly show the steps you used to find each solution. If you plan to use a calculator, please be sure to clearly indicate your strategy. Consider the following game. It costs $3 each time you roll a six-sided number cube. If you roll a 6 you win $15. If you roll any other number, you receive nothing. a) Find the expected value of the game. b) If you play this game many times, will you expect to gain or lose money?arrow_forward= 12:02 WeBWorK / 2024 Fall Rafeek MTH23 D02 / 9.2 Testing the Mean mu / 3 38 WEBWORK Previous Problem Problem List Next Problem 9.2 Testing the Mean mu: Problem 3 (1 point) Test the claim that the population of sophomore college students has a mean grade point average greater than 2.2. Sample statistics include n = 71, x = 2.44, and s = 0.9. Use a significance level of a = 0.01. The test statistic is The P-Value is between : The final conclusion is < P-value < A. There is sufficient evidence to support the claim that the mean grade point average is greater than 2.2. ○ B. There is not sufficient evidence to support the claim that the mean grade point average is greater than 2.2. Note: You can earn partial credit on this problem. Note: You are in the Reduced Scoring Period. All work counts for 50% of the original. Preview My Answers Submit Answers You have attempted this problem 0 times. You have unlimited attempts remaining. . Oli wwm01.bcc.cuny.eduarrow_forwardThere are four white, fourteen blue and five green marbles in a bag. A marble is selected from the bag without looking. Find the odds of the following: The odds against selecting a green marble. The odds in favour of not selecting a green marble The odds in favor of the marble selected being either a white or a blue marble. What is true about the above odds? Explainarrow_forward
- Please show as much work as possible to clearly show the steps you used to find each solution. If you plan to use a calculator, please be sure to clearly indicate your strategy. 1. The probability of a soccer game in a particular league going into overtime is 0.125. Find the following: a. The odds in favour of a game going into overtime. b. The odds in favour of a game not going into overtime. c. If the teams in the league play 100 games in a season, about how many games would you expect to go into overtime?arrow_forwardexplain the importance of the Hypothesis test in a business setting, and give an example of a situation where it is helpful in business decision making.arrow_forwardA college wants to estimate what students typically spend on textbooks. A report fromthe college bookstore observes that textbooks range in price from $22 to $186. Toobtain a 95% confidence level for a confidence interval estimate to plus or minus $10,how many students should the college survey? (We may estimate the populationstandard deviation as (range) ÷ 4.)arrow_forward
- In a study of how students give directions, forty volunteers were given the task ofexplaining to another person how to reach a destination. Researchers measured thefollowing five aspects of the subjects’ direction-giving behavior:• whether a map was available or if directions were given from memory without a map,• the gender of the direction-giver,• the distances given as part of the directions,• the number of times directions such as “north” or “left” were used,• the frequency of errors in directions. Identify each of the variables in this study, and whether each is quantitative orqualitative. For each quantitative variable, state whether it is discrete or continuous. Was this an observational study or an experimental study? Explain your answer.arrow_forwardexplain the difference between the confident interval and the confident level. provide an example to show how to correctly interpret a confidence interval.arrow_forwardSketch to scale the orbit of Earth about the sun. Graph Icarus’ orbit on the same set of axesWhile the sun is the center of Earth’s orbit, it is a focus of Icarus’ orbit. There aretwo points of intersection on the graph. Based on the graph, what is the approximate distance between the two points of intersection (in AU)?arrow_forward
- The diameters of ball bearings are distributed normally. The mean diameter is 67 millimeters and the standard deviation is 3 millimeters. Find the probability that the diameter of a selected bearing is greater than 63 millimeters. Round to four decimal places.arrow_forwardSuppose you like to keep a jar of change on your desk. Currently, the jar contains the following: 22 Pennies 27 Dimes 9 Nickels 30 Quarters What is the probability that you reach into the jar and randomly grab a penny and then, without replacement, a dime? Express as a fraction or a decimal number rounded to four decimal places.arrow_forwardA box contains 14 large marbles and 10 small marbles. Each marble is either green or white. 9 of the large marbles are green, and 4 of the small marbles are white. If a marble is randomly selected from the box, what is the probability that it is small or white? Express as a fraction or a decimal number rounded to four decimal places.arrow_forward
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillBig Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin HarcourtHolt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL