The Business School at Eastern College is collecting data as a first step in the preparation...

60.1K

Verified Solution

Question

Finance

The Business School at Eastern College is collecting data as afirst step in the preparation of next year's budget. One cost thatis being looked at closely is administrative staff as a function ofstudent credit hours. Data on administrative costs and credit hoursfor the most recent 13 months follow.

MonthAdministrative CostsCredit Hours
July$129,301250
August82,613115
September228,5801,392
October216,3941,000
November258,2631,309
December184,4491,112
January219,1371,339
February245,0001,373
March209,6421,064
April191,9251,123
May249,9781,360
June170,418420
July128,167315
Total$2,513,86712,172
Average$193,374936

The controller's office has analyzed the data and given you theresults from the regression analysis, as follows.

SUMMARY OUTPUT

Regression Statistics
Multiple R0.93339145
R Square0.871219590
Adjusted R Square0.859512280
Standard Error19954.56760
Observations13

ANOVA

dfSSMSFSignificance F
Regression129631603873.0029631603873.0074.42000000.0000032
Residual114380032428398184766
Total1234011636301.00


CoefficientsStandard ErrorT StatP-valueLower 95%Upper 95%
Intercept96414.55712528.429047.695662110.000009468839.6563123989.4569
Credit Hours103.555517912.00433178.626512570.000003277.1341487129.9768871


Required:

a. In the standard regression equationy = a + bx, the letter b isbest described as the:

  • Constant coefficient

  • Correlation coefficient

  • Dependent variable

  • Independent variable

  • Variable cost coefficient

b. In the standard regression equationy = a + bx, the letter y isbest described as the:

  • Constant coefficient

  • Correlation coefficient

  • Dependent variable

  • Independent variable

  • Variable cost coefficient

c. In the standard regression equationy = a + bx, the letter x isbest described as the:

  • Constant coefficient

  • Correlation coefficient

  • Dependent variable

  • Independent variable

  • Variable cost coefficient

d. If the controller uses the high-low methodto estimate costs, the cost equation for administrative costs is:(Do not round your intermediate calculations.)

  • Cost = $69,468 + ($114 × Credit hours)

  • Cost = $67,313 + ($133 × Credit hours)

  • Cost = $193,374.00 × Credit hours

  • Cost = $207

  • Some other equation


e. Based on the results of the controller'sregression analysis, the estimate of administrative costs in amonth with 1,000 credit hours would be: (Round yourintermediate calculations to 2 decimals.)

  • 198,808

  • 201,000

  • 96,409

  • 199,975

  • Some other amount

f. The correlation coefficient (rounded) forthe regression equation for administrative costs is:

  • 0.871

  • 0.933

  • 0.859

  • 0.966

  • Some other amount


g. The percent of the total variance (rounded)that can be explained by the regression is:

  • 93.3

  • 87.1

  • 85.9

  • 96.6

  • Some other amount

Answer & Explanation Solved by verified expert
3.6 Ratings (686 Votes)
In a Standard Regression Equation y a b x y dependent variable a intercept x independent variable b regression coefficient or slope of regression line or coefficient of independent variable In cost determination standard regression equation b variable cost coefficient a In the    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

The Business School at Eastern College is collecting data as afirst step in the preparation of next year's budget. One cost thatis being looked at closely is administrative staff as a function ofstudent credit hours. Data on administrative costs and credit hoursfor the most recent 13 months follow.MonthAdministrative CostsCredit HoursJuly$129,301250August82,613115September228,5801,392October216,3941,000November258,2631,309December184,4491,112January219,1371,339February245,0001,373March209,6421,064April191,9251,123May249,9781,360June170,418420July128,167315Total$2,513,86712,172Average$193,374936The controller's office has analyzed the data and given you theresults from the regression analysis, as follows.SUMMARY OUTPUTRegression StatisticsMultiple R0.93339145R Square0.871219590Adjusted R Square0.859512280Standard Error19954.56760Observations13ANOVAdfSSMSFSignificance FRegression129631603873.0029631603873.0074.42000000.0000032Residual114380032428398184766Total1234011636301.00CoefficientsStandard ErrorT StatP-valueLower 95%Upper 95%Intercept96414.55712528.429047.695662110.000009468839.6563123989.4569Credit Hours103.555517912.00433178.626512570.000003277.1341487129.9768871Required:a. In the standard regression equationy = a + bx, the letter b isbest described as the:Constant coefficientCorrelation coefficientDependent variableIndependent variableVariable cost coefficientb. In the standard regression equationy = a + bx, the letter y isbest described as the:Constant coefficientCorrelation coefficientDependent variableIndependent variableVariable cost coefficientc. In the standard regression equationy = a + bx, the letter x isbest described as the:Constant coefficientCorrelation coefficientDependent variableIndependent variableVariable cost coefficientd. If the controller uses the high-low methodto estimate costs, the cost equation for administrative costs is:(Do not round your intermediate calculations.)Cost = $69,468 + ($114 × Credit hours)Cost = $67,313 + ($133 × Credit hours)Cost = $193,374.00 × Credit hoursCost = $207Some other equatione. Based on the results of the controller'sregression analysis, the estimate of administrative costs in amonth with 1,000 credit hours would be: (Round yourintermediate calculations to 2 decimals.)198,808201,00096,409199,975Some other amountf. The correlation coefficient (rounded) forthe regression equation for administrative costs is:0.8710.9330.8590.966Some other amountg. The percent of the total variance (rounded)that can be explained by the regression is:93.387.185.996.6Some other amount

Other questions asked by students