1. Create a scatter plot (similar to Figure 13.5) with patient's age on the x-axis and length of stay on the y-axis. Make sure that you fully label this chart (title for the chart, x-axis, and y-axis).
2. Create a linear trend line along with the linear regression equation and R-squared value. Interpret both the linear regression equation and the R-squared value.
3. Now calculate the correlation coefficient and interpret it. What do you conclude about the relationship between a patient's age and length of stay?

Length of Stay 3 3 11 3 9 3 3 3 3 5 3 2 3 3 5 3 4 3 2 3 4 1 2 3 4 6 2 1 4 5 3 2 4 15 3 6 4 2 5 9 3 3 5 5 7 4 6 2 3 6 8 4 5 8 7 8 3 12 2 5 5 3 2 4 3 2 6 3 3 4 5 3 7 7 3 4 8 2 3 1 4 3 6 5 5 7 1 2 4 11 3 2 1 4 6 8 4 2 3 7 7 4 3 3 9 4 6 1 1 6 3 5 3 2 3 5 9 7 4 7 3 3 16 3 4 1 2 2 2 3 4 4 5 5 5 5 7 2

Age (years) 78 74 89 81 87 65 90 61 90 78 78 71 76 76 79 72 72 64 72 69 63 78 83 62 71 83 63 83 76 79 65 79 74 63 84 90 73 81 75 87 70 73 77 71 76 49 78 86 67 69 73 88 67 69 77 64 76 64 41 49 59 81 74 77 78 73 67 80 77 73 67 86 82 84 73 82 62 84 89 84 81 81 78 84 37 62 80 80 73 80 80 80 81 39 86 79 87 53 83 80 79 72 77 81 67 80 67 88 88 92 85 85 80 98 74 77 53 93 83 80 79 87 59 81 94 33 78 29 80 63 86 96 89 80 55 73 67 75

Can you this be done in excel?