Question

In: Statistics and Probability

In order to improve the linear model to predict an employee’s salary (in thousands), the researcher...

In order to improve the linear model to predict an employee’s salary (in thousands), the researcher decided to also include in the model the previous work experience (in years) and education of each employee (in years). The multiple regression linear model is as follows:

Salaryi=β0+β1Employmenti+β2Experience+β3Education+εi

The following information was obtained from the statistical software:

Source                   df                  SS            MS                    F           P-value

Model                      3      29231989 9743996                   ?                 .006  

Error                      4      1739708    434927

Total                        7      30971697      

Variable                Parameter Est.     Std. Err. Of Parameter Est.           T      

Constant                  49764.00                        1981.00                        25.12

Employment               364.41                             48.32                           7.54

Experience                  227.60                          123.80                           1.838

Education                    266.90                           147.40                          1.81

  1. Test the hypothesis   H0: β1=β2=β3=0 Ha: at least one of the βj's is not 0
  1. Find the test statistic and P-value.                                                                                                                                              
  2. Make a decision to reject or not reject the null hypothesis.                                                                    
  3. Summarize the results in the context of the problem.

Solutions

Expert Solution

Given the ANOVA table we can easily calculate the value of the F-statistic:

F = MSM/MSE

F = 9743996/434927 = 22.40375

The corresponding p-value of the F-statistic with 3,4 degrees of freedon is 0.006

Since, the p-value is less than 0.05 we reject the null hypothesis at 5% level of significance and conclude that atleast one of the betas is not equal to zero.

This means that the decision of the researcher to include more than one variable such as previous work experience and education to the linear model to create a multiple regression linear model is valid.

In order to obtain the individual significance of the regression coeffcients we will calculate calculate the critical value of t for 3 degrees of freedom which is 4.177

Comparing the critical value with the indicidual values of the t-statistic we get that the regression coefficient of the intercept and employment are significant while the regression coefficients of experience and education may not be significant at 5% level of significance. So we may reject the claims of the researcher at 5% level of significance.


Related Solutions

Question 4 A simple linear regression model was used in order to predict y, duration of...
Question 4 A simple linear regression model was used in order to predict y, duration of relief from allergy, from x, dosage of medication. A total of n=10 subjects were given varying doses, and their recovery times noted. Here is the R output. summary(lmod4) ## ## Call: ## lm(formula = y ~ x) ## ## Residuals: ##     Min      1Q Median      3Q     Max ## -3.6180 -1.9901 -0.4798 2.2048 3.7385 ## ## Coefficients: ##             Estimate Std. Error t value Pr(>|t|)    ## (Intercept)...
Data was collected from 40 employees to develop a regression model to predict the employee’s annual...
Data was collected from 40 employees to develop a regression model to predict the employee’s annual salary using their years with the company (Years), their starting salary in thousands (Starting), and their Gender (Male = 0, Female = 1). The level of significance is .01. The results from Excel regression analysis are shown below: SUMMARY OUTPUT Regression Statistics Multiple R 0.718714957 R Square 0.516551189 Adjusted R Square 0.476263788 Standard Error 10615.63461 Observations 40 ANOVA Df SS MS F Significance F...
Construct a model to predict the Savings based on the following predictors: Education Level, Salary, Cars,...
Construct a model to predict the Savings based on the following predictors: Education Level, Salary, Cars, Home, and SC Index. The dataset is below . Decide if any predictors should be removed using the p-value criterion and rerun the regression model. Compare the adjusted coefficients of determination. Couple Educ Level Salary Cars Home SC Index Savings 1 4 90 19 83 3 289 2 2 95 35 134 3 1130 3 2 99 46 110 5 583 4 3 130...
A linear regression model is generated to predict the daily increase in covid 19 cases in...
A linear regression model is generated to predict the daily increase in covid 19 cases in Mumbai . y=2 X1 + 10 X2 + b(100) where Y= number of new cases daily, X1= no of incoming passenger flights in Mumbai, and X2= no of passenger train arriving in Mumbai; b= constant or predicted daily increase due to community transmission ,even if no passenger flight or trains are allowed into the city . Assume a1 and a2 are regression coefficeint for...
            Develop a simple linear regression model to predict the price of a house based upon...
            Develop a simple linear regression model to predict the price of a house based upon the living area (square feet) using a 95% level of confidence.             Write the reqression equation             Discuss the statistical significance of the model as a whole using the appropriate regression statistic at a 95% level of confidence.              Discuss the statistical significance of the coefficient for the independent variable using the appropriate regression statistic at a 95% level of confidence.             Interpret the...
Use the least squares method to fit a simple linear model that relates the salary (dependent...
Use the least squares method to fit a simple linear model that relates the salary (dependent variable) to education (independent variable). a- What is your model? State the hypothesis that is to be tested, the decision rule, the test statistic, and your decision, using a level of significance of 5%. b – What percentage of the variation in salary has been explained by the regression? c – Provide a 95% confidence interval estimate for the true slope value. d -...
Develop a simple linear regression model to predict a person’s income (INCOME) based on their age...
Develop a simple linear regression model to predict a person’s income (INCOME) based on their age (AGE) using a 95% level of confidence. a. Write the regression equation. Discuss the statistical significance of the model as whole using the appropriate regression statistic at a 95% level of confidence. Discuss the statistical significance of the coefficient for the independent variable using the appropriate regression statistic at a 95% level of confidence. Interpret the coefficient for the independent variable. What percentage of...
1.Develop a multiple linear regression model to predict the price of a house using the square...
1.Develop a multiple linear regression model to predict the price of a house using the square feet of living area, number of bedrooms, and number of bathrooms as the predictor variables     Write the reqression equation.      Discuss the statistical significance of the model as a whole using the appropriate regression statistic at a 95% level of confidence. Discuss the statistical significance of the coefficient for each independent variable using the appropriate regression statistics at a 95% level of confidence....
The following linear regression model can be used to predict ticket sales at a popular water...
The following linear regression model can be used to predict ticket sales at a popular water park (the correlation is significant). Ticket sales per hour = -631.25 + 11.25(current temperature in °F) Choose the statement that best reflects the meaning of the slope in this context. Group of answer choices The slope is slippery. The slope tells us that a one degree increase in temperature is associated with an average increase in ticket sales of 11.25 tickets. The slope tells...
I have conducted a linear regression model to predict student scores on an exam based on...
I have conducted a linear regression model to predict student scores on an exam based on the number of hours they studied. I get a coefficient (slope) of +2.5 for the variable of hours studied. The pvalue for this coefficient is 0.45 and the 95% confidence interval is [-2.5, +7]. Which of the following conclusions CANNOT be drawn from these results? At an alpha of 0.05, we can say that the effect of hours studied on exam score is significant...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT