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 1. Create a correlation matrix using the following columns in a worksheet called Correlation Matrix. Insert 3 blank lines at the beginning of the worksheet and answer the questions below. Be sure to number your answers. a. Q1: The longer one stays at the company the higher he/she is satisfied with the company. Does your data support this statement? Explain by citing numbers from the correlation matrix. b. Q2: Explain the relationship between number_project and left. Cite numbers from the correlation matrix to support your statement. c. Q3: 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. 22. Conduct Multiple Regression using the following independent variables to predict satisfaction_level. Insert 4 blank lines at the beginning of the worksheet and answer the following questions: a. Q1: What is the most influential independent variable for satisfaction_level? Explain and provide proof by citing numbers from the regression result. b. Q2: 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. Q3: Does the regression line fit the data well? Please explain and provide your proof by citing numbers from the regression result. d. Q4: 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!