Question

Below is the data from a regression analysis performed by Earth Right Spa on its overhead...

Below is the data from a regression analysis performed by Earth Right Spa on its overhead costs and clients for the past year. Use this information to answer the following questions.

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.949
R Square 0.901
Adjusted R Square 0.891
Standard Error 1102.512
Observations 12.000
ANOVA
df ss MS f Significance F
Regression 1 111011767.37 111011767.37 91.33 0.00
Residual 10 12155332.63 1215533.26
Total 11 123167100.00
Ceofficients Standard Error tStar P-value Lower 95% Upper 95% Lower 95.0% Upper 95%
Intercept 6825.84 724.43 9.42 0.00 5211.70 8439.98 5211.70 8439.98
Guests (X) 32.86 3.44 9.56 0.00 25.20 40.52 25.20 40.52

Knowledge Check 01

Identify the fixed overhead cost per month from the data provided.

  • $8,364.72

  • $946.56

  • $6,825.84

  • $6,546.54

Knowledge Check 02

What is the variable overhead cost per client served?

  • $724.43

  • $25.20

  • $40.52

  • $32.86

Knowledge Check 03

What will be the total overhead cost if 100 clients are served?

  • $10,111.84

  • $79,269.07

  • $9,345.86

  • $10,878.24

The span at which the cost behaviors are expected to hold true is called:

0 0
Add a comment Improve this question Transcribed image text
Answer #1

The intercept here represents the fixed cost, i.e. 6825.84

The slope or X represents the cost per client serves i.e. 32.86

The total overhead for serving 100 clients is = (6825.84+(100*32.86))=10111.84

Span at which the cost behaviors are expected to hold true is called Confidence interval

