The file S02_07.xlsx includes data on 204 employees at the (fictional) company Beta Technologies.
a. Create a table of correlations between the variables Age, Prior Experience, Beta Experience, Education, and Annual Salary. Which of the first four of these variables is most highly correlated (in a positive direction) with Annual Salary?
b. Create scatter plots of Annual Salary (Y axis) versus each of Age, Prior Experience, Beta Experience, and Education.
c. For the variable from part a most highly correlated with Annual Salary, create a (linear) trend line in its scatter plot with the corresponding equation shown in the chart. What does this equation imply about the relationship between the two variables? Be specific.