Question

In: Statistics and Probability

Question 7. The results of the correlation analysis in the Correlation Matrix these variables are depicted...

Question 7. The results of the correlation analysis in the Correlation Matrix these variables are depicted below. Use information in the table to discuss the strength and nature of relationship between the four variables.

Training

Performance

Years of Service

Annual Salary

Training

1

Performance

0.016

1

Years of Service

0.377

-0.268

1

Annual Salary

0.597

0.709

0.286

1

Question 9. Results of the three goodness of test measures is given in the table below:

Goodness of Fit Tests

R Square

0.93

ANOVA

F

Sig F

25.431

0.0008

Coefficients

St.Error

t Stat

P-value

Intercept

-35.25

7.05

-4.996

0.002

Training

2.47

0.64

3.851

0.008

Performance

8.20

1.20

6.824

0.000

Years of Service

1.1

0.42

2.592

0.041

a) Do the independent variables explain a reasonable amount of variation in the dependent variable? Justify.

  

b) Can any of the independent variables be dropped from the model? Why or why not?

c) Use information in the table to comment on the validity of the model.

Question 10. What recommendation would you provide to Fatima for building the new compensation package?

Question 7. The results of the correlation analysis in the Correlation Matrix these variables are depicted below. Use information in the table to discuss the strength and nature of relationship between the four variables.

Training

Performance

Years of Service

Annual Salary

Training

1

Performance

0.016

1

Years of Service

0.377

-0.268

1

Annual Salary

0.597

0.709

0.286

1

Solutions

Expert Solution

Problem statement:Test results of a regression model are presented to us. Based on the information present in the tables we have to answer the following questions.

Given: A linear regression model is built to obtain the relationship between annual salary and other independent variables (training, years of service and performance). The model results are presented to us .We have to examine these results and comment on the regression model.

Solution:

(7): Correlation matrix presents the coefficent of correlation between each pair of variables present in the data. Upon close study of the matrix, we observe that performance and annual salary are highly and positively correlated (0.709). Also, we observe that among the independent variables (training, years of service and performance) we do not observe any strong correlation (assuming corrleation value extreme of 0.7 to be highly correlated- Note that decision on the strength of correlation is subjective). We observe that annual salary and training to be positively correlated, but not highly correlated (nearly 0.6). Years of service and performance seems to have a negative association, albeit the association is not too strong (-0.268).

(9a): Yes, independent variables explain a significant amount of variation in dependent varaiable. We can conclude this by referring to the ANOVA table presented in the information.Generally, if p-value associated with F-statistic is less than 0.05, we can conclude that independent variables explain a significant amount of variation in dependent varaiable.

Conceptually, null hypothesis associated with F-statistic is that regression coefficents for independent variables are zero while alternate hypthesis is regression cofficients for independent variables are significantly different from zero. Basically, null hypothesis is- the regression model built using independent variables have impact in explaining variation in dependent variable compared to model without independent variables. When we obtain p-value associated with F-statistic less than 0.05 (Significance level) we conclude that independent variables explain a significant amount of variation in dependent varaiable.

(9b):No, none of the independent variable can be dropped. We conclude that an independent variable can be dropped when the p-value associated with it is greater than 0.05 (generally assumed significance level). Since none of the independent variables have p-value greater than 0.05, we conclude that none of the variables could be dropped.

(9c): To validate this model, we have to refer to the R^2 in the model.R square associated with this model is 0.93.  R squared provides the proportion of variation in dependent variable which is attributable to independent variables. A value of 0.93 for R-squared is a good value to validate the model.

Also since the t-statistic associated with all the independent variables have p-value lesser than 0.05, we can validate this regression model.

(10): Based on the regression model, our recommendations for new compensation package is that more importance to be given to the performance of the employees. In the compensation package, second most important variable based on the coefficent value is training. The least important variable to be considered is years of experience while deciding new compensation package.


Related Solutions

