Month July August September Administrative Costs $ 129,751 Credit Hours 700 82,973 349 225,850 1,626 October 216,574 1,234 November 258,353 1,543 December 184,899 1,346 January 219,497 1,573 February 245,270 1,607 March 209,642 1,298 April 192,015 1,357 May 250,428 1,594 June 170,778 654 July 128,437 549 Total $2,514,467 15,430 Average $193,421 1,187 The controller's office has analyzed the data and has given you the results from the regression analysis: Multiple R R Square Adjusted R Square Standard Error Observations SUMMARY OUTPUT Regression Statistics 0.9304221 0.865685215 0.853474780 ANOVA Regression Residual Total Intercept X Variable 1 df 1 11 12 Coefficients 65,361.55084 107.8915644 20,299.67390 SS 13 29,215,073,804 4,532,844,363 33,747,918,167 Standard Error 16,217.47628 12.81365592 MS 29,215,073,804 412,076,760.3 t Stat 4.03031580 8,420045389 -70.8971644 Significance F 4.00248E-06 P-value 0.001980929 4.00248E-06 Lower 95% 29,667.12621 79.68889790 Based on the results of the high-low analysis, the estimate of administrative costs in a month with 1,180 credit hours would be: Note: Round the variable cost per credit hour to 2 decimal places. Round your final answer to the nearest whole dollar. $175,952. $193,653. Upper 95% 101,055.9755 136.094231 Lower 95.0% 29,667.12621 79.68889790 Upper 95.0% 101,055.9755 136.094231
Month July August September Administrative Costs $ 129,751 Credit Hours 700 82,973 349 225,850 1,626 October 216,574 1,234 November 258,353 1,543 December 184,899 1,346 January 219,497 1,573 February 245,270 1,607 March 209,642 1,298 April 192,015 1,357 May 250,428 1,594 June 170,778 654 July 128,437 549 Total $2,514,467 15,430 Average $193,421 1,187 The controller's office has analyzed the data and has given you the results from the regression analysis: Multiple R R Square Adjusted R Square Standard Error Observations SUMMARY OUTPUT Regression Statistics 0.9304221 0.865685215 0.853474780 ANOVA Regression Residual Total Intercept X Variable 1 df 1 11 12 Coefficients 65,361.55084 107.8915644 20,299.67390 SS 13 29,215,073,804 4,532,844,363 33,747,918,167 Standard Error 16,217.47628 12.81365592 MS 29,215,073,804 412,076,760.3 t Stat 4.03031580 8,420045389 -70.8971644 Significance F 4.00248E-06 P-value 0.001980929 4.00248E-06 Lower 95% 29,667.12621 79.68889790 Based on the results of the high-low analysis, the estimate of administrative costs in a month with 1,180 credit hours would be: Note: Round the variable cost per credit hour to 2 decimal places. Round your final answer to the nearest whole dollar. $175,952. $193,653. Upper 95% 101,055.9755 136.094231 Lower 95.0% 29,667.12621 79.68889790 Upper 95.0% 101,055.9755 136.094231
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Transcribed Image Text:Month
July
August
September
Administrative
Costs
$ 129,751
Credit Hours
700
82,973
349
225,850
1,626
October
216,574
1,234
November
258,353
1,543
December
184,899
1,346
January
219,497
1,573
February
245,270
1,607
March
209,642
1,298
April
192,015
1,357
May
250,428
1,594
June
170,778
654
July
128,437
549
Total
$2,514,467
15,430
Average
$193,421
1,187
The controller's office has analyzed the data and has given you the results from the regression analysis:
Multiple R
R Square
Adjusted R Square
Standard Error
Observations
SUMMARY OUTPUT
Regression Statistics
0.9304221
0.865685215
0.853474780
ANOVA
Regression
Residual
Total
Intercept
X Variable 1
df
1
11
12
Coefficients
65,361.55084
107.8915644
20,299.67390
SS
13
29,215,073,804
4,532,844,363
33,747,918,167
Standard Error
16,217.47628
12.81365592
MS
29,215,073,804
412,076,760.3
t Stat
4.03031580
8,420045389
-70.8971644
Significance F
4.00248E-06
P-value
0.001980929
4.00248E-06
Lower 95%
29,667.12621
79.68889790
Based on the results of the high-low analysis, the estimate of administrative costs in a month with 1,180 credit hours would be:
Note: Round the variable cost per credit hour to 2 decimal places. Round your final answer to the nearest whole dollar.
$175,952.
$193,653.
Upper 95%
101,055.9755
136.094231
Lower 95.0%
29,667.12621
79.68889790
Upper 95.0%
101,055.9755
136.094231
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education