The attached excel file reports data on the length of stay (LOS) for patients at a hospital. Use Excel built-in formulae to answer each of the following questions:
a. Plot a scatter diagram between two variables and briefly interpret your plot.
b. Provide the following descriptive statistics for the LOS: mean, median, mode, standard deviation, range.
c. Provide the following descriptive statistics for age: mean, median, mode, standard deviation, range.
d. Provide the following descriptive statistics for gender: mean, median, mode, standard deviation, range.
e. Find the coefficient of correlation between LOS and age of the patient. Interpret this value.
f. Find the coefficient of correlation between LOS and gender of the patient. Interpret this value.
Attachment:- Data.rar