Usetheinformationinthetablethatfollows,createanExcelspreadsheettocalculatetheALOS,median LOS, and range for Community Nursing Center. The discharge date is June 2, 2019. Round the ALOS to one decimal place.

Admission date LOS

1/2/2019 151

1/10/2019 143

2/8/2019 114

2/10/2019 112

2/26/2019 96

3/1/2019 93

3/6/2019 88

3/12/2019 82

3/15/2019 79

4/1/2019 62

4/15/2019 48

5/3/2019 30

5/5/2019 28

5/6/2019 27

5/18/2019 15