Using the file below calculate the variance and standard


Please complete in EXCEL.

a. Using the file below, calculate the variance and standard deviation of Age, LOS, and Charges by using the formula. DO NOT USE FUNCTION for this problem.

b. Based on the mean and standard deviation for LOS, generate a frequency distribution in terms of one standard deviation units around the mean.

c. Develop an Excel chart to show the frequency distribution generated in (b).

Attachment:- file.xls

Solution Preview :

Prepared by a verified Expert
Basic Statistics: Using the file below calculate the variance and standard
Reference No:- TGS01133925

Now Priced at $15 (50% Discount)

Recommended (93%)

Rated (4.5/5)