Western University is growing steadily, as measured by the number of courses listed, the number of...

Transcribed Image Text:

Western University is growing steadily, as measured by the number of courses listed, the number of course sections taught, and the number of student enrolled. The increased growth has led to increased costs at the university. Data on growth in the number of courses, sections, and students as well as the increase in costs are shown below. Semester Courses listed Sections taught Students enrolled Total Costs Fall 97 2,670 7,065 28,874 $117,160,156 Winter 98 2,670 6,775 29,091 $117,352,268 Fall 98 2,628 6,232 28,621 $115,928,777 Winter 99 2,678 6,833 27,310 $116,889,599 Fall 99 2,752 6,215 27,126 $117,622,521 Winter 00 2,788 5,819 28,196 $118,083,424 Fall 00 2,791 5,793 27,309 $118,377,586 Winter 01 2,780 6,398 28,602 $118,591,107 Fall 01 2,788 7,158 29,373 $119,002,174 Winter 02 2,797 6,563 30,747 $120,012,361 Fall 02 2,677 7,045 29,191 $120,335,311 Winter 03 2,814 7,054 29,093 $122,635,639 Fall 03 2,632 7,062 28,912 $122,954,610 Winter 04 2,662 7,155 29,194 $123,192,014 Fall 04 2,782 7,148 29,243 $123,683,762 Winter 05 3,056 7,252 28,928 $125,508,964 Fall 05 2,811 7,157 29,227 $125,798,899 Winter 06 2,830 7,384 29,256 $126,856,310 Fall 06 2,716 7,142 29,197 $127,291,099 Winter 07 2,814 7,141 29,195 $127,600,050 Fall 07 3,030 7,521 29,374 $127,352,245 Winter 08 2,820 7,258 32,227 $128,577,777 Fall 08 2,817 7,249 31,263 $128,408,000 Winter 09 2,876 7,142 29,197 $129,436,179 Required. 1. Use simple and multiple linear regression analysis to determine the best regression model to predict total costs using one or more of the three predictors: number of courses, lessons, or students. Explain why you have chosen this regression. 2. Explain how, if so, the analysis you have completed could be compared to activity-based costing. Western University is growing steadily, as measured by the number of courses listed, the number of course sections taught, and the number of student enrolled. The increased growth has led to increased costs at the university. Data on growth in the number of courses, sections, and students as well as the increase in costs are shown below. Semester Courses listed Sections taught Students enrolled Total Costs Fall 97 2,670 7,065 28,874 $117,160,156 Winter 98 2,670 6,775 29,091 $117,352,268 Fall 98 2,628 6,232 28,621 $115,928,777 Winter 99 2,678 6,833 27,310 $116,889,599 Fall 99 2,752 6,215 27,126 $117,622,521 Winter 00 2,788 5,819 28,196 $118,083,424 Fall 00 2,791 5,793 27,309 $118,377,586 Winter 01 2,780 6,398 28,602 $118,591,107 Fall 01 2,788 7,158 29,373 $119,002,174 Winter 02 2,797 6,563 30,747 $120,012,361 Fall 02 2,677 7,045 29,191 $120,335,311 Winter 03 2,814 7,054 29,093 $122,635,639 Fall 03 2,632 7,062 28,912 $122,954,610 Winter 04 2,662 7,155 29,194 $123,192,014 Fall 04 2,782 7,148 29,243 $123,683,762 Winter 05 3,056 7,252 28,928 $125,508,964 Fall 05 2,811 7,157 29,227 $125,798,899 Winter 06 2,830 7,384 29,256 $126,856,310 Fall 06 2,716 7,142 29,197 $127,291,099 Winter 07 2,814 7,141 29,195 $127,600,050 Fall 07 3,030 7,521 29,374 $127,352,245 Winter 08 2,820 7,258 32,227 $128,577,777 Fall 08 2,817 7,249 31,263 $128,408,000 Winter 09 2,876 7,142 29,197 $129,436,179 Required. 1. Use simple and multiple linear regression analysis to determine the best regression model to predict total costs using one or more of the three predictors: number of courses, lessons, or students. Explain why you have chosen this regression. 2. Explain how, if so, the analysis you have completed could be compared to activity-based costing.

Answer rating: 100% (QA)

1 To determine the best regression model to predict total costs using one or more of the three predictors number of courses listed sections taught and ... View the full answer