Question: Please solve question 8 only, thank Please solve question 8 only, thank Please solve question 8 only, thank Robert is a Human Resource manager. He



Please solve question 8 only, thank
Please solve question 8 only, thank
Please solve question 8 only, thank

Robert is a Human Resource manager. He wants $20,400$24,150$23,850$29,700$21,600$24,450$28,050$100,000$49,000$16,350$70,000$11,250$12,750$13,500$13,500$13,500$15,750$16,500$44,100$20,550$10,200$21,750096122262288784128861631912815128121516151216 1. Identify which is the dependent variable and independent variables. 2. Apply the multiple regression tool using Excel. Copy and paste your result below. Use picture format when pasting. 3. What is the value of R squared? Referring to this case, what does it indicate? 4. Using the result above, write the equation for the multiple linear regression. 5. Based on your answer in Question 2(d), interpret the equation that you wrote. 6. Which one of the variables has the largest impact on the current salary? Why? 7. By looking at the p-value for the F-test (ANOVA), at 5% significance level, do you reject or fail to reject null hypothesis? 8. Based on the results, by looking at the p-values, write the prediction value for each independent variable. For each one increase in the CurSal, how much is the increase other factors? What can you conclude
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
