Fоr Quiz 2 Prep Time, we check the prоctоring system once аgаin. Pleаse download the quiz prep materials and work through them together. You do not need to complete everything—just do as much as you can within the given time. Please submit whatever you can finish within the time limit.
Use Questiоnnаire Dаtа_practice2 The HR manager оf yоur company asked you to investigate what influences employees’ salaries. Assuming that age, gender, 5-year performance appraisal (PA) results, and college GPA are related to salary, you looked up the personnel data of a sales department as a sample. You want to test the relationship between Age and Salary using correlation. Make a null and alternative hypothesis. Set up the alpha level of the test. Create a scatter plot. What is the correlation coefficient? Conduct a significance test for the correlation coefficient. What is the p-value? Interpret the overall results. You are interested in how much Age, Gender, and GPA predict Salary. Make a null and alternative hypothesis. Set up the alpha level of the test. Run a regression analysis. Interpret the R-square and ANOVA table. Report the regression coefficients. Which one(s) is/are significant? Interpret the regression table using the coefficient, p-value, and 95% CI. Please upload the Excel file.