Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 concludeStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started