LO 5 10-39 Evaluating alternative simple regression models, not-for-profit. (Appendixes 10A and 10B) Kathy Hanks, executive assistant to the president of Eastern University, is concerned about the overhead costs at her university. Cost pressures are severe, so controlling and reducing overhead is very important. Hanks believes overhead costs incurred are generally a function of the number of different academic pro- grams (including different specializations, degrees, and majors) that the university has and the number of enrolled students. Both have grown significantly over the years. She collects the following data: Year Number of Programs Enrolled Students 3,400 5,000 Overhead Costs (in thousands) $16,200 23,040 20,160 24,120 23,400 27,720 28,440 24,120 27,360 35,640 37,440 45,720 2,600 4,700 3,900 4,900 5,700 3,900 3,500 3,700 5,600 103 7,600 Regression 1. Overhead costs = a + (b X number of academic programs) Coefficient $8,553.30 $288.76 Standard Error $4,002.41 $ 56. 80 -Value 2.14 .08 5 Variable Constant Independent variable 1: number of academic programs R=0.72; Durbin-Watson statistic = 1.81 The adjusted p=0.693 Regression 2. Overhead costs = a + (bx number of enrolled students) Variable Coefficient Standard Error Constant $7,190.10 $6,081.45 Independent variable 1: number of $ 4.53 $ 1.29 enrolled students R=0.55; Durbin-Watson statistic=0.7694 The adjusted p=0.509 -Value 1.18 3.52 Instructions Form groups of two or more students to complete the following requirements: Required 1. Plot the relationship between overhead costs and each of the following variables: (a) number of aca- demic programs and (b) number of enrolled students. 2. Compare and evaluate the two simple regression models estimated by Hanks. Use the comparison format. 3. What insights do the analyses provide about controlling and reducing overhead costs at the university? 4. What are two important issues that would suggest the predictions are unreliable? LO 5 10-39 Evaluating alternative simple regression models, not-for-profit. (Appendixes 10A and 10B) Kathy Hanks, executive assistant to the president of Eastern University, is concerned about the overhead costs at her university. Cost pressures are severe, so controlling and reducing overhead is very important. Hanks believes overhead costs incurred are generally a function of the number of different academic pro- grams (including different specializations, degrees, and majors) that the university has and the number of enrolled students. Both have grown significantly over the years. She collects the following data: Year Number of Programs Enrolled Students 3,400 5,000 Overhead Costs (in thousands) $16,200 23,040 20,160 24,120 23,400 27,720 28,440 24,120 27,360 35,640 37,440 45,720 2,600 4,700 3,900 4,900 5,700 3,900 3,500 3,700 5,600 103 7,600 Regression 1. Overhead costs = a + (b X number of academic programs) Coefficient $8,553.30 $288.76 Standard Error $4,002.41 $ 56. 80 -Value 2.14 .08 5 Variable Constant Independent variable 1: number of academic programs R=0.72; Durbin-Watson statistic = 1.81 The adjusted p=0.693 Regression 2. Overhead costs = a + (bx number of enrolled students) Variable Coefficient Standard Error Constant $7,190.10 $6,081.45 Independent variable 1: number of $ 4.53 $ 1.29 enrolled students R=0.55; Durbin-Watson statistic=0.7694 The adjusted p=0.509 -Value 1.18 3.52 Instructions Form groups of two or more students to complete the following requirements: Required 1. Plot the relationship between overhead costs and each of the following variables: (a) number of aca- demic programs and (b) number of enrolled students. 2. Compare and evaluate the two simple regression models estimated by Hanks. Use the comparison format. 3. What insights do the analyses provide about controlling and reducing overhead costs at the university? 4. What are two important issues that would suggest the predictions are unreliable
