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:
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
Below is the data from a regression analysis performed by Earth Right Spa on its overhead...
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 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 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 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 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 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. 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 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 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 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...