What percentage of the nursing home residents had at least four falls in the last 24 months? Put the answer in cell B17.

In column A type your data, but observe that your data has five 0’s, four 1’s, two 2’s, two 3’s, two 4’s, one 6, two 8’s, one 10 and one 11. Column B will be the frequency column. Type Falls in cell A1 and type Frequency in cell B1. Then type 0 in cell A2 and 5 in cell B2. Type 1 in cell A3 and 4 in cell B3. Type 2 in cell A4 and 2 in cell B4. Type 3 in cell A5 and 2 in cell B5. Type 4 in cell A6 and 2 in cell B6. Type 6 in cell A7 and 1 in cell B7. Type 8 in cell A8 and 2 in cell B8. Type 10 in cell A9 and 1 in cell B9. Type 11 in cell A10 and 1 in cell B10.

1. How many residents had at least two falls in the last 24 months? Put the answer in cell B15.
2. What percentage of the nursing home residents had at most eight falls in the last 24 months? Put the answer in cell B16.
3. What percentage of the nursing home residents had at least four falls in the last 24 months? Put the answer in cell B17.
4. What is the mode of this sample data. Put the answer in cell B18.