ID LOS Charges 1 4 $2,426.48 2 8 $6,815.61 3 10 $7,596.68 4 5 $6,450.77 5 3 $3,542.79 6 2 $2,590.86 7 5 $5,082.83 8 6 $3,580.55 9 6 $11,045.79 10 14 $19,708.11 11 11 $8,953.38 12 5 $7,000.21 13 6 $5,330.24 14 3 $6,864.63 15 3 $4,318.13 16 7 $6,424.30 17 6 $5,184.53 18 3 $1,871.78 19 11 $11,179.97 20 2 $3,405.38 21 2 $1,731.73 22 2 $5,384.92 23 7 $5,216.91 24 4 $2,489.65 25 10 $8,244.25 26 6 $3,548.05 27 3 $4,713.26 28 6 $5,804.21 29 6 $2,945.22 30 1 $1,035.75 31 3 $17,005.45 32 3 $4,637.96 33 5 $17,480.97 34 5 $5,029.09 35 3 $3,078.99 36 2 $2,146.99 37 6 $5,482.93 38 1 $1,078.56 39 10 $9,931.21 40 2 $2,451.69 41 2 $2,834.68 42 2 $1,547.81 43 3 $1,876.70 44 2 $2,781.28 45 6 $6,460.59 46 4 $3,026.42 47 10 $14,769.92 48 7 $4,425.44 49 4 $5,151.52 50 1 $2,404.39 51 2 $5,019.86 52 9 $10,421.01 53 2 $4,860.83 54 3 $2,694.11 55 4 $2,421.63 56 2 $3,311.66 57 1 $1,596.91 58 5 $5,399.67 59 12 $17,605.59 60 7 $11,098.70 61 4 $3,674.03 62 4 $3,720.09 63 1 $2,472.64 64 7 $7,792.24 65 2 $3,489.88 66 4 $4,655.83 67 14 $10,242.50 68 1 $1,599.82 69 10 $6,015.34 70 2 $1,905.65 71 1 $707.70 72 2 $3,004.67 73 10 $18,290.04 74 3 $5,621.92 75 7 $5,547.71 76 2 $2,581.72 77 9 $7,024.64 78 3 $4,242.10 79 3 $4,286.90 80 2 $12,313.78 81 11 $8,217.27 82 16 $10,655.80 83 3 $3,620.78 84 5 $4,734.98 85 1 $1,820.41 86 8 $8,954.81 87 5 $4,177.90 88 2 $5,756.89 89 10 $12,919.48 90 9 $7,022.47 91 7 $6,823.60 92 4 $2,384.47 93 5 $3,169.19 94 2 $2,721.63 95 5 $3,034.14 96 3 $5,041.93 97 7 $8,118.92 98 9 $10,955.29 99 7 $5,363.25 100 5 $6,572.60 Use the LOS worksheet in data file Patients_Assignment1.xlsx, do the following assignments (30 points). 1. Use the =MIN(), =MAX(), and =FREQUENCY() functions, calculate the frequencies when separate LOS into 6 categories. 2. Using the result of 1, generate different chartscolumn, line, pie charts. Show these charts on the spreadsheet. 3. Generate a cumulative frequency for the variable LOS as well as percentage and cumulative percentage distributions.