Working on a paper for a statistics class. I have data that I have run through a program called Wizard – I have excel but do not have the statistical add ons. I am wondering if I did my calculations correctly. I attached the raw data – LWOT % and working Nurses. The paper needs to determine the appropriate statistical tool to test the hypothesis, with a 95% confidence level. The hypothesis is as follows: The null hypothesis is that the hospital staffs enough nurses, and the staffing numbers do not contribute to the LWOT rate. The alternate hypothesis is that the hospital does not employ enough nurses to reduce the LWOT rate. Here is what I have come up with so far: Correlation – -0.767 Covariance – -0.016 R2 – 0.589 T-test p < 0.001 Just wondering if I did this correctly and if I performed the correct tests.