Healthcare and a journal tutorial calledIntro to Regression video part 2) with another called Multiple Regression Overview.See the excel file entitledNurses (student), which contains several variables on RNs and LPNs fora single year by state.
1a. Generate a correlation matrix, paying close attention to the interaction between the # of RNs and annual salaries of RNs and theannual salaries of LPNs. Are the signs consistent with the theory presented in the “Findings”box on p. 110?
1b.Estimate asample, multiple regression equationusing the # of RNs as the left-hand side variable and 1) annual salaries of RNs and 2) annual salaries of LPNs on the right-hand side. Arethe signs on the sample slope coefficients, consistent withthe theory presented in the “Findings”box on p. 110?
1c. Try the regression again using hourly wages for each on the right-hand side. Do you see any difference in the signs on the coefficients?
1d. What are some things you would do differently in this exercise if more time and resources were available?
1e. How would you use these results in a practical manner as a hospital manager, health care professional, etc.?