Question: Data Analysis 1 . Create a correlation matrix using the following columns in a worksheet called Correlation Matrix. Insert 3 blank lines at the beginning
Data Analysis Create a correlation matrix using the following columns in a worksheet called Correlation Matrix. Insert blank lines at the beginning of the worksheet and answer the questions below. Be sure to number your answers. a Q: The longer one stays at the company the higher heshe is satisfied with the company. Does your data support this statement? Explain by citing numbers from the correlation matrix. b Q: Explain the relationship between numberproject and left. Cite numbers from the correlation matrix to support your statement. c Q: What are the top two variables relating to an employees decision to leave the company? Make sure you also explain the relationship of the variables with left. Conduct Multiple Regression using the following independent variables to predict satisfactionlevel. Insert blank lines at the beginning of the worksheet and answer the following questions: a Q: What is the most influential independent variable for satisfactionlevel? Explain and provide proof by citing numbers from the regression result. b Q: Is the regression equation valid? Explain and provide your proof by citing numbers from the regression result. Hint: Check the ANOVA result produced by Regression c Q: Does the regression line fit the data well? Please explain and provide your proof by citing numbers from the regression result. d Q: What is the implication if a regression line fits or doesnt fit the data well?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
