A3 fie Month A B D E F 1 2 2 Avg. Monthly 3 Month Numerator Denominator LOS Median 4 7/1/2019 83738 954 87.77568 5 8/1/2019 87967 825 106.6267 6 9/1/2019 66989 857 78.16686 7 10/1/2019 78999 877 90.07868 8 11/1/2019 57756 720 80.21667 9 12/1/2019 72988 889 82.10124 10 1/1/2020 58380 774 75.42636 11 2/1/2020 68077 974 69.89425 12 3/1/2020 62286 705 88.34894 13 4/1/2020 76786 770 99.72208 14 5/1/2020 70648 986 71.65112 15 6/1/2020 856 12 71.33333 16 7/1/2020 0 ON/a 17 8/1/2020 54895 550 99.80909 18 In column E, write a formula that calculates the median of column D. In your formula, you should reference the named range you created in step 2. You will need to use an array formula to calculate the median without #N/A values