Add a comment
Know the answer?
Add Answer to:
Below is the data from a regression analysis performed by Earth Right Spa on its overhead...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • From the regression example discussed in class and based on the information below: Regression Statistics Multiple...

    From the regression example discussed in class and based on the information below: Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.925 0.856 0.846 0.059 45 ANOVA P dfss SMS 3 0 .85 0.14 440.99 Significance F 0.00 Regression Residual Total 0.28 0.00 81.46 Intercept PRICE INCOME WEATHER Coefficients 13.040 -0.200 1.500 0.124 Standard Error 0.758 0.063 0.079 0.065 Stat P-value 17.1940 .000 -7.904 0.000 13.162 0.000 1.909 0.063 L ower 95% 11.508 -0.627 0.883 -0.007...

  • Interpreting Regression Output Rikki Bake, the controller for XYZ Incorporated, suspects that factory overhead costs are...

    Interpreting Regression Output Rikki Bake, the controller for XYZ Incorporated, suspects that factory overhead costs are driven by the number of machine hours used. Using Excel, Ms. Bake input twelve months of historical data for total factory overhead costs and machine hours used. The summary output information is provided below. Use the output information provided to develop a cost formula for overhead cost. SUMMARY OUTPUT 4 Regression Statistics Multiple R 0.963809718 R Square 0.928929173 Adjusted R Square 0.92182209 Standard Error...

  • Determine whether the High-Low method or Regression Analysis is better to predict monthly overhead costs. Explain...

    Determine whether the High-Low method or Regression Analysis is better to predict monthly overhead costs. Explain which model is the better? Why or why not? Use absolute cell address in y = a + bX formula (Use absolute August X Value) to predict January and December overhead costs. Do you think these predicted overhead costs are reasonable? Observation Month Known X Known Y Overhead Cost Production Units $250,000.00 34000 $184,000.00 26000 $165,000.00 21000 $178,000.00 24000 $192,000.00 28000 $225,000.00 32000 $210,000.00...

  • In relation to the below output from the Regression Analysis of the S&P/ASX200 Index (X) and...

    In relation to the below output from the Regression Analysis of the S&P/ASX200 Index (X) and from the company ABC Shares derived from weekly data over a 12 month period, can you please explain the key measures and what this all means eg. Number of Observations, R Square, Value of the Slope and the P-Value of the Slope etc. SUMMARY OUTPUT Regression Statistics Multiple R 0.045274332 R Square 0.002049765 Adjusted R Square -0.01790924 Standard Error 0.023996449 Observations 52 ANOVA df...

  • HW # 5 Linear Regression: Use Data Analysis in Excel to conduct the Regression Analysis to...

    HW # 5 Linear Regression: Use Data Analysis in Excel to conduct the Regression Analysis to reproduce the excel out put below (Note: First enter the data in the next page in an Excel spreadsheet) Home Sale Price: The table below provides the Excel output of a regression analysis of the relationship between Home sale price(Y) measured in thousand dollars and Square feet area (x):    SUMMARY OUTPUT Dependent: Home Price ($1000) Regression Statistics Multiple R 0.691 R Square 0.478 Adjusted...

  • g. Use MS Excel Data Analysis ToolPak to perform a multiple regression analysis using Quality as...

    g. Use MS Excel Data Analysis ToolPak to perform a multiple regression analysis using Quality as the response variable and Helpfulness, Clarity, Easiness, and raterInterest as the explanatory variables. Write down the resulting regression equation and provide the regression output. h. Based on the regression output in part g), which variable(s) seem to be significant predictors of Quality? Which variable(s) do you suggest removing from the model in part g)? Explain why. Regression Statistics ANOVA Multiple R 0.998557685 df SS...

  • How do I calculate UCL/LCL (95%) from the following available data; Coefficient, Standard Error, T-Stat, P-Value....

    How do I calculate UCL/LCL (95%) from the following available data; Coefficient, Standard Error, T-Stat, P-Value. Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.9613 0.9241 0.9222 1425.3397 200 ANOVA Significance df MS Regression Residual Total 479410417802.47 95882083560.49 472.4892 39368362197.53 518778780000.00 0.00 194 199 202929702.05 Upper 95% CoefficientsStandard Erro t Stat P-value Lower 95% 45482.366 10383.543 11.088 738.388 0.014 2.546 19403.8863 3153.7202 10.4859 175.8223 0.0023 1.2209 2.340.0201 0.0012 0.2916 0.0000 0.0000 0.0383 Intercept V1 v2 3.29...

  • 01:37:49 Question 2of 28 Step 1 of 4 A regression Analysis has been performed to estimate the model and the output is given. Regression Statistics 91092 82977 80140 23581 ultiple R justed R Sq...

    01:37:49 Question 2of 28 Step 1 of 4 A regression Analysis has been performed to estimate the model and the output is given. Regression Statistics 91092 82977 80140 23581 ultiple R justed R Square tandard Error bservations 8 ANOVA gnificance F 00165 df SS 24652 gression esidual otal 1,62635 0.05561 1,62635 33365 96000 -Upper 95% tStat 1430070 -5.40789 P-value 0.00001 00165 Lower 95% tandard Error 22648 13923 fficients 23882 0.75294 Ne Prev 68465 1.09362 9300 41226 ntercept iles Step 1...

  • Multiple Regression Analysis This information is taken from 80 homes recently sold along the Gulf of...

    Multiple Regression Analysis This information is taken from 80 homes recently sold along the Gulf of Mexico coast.Analyze the data to discover which of the variable have a statistically significant influence on the sales price. A. Write out the equation for the model you develop B, Interpret the equation as a model and the meaning of the information for each variable in your "best" model C.Interpret the confidence intervals for each of the statistically significant variables Use the data provided...

  • QUESTION 12 Below is some of the regression output from a regression of the amount various...

    QUESTION 12 Below is some of the regression output from a regression of the amount various customers paid for a new car (expressed in dollars) versus the age of the customer (expressed in years), the number of previous cars the customer had purchased from the dealership in the past, a dummy variable indicating the gender of the customer (=1 for a Man and = 0 for a woman), and an interactive term the multiplies the age of the customer with...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT