The College of Business at Northeast College is accumulating
data as a first step in the preparation of next year's budget
development. One cost that is being looked at closely is
administrative costs as a function of student credit hours. Data on
administrative costs and credit hours for the past thirteen months
are shown below:
Month | Administrative Costs | Credit Hours | ||||
July | $ | 136,301 | 1,000 | |||
August | 96,613 | 721 | ||||
September | 246,580 | 1,998 | ||||
October | 244,394 | 1,606 | ||||
November | 293,263 | 1,915 | ||||
December | 226,449 | 1,718 | ||||
January | 268,137 | 1,945 | ||||
February | 301,000 | 1,979 | ||||
March | 272,462 | 1,670 | ||||
April | 261,925 | 1,729 | ||||
May | 326,978 | 1,966 | ||||
June | 254,418 | 1,026 | ||||
July | 219,167 | 921 | ||||
Total | $ | 3,147,687 | 20,194 | |||
Average | $ | 242,130 | 1,553 | |||
The controller's office has analyzed the data and has given you the
results from the regression analysis:
SUMMARY OUTPUT | |
Regression Statistics | |
Multiple R | 0.7985572 |
R Square | 0.637693600 |
Adjusted R Square | 0.604756654 |
Standard Error | 40,005.80589 |
Observations | 13 |
ANOVA | |||||
df | SS | MS | F | Significance F | |
Regression | 1 | 30,986,661,233 | 30,986,661,233 | -19.3610424 | 0.00106299 |
Residual | 11 | 17,605,109,557 | 1,600,464,505.0 | ||
Total | 12 | 48,591,770,790 |
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
Intercept | 72,045.32692 | 40,215.47137 | 1.79148284 | 0.10073652 | -16,468.32876 | 160,558.9826 | -16,468.32876 | 160,558.9826 |
X Variable 1 | 109.4928073 | 24.88405898 | 4.400118459 | 0.00106299 | 54.72336273 | 164.262252 | 54.72336273 | 164.262252 |
The correlation coefficient (rounded to the 3rd decimal)
for the regression equation for administrative costs is:
0.735.
0.723.
0.799.
0.833.
The correct answer is 0.799
-------------------------------------------------------------------------------------------
The correlation coefficient r can be calculated using the coefficient of determination R square.
Correlation coefficient r =
=
Correlation coefficient = 0.799
The College of Business at Northeast College is accumulating data as a first step in the...
The College of Business at Northeast College is accumulating data as a first step in the preparation of next year's budget development. One cost that is being looked at closely is administrative costs as a function of student credit hours. Data on administrative costs and credit hours for the past thirteen months are shown below: Month Administrative Costs Credit Hours July $ 130,251 1,200 August 83,373 609 September 226,150 1,886 October 216,774 1,494 November 258,453 1,803 December 185,399 1,606 January...
The College of Business at Northeast College is accumulating data as a first step in the preparation of next year's budget development. One cost that is being looked at closely is administrative costs as a function of student credit hours. Data on administrative costs and credit hours for the past thirteen months are shown below: Month Administrative Costs Credit Hours July $ 129,351 300 August 82,653 141 September 225,610 1,418 October 216,414 1,026 November 258,273 1,335 December 184,499 1,138 January...
The College of Business at Northeast College is accumulating data as a first step in the preparation of next year's budget development. One cost that is being looked at closely is administrative costs as a function of student credit hours. Data on administrative costs and credit hours for the past thirteen months are shown below: Month Administrative Costs Credit Hours July $ 130,301 1,250 August 83,413 635 September 226,180 1,912 October 216,794 1,520 November 258,463 1,829 December 185,449 1,632 January...
The College of Business at Northeast College is accumulating data as a first step in the preparation of next year's budget development. One cost that is being looked at closely is administrative costs as a function of student credit hours. Data on administrative costs and credit hours for the past thirteen months are shown below: Month Administrative Costs Credit Hours July $ 130,151 1,100 August 83,293 557 September 226,090 1,834 October 216,734 1,442 November 258,433 1,751 December 185,299 1,554 January...
The College of Business at Northeast College is accumulating data as a first step in the preparation of next year's budget development. One cost that is being looked at closely is administrative costs as a function of student credit hours. Data on administrative costs and credit hours for the past thirteen months are shown below: Month Administrative Costs Credit Hours July $ 129,301 250 August 82,613 115 September 225,580 1,392 October 216,394 1,000 November 258,263 1,309 December 184,449 1,112 January...
The College of Business at Northeast College is accumulating data as a first step in the preparation of next year's budget development. One cost that is being looked at closely is administrative costs as a function of student credit hours. Data on administrative costs and credit hours for the past thirteen months are shown below: Month Administrative Costs Credit Hours July $ 129,551 500 August 82,813 245 September 225,730 1,522 October 216,494 1,130 November 258,313 1,439 December 184,699 1,242 January...
The College of Business at Northeast College is accumulating data as a first step in the preparation of next year's budget development. One cost that is being looked at closely is administrative costs as a function of student credit hours. Data on administrative costs and credit hours for the past thirteen months are shown below: Month Administrative Costs Credit Hours July $ 129,451 400 August 82,733 193 September 225,670 1,470 October 216,454 1,078 November 258,293 1,387 December 184,599 1,190 January...
The College of Business at Northeast College is accumulating data as a first step in the preparation of next year's budget development. One cost that is being looked at closely is administrative costs as a function of student credit hours. Data on administrative costs and credit hours for the past thirteen months are shown below: Month Administrative Costs Credit Hours July $ 129,901 850 August 83,093 427 September 225,940 1,704 October 216,634 1,312 November 258,383 1,621 December 185,049 1,424 January...
The College of Business at Northeast College is accumulating data as a first step in the preparation of next year's budget development. One cost that is being looked at closely is administrative costs as a function of student credit hours. Data on administrative costs and credit hours for the past thirteen months are shown below: Month Administrative Costs Credit Hours July $ 129,901 850 August 83,093 427 September 225,940 1,704 October 216,634 1,312 November 258,383 1,621 December 185,049 1,424 January...
The College of Business at Northeast College is accumulating data as a first step in the preparation of next year's budget development. One cost that is being looked at closely is administrative costs as a function of student credit hours. Data on administrative costs and credit hours for the past thirteen months are shown below: Month July August September October November December January February March April May June July Total Average Administrative Costs $ 129,901 83,093 225, 940 216,634 258,383...