![Essentials Of Business Analytics](https://www.bartleby.com/isbn_cover_images/9781285187273/9781285187273_largeCoverImage.gif)
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.
![Check Mark](/static/check-mark.png)
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.
![Check Mark](/static/check-mark.png)
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.
![Check Mark](/static/check-mark.png)
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.
![Check Mark](/static/check-mark.png)
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.
![Check Mark](/static/check-mark.png)
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
- Calie 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. Calie is feeling an extra pressure to increase total giving to the university because of recent budget cuts. Calie is also feeling pressured to increase the percentage of alumni to give. Calie found this new metric called average alumni giving rate U.S. News & World Report.…arrow_forwardCalie 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. Calie is feeling an extra pressure to increase total giving to the university because of recent budget cuts. Calie is also feeling pressured to increase the percentage of alumni to give. Calie found this new metric called average alumni giving rate U.S. News & World Report.…arrow_forwardSocially conscious investors screen out stocks of alcohol and tobacco makers, firms with poor environmental records, and companies with poor labor practices. Some examples of "good," socially conscious companies are Johnson and Johnson, Dell Computers, Bank of America, and Home Depot. The question is, are such stocks overpriced? One measure of value is the P/E, or price-to-earnings ratio. High P/E ratios may indicate a stock is overpriced. For the S&P Stock Index of all major stocks, the mean P/E ratio is ? = 19.4. A random sample of 36 "socially conscious" stocks gave a P/E ratio sample mean of x = 17.7, with sample standard deviation s = 5.2. Does this indicate that the mean P/E ratio of all socially conscious stocks is different (either way) from the mean P/E ratio of the S&P Stock Index? Use ? = 0.05. a) What is the value of the sample test statistic? (Round your answer to three decimal places.)arrow_forward
- Socially conscious investors screen out stocks of alcohol and tobacco makers, firms with poor environmental records, and companies with poor labor practices. Some examples of "good," socially conscious companies are Johnson and Johnson, Dell Computers, Bank of America, and Home Depot. The question is, are such stocks overpriced? One measure of value is the P/E, or price-to-earnings ratio. High P/E ratios may indicate a stock is overpriced. For the S&P Stock Index of all major stocks, the mean P/E ratio is ? = 19.4. A random sample of 36 "socially conscious" stocks gave a P/E ratio sample mean of x = 17.8, with sample standard deviation s = 5.8. Does this indicate that the mean P/E ratio of all socially conscious stocks is different (either way) from the mean P/E ratio of the S&P Stock Index? Use ? = 0.05. I need help with sketching (d) and (e)arrow_forwardSocially conscious investors screen out stocks of alcohol and tobacco makers, firms with poor environmental records, and companies with poor labor practices. Some examples of "good," socially conscious companies are Johnson and Johnson, Dell Computers, Bank of America, and Home Depot. The question is, are such stocks overpriced? One measure of value is the P/E, or price-to-earnings ratio. High P/E ratios may indicate a stock is overpriced. For the S&P Stock Index of all major stocks, the mean P/E ratio is μ = 19. A random sample of 36 "socially conscious" stocks gave a P/E ratio sample mean of x = 17.2, with sample standard deviation s = 5.4. Does this indicate that the mean P/E ratio of all socially conscious stocks is different (either way) from the mean P/E ratio of the S&P Stock Index? Use ? = 0.05. (a) What is the level of significance?State the null hypotheses H0 = and the alternate hypothesis H1 = . H0 : μ ---Select--- < ≥ = > ≤ ≠ H1 : μ ---Select--- ≥ ≠ =…arrow_forwardSocially conscious investors screen out stocks of alcohol and tobacco makers, firms with poor environmental records, and companies with poor labor practices. Some examples of "good," socially conscious companies are Johnson and Johnson, Dell Computers, Bank of America, and Home Depot. The question is, are such stocks overpriced? One measure of value is the P/E, or price-to-earnings ratio. High P/E ratios may indicate a stock is overpriced. For the S&P Stock Index of all major stocks, the mean P/E ratio is ? = 19.4. A random sample of 36 "socially conscious" stocks gave a P/E ratio sample mean of x = 17.7, with sample standard deviation s = 5.2. Does this indicate that the mean P/E ratio of all socially conscious stocks is different (either way) from the mean P/E ratio of the S&P Stock Index? Use ? = 0.05. (a) What is the level of significance?State the null and alternate hypotheses. H0: ? = 19.4; H1: ? < 19.4H0: ? ≠ 19.4; H1: ? = 19.4 H0: ? = 19.4; H1: ? ≠ 19.4H0: ?…arrow_forward
- Socially conscious investors screen out stocks of alcohol and tobacco makers, firms with poor environmental records, and companies with poor labor practices. Some examples of "good," socially conscious companies are Johnson and Johnson, Dell Computers, Bank of America, and Home Depot. The question is, are such stocks overpriced? One measure of value is the P/E, or price-to-earnings ratio. High P/E ratios may indicate a stock is overpriced. For the S&P Stock Index of all major stocks, the mean P/E ratio is μ = 19.4. A random sample of 36 "socially conscious" stocks gave a P/E ratio sample mean of x = 17.7, with sample standard deviation s = 5.4. Does this indicate that the mean P/E ratio of all socially conscious stocks is different (either way) from the mean P/E ratio of the S&P Stock Index? Use ? = 0.05. (a) What is the level of significance? What is the value of the sample test statistic? (Round your answer to three decimal places.)arrow_forwardSocially conscious investors screen out stocks of alcohol and tobacco makers, firms with poor environmental records, and companies with poor labor practices. Some examples of "good," socially conscious companies are Johnson and Johnson, Dell Computers, Bank of America, and Home Depot. The question is, are such stocks overpriced? One measure of value is the P/E, or price-to-earnings ratio. High P/E ratios may indicate a stock is overpriced. For the S&P Stock Index of all major stocks, the mean P/E ratio is ? = 19.4. A random sample of 31 "socially conscious" stocks gave a P/E ratio sample mean of x = 18.1, with sample standard deviation s = 5.2. Does this indicate that the mean P/E ratio of all socially conscious stocks is different (either way) from the mean P/E ratio of the S&P Stock Index? Use ? = 0.01. (a) What is the level of significance? (b) What is the value of the sample test statistic? (Round your answer to three decimal places.)(c) Find the P-value. (Round your…arrow_forwardSocially conscious investors screen out stocks of alcohol and tobacco makers, firms with poor environmental records, and companies with poor labor practices. Some examples of "good," socially conscious companies are Johnson and Johnson, Dell Computers, Bank of America, and Home Depot. The question is, are such stocks overpriced? One measure of value is the P/E, or price-to-earnings ratio. High P/E ratios may indicate a stock is overpriced. For the S&P Stock Index of all major stocks, the mean P/E ratio is u = 19.4. A random sample of 36 "socially conscious" stocks gave a P/E ratio sample mean of x = 18.0, with sample standard deviation s = 4.2. Does this indicate that the mean P/E ratio of all socially conscious stocks is different (either way) from the mean P/E ratio of the S&P Stock Index? Use a = 0.01. (a) What is the level of significance? State the null and alternate hypotheses. О Но: и # 19.4;B Hi: и %3D 19.4 O Ho: µ > 19.4; H1: µ = 19.4 O Ho: H 3D 19.4;B Hi: и > 19.4 O Ho: H 3D…arrow_forward
- Socially conscious investors screen out stocks of alcohol and tobacco makers, firms with poor environmental records, and companies with poor labor practices. Some examples of "good," socially conscious companies are Johnson and Johnson, Dell Computers, Bank of America, and Home Depot. The question is, are such stocks overpriced? One measure of value is the P/E, or price-to-earnings ratio. High P/E ratios may indicate a stock is overpriced. For the S&P Stock Index of all major stocks, the mean P/E ratio is u 19.4. A random sample of 31 "socially conscious" stocks gave a P/E ratio sample mean of x 18.3, with sample standard deviation s = 4.2. At a 10% level of significance does this indicate that the mean P/E ratio of all socially conscious stocks is different (either way) from the mean P/E ratio of the S&P Stock Index? = = What distribution will be used for this test? Student's t Is this test right-tailed, left-tailed, or two-tailed? two-tailed Using the critical region method which…arrow_forwardSocially conscious investors screen out stocks of alcohol and tobacco makers, firms with poor environmental records, and companies with poor labor practices. Some examples of "good," socially conscious companies are Johnson and Johnson, Dell Computers, Bank of America, and Home Depot. The question is, are such stocks overpriced? One measure of value is the P/E, or price-to-earnings ratio. High P/E ratios may indicate a stock is overpriced. For the S&P Stock Index of all major stocks, the mean P/E ratio is ? = 19.4. A random sample of 36 "socially conscious" stocks gave a P/E ratio sample mean of x = 17.8, with sample standard deviation s = 5.8. Does this indicate that the mean P/E ratio of all socially conscious stocks is different (either way) from the mean P/E ratio of the S&P Stock Index? Use ? = 0.05.arrow_forwardSocially conscious investors screen out stocks of alcohol and tobacco makers, firms with poor environmental records, and companies with poor labor practices. Some examples of "good," socially conscious companies are Johnson and Johnson, Dell Computers, Bank of America, and Home Depot. The question is, are such stocks overpriced? One measure of value is the P/E, or price-to-earnings ratio. High P/E ratios may indicate a stock is overpriced. For the S&P Stock Index of all major stocks, the mean P/E ratio is ? = 19.4. A random sample of 36 "socially conscious" stocks gave a P/E ratio sample mean of x = 17.9, with sample standard deviation s = 5.8. Does this indicate that the mean P/E ratio of all socially conscious stocks is different (either way) from the mean P/E ratio of the S&P Stock Index? Use ? = 0.05.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
![Text book image](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781680331141/9781680331141_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9780547587776/9780547587776_smallCoverImage.jpg)