Why the coefficient of labor hours is not significant

Assignment Help Mechanical Engineering

Reference no: EM131173788

A company has recorded its overhead costs, machine hours, and labor hours for the past 60 months. The data are in the file P11_60.xlsx. The company decides to use regression to explain its overhead hours linearly as a function of machine hours and labor hours. However, recognizing good statistical practice, it decides to estimate a regression equation for the first 36 months and then validate this regression with the data from the last 24 months. That is, it will substitute the values of machine and labor hours from the last 24 months into the regression equation that is based on the first 36 months and see how well it does.

a. Run the regression for the first 36 months. Explain briefly why the coefficient of labor hours is not significant.

b. For this part, use the regression equation from part a with both variables still in the equation (even though one was insignificant). Fill in the fitted and residual columns for months 37 through 60. Then do relevant calculations to see whether the R² (or multiple R) and the standard error of estimate s e are as good for these 24 months as they are for the first 36 months. Explain your results briefly

Reference no: EM131173788

Questions Cloud

Determine probable return on investment : BSBMKGSOIB: Determine probable return on investment and potential competitors and describe and rank marketing opportunities in terms of their viability and likely contnbutico to the business

Why might you be disappointed with the results : How well can you can predict overhead costs on the basis of these variables with a linear regression equation? Why might you be disappointed with the results?

Find whether advertising dollars are generating sales : This means that each advertising dollar has to generate at least $10 of sales or the advertising is not cost-effective. Use regression to determine whether advertising dollars are generating this type of sales response.

When should not one rely on standardized tests : What information you think the standardized test scores can provide? Do you think that it is valid to use student assessments to evaluate effectiveness of teaching? Give reasons in your answer.

Why the coefficient of labor hours is not significant : Run the regression for the first 36 months. Explain briefly why the coefficient of labor hours is not significant.

Discuss the examples of at risk students and online learners : What specific populations might struggle more with self regulation and how can you promote it? Discuss the examples of at risk students and online learners and how self regulation plays an important role in both.

Equation that can be used to predict annual sales of dolls : Determine an equation that can be used to predict annual sales of these dolls. Make sure that all variables in your equation are significant at the 10% level.

What is the probability of a type i error : What is the correlation between student anxiety scores and number of study hours? Select alpha and interpret your findings. Make sure to note whether it is significant or not and what the effect size is.

Find the probability that customer will not switch companies : If profits are discounted at 10% annually, use simulation to estimate the value of this customer to GLC. Also estimate the value of a customer to GLC if it can raise its customer satisfaction rating to 85%, to 90%, or to 95%. You can interpret the..

User Account

All Pages