Examine the Correlation Matrix for the variables in the model presented in the table below. Correlations...
Examine the Correlation Matrix for the variables in the model presented in the table below. Correlations Life Purpose and Satisfaction gender subject's age depressed state of mind exercise Pearson Correlation Life Purpose and Satisfaction 1.000 .149 .051 -.661 .307 gender .149 1.000 -.020 -.074 .033 subject's age .051 -.020 1.000 .016 -.097 depressed state of mind -.661 -.074 .016 1.000 -.211 exercise .307 .033 -.097 -.211 1.000 Sig. (1-tailed) Life Purpose and Satisfaction . .001 .147 .000 .000 gender .001...
What are the differences between results that demonstrate a correlation between two variables and results where a regression is run using two variables?
What are the differences between results that demonstrate a correlation between two variables and results where a regression is run using two variables? Think about your future clinical role and provide a clinical example of variables that you may want a correlation analysis run and explain. Think about your future clinical role and provide a clinical example of variables that you may want a regression analysis run and explain.
Statistical processing of static test results. Notion of dispersion and the correlation analysis.
Statistical processing of static test results. Notion of dispersion and the correlation analysis.
Regression and Correlation Analysis Use the dependent variable (labeled Y) and one of the independent variables...
Regression and Correlation Analysis Use the dependent variable (labeled Y) and one of the independent variables (labeled X1, X2, and X3) in the data file. Select and use one independent variable throughout this analysis. Use Excel to perform the regression and correlation analysis to answer the following. Generate a scatterplot for the specified dependent variable (Y) and the selected independent variable (X), including the graph of the "best fit" line. Interpret. Determine the equation of the "best fit" line, which...
Using excel compute correlation coefficients, correlation matrix and test the significance of the correlation coefficients between...
Using excel compute correlation coefficients, correlation matrix and test the significance of the correlation coefficients between sales with price,  sales with advertisments using alpha 0.05 Sales Price Adver 19.98 14.10 15.19 19.98 18.65 15.19 19.98 18.65 13.87 19.98 18.65 12.83 19.98 18.65 13.16 19.98 18.65 15.19 19.98 18.65 13.92 20.10 18.73 14.42 20.12 18.75 13.83 20.13 18.75 14.50 20.14 18.75 13.87 20.12 18.75 13.64 20.12 13.87 14.31 20.13 14.27 13.85 20.14 18.76 14.20 20.14 18.77 13.64 20.13 13.87 14.33 20.13 14.14...
1. If there is no correlation between two variables, what is the value of the correlation...
1. If there is no correlation between two variables, what is the value of the correlation coefficient? to. -1 b. 0 c. 1 d. -0 2. In a scatter diagram, on which axis is the dependent variable always recorded? to. x axis b. y axis 3. What is the dependent and independent variable? • time • quantities produced
Regression and correlation analysis both describe the strength of linear relationships between variables. Consider the concepts...
Regression and correlation analysis both describe the strength of linear relationships between variables. Consider the concepts of education and income. Many people would say these two variables are related in a linear fashion. As education increases, income usually increases (although not necessarily at the same rate). Can you think of two variables that are related in such a way that their relationship changes over their range of possible values (i.e., in a curvilinear fashion)? How would you analyze the relationship...
Post pairs of variables that exhibit positive correlation, negative correlation and no correlation. Could any of...
Post pairs of variables that exhibit positive correlation, negative correlation and no correlation. Could any of the proposed correlated variables be the result of causation? How could an experiment be designed to establish causation? Would it be ethical to do such an experiment? What percentage of the variation in the response variable do you think can be explained by the predictor variable? Do you think there are any lurking variables in your situation? Sample Student Response Positive Correlation: rain and...
Calculate the Pearson correlation and interpret the results.
The data below relates to income levels and expenses of foods in U.S dollars (00). Income (X) Expenditure (Y) 35 9 49 15 21 7 39 11 15 5 28 8 25 9                   Calculate the Pearson correlation and interpret the results.
perform IFE Matrix and analysis of Amazon perform EFE Matrix and analysis of Amazon
perform IFE Matrix and analysis of Amazon perform EFE Matrix and analysis of Amazon
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT