You must use spreadsheet software (e.g. Excel) for this problem.

Percentage of people without health insurance for each state and Washington DC 15.2 9.4 25.4 21.9 20.8 15.5 18.9 13.7 13.5 16.5 12.1 14 9.3 13.3 22.9 17.9 24.5 8.8 20.9 11.6 11.8 13.8 7.1 14 10 17.4 14.6 18.9 21.2 10.5 10.4 12.3 17.9 6.6 10.2 18.8 27.7 12.3 10.5 19.6 12.2 15.9 13.3 17.2 8.9 15.6 9.2 11.5 10.1 11.8 11.8

1. For each state and Washington DC, the percentage of people without health insurance was determined. Given the data set (The file is located in the main Experience folder) create the following using spreadsheet software. Refer to the model/methodology for the desired format. Make sure to use 5-20 classes with a "nice" class width when creating the distribution tables. Make sure to label axes in both graphs.

a. Grouped frequency distribution (table)

b. Grouped relative frequency distribution (table)

c. frequency histogram (graph)

d. relative frequency histogram (graph)