Question: Using the Patients dataset (Excel) , scatter plot with patient's age on the x-axis and length of stay on the y-axis.Make sure that you fully
- Using thePatients dataset (Excel), scatter plot 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).
- Follow the directions in EG13.2 (Excel Guide) and linear trendline along with the linear regression equation and R-squared value.Interpret both the linear regression equation and the R-squared value.
- Now calculate the correlation coefficient and interpret it. What do you conclude about the relationship between a patient's age and length of stay?
- Showing yourwork is required, not just providing answers without showing how you arrived at them.
Excel Spreadsheet is here: https://www.dropbox.com/s/7rtpgja648uyez4/6.7%20Patients%20Dataset%202018.xlsx?dl=0
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
