You must use spreadsheet software (e.g. Excel) for this problem. 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) Submit the completed spreadsheet as a .xls or .xlsx file.

X JX A B C D E F G 1 Percentage of people without health insurance for each state and Wash 15.2 9.4 4 25.4 5 21.9 6 20.8 15.5 S 18.9 9 13.7 10 13.5 11 16.5 12 12.1 13 14 14 9.3 15 13.3 16 22.9 17 17.9 18 24.5 19 8.8 20.9 21 11.6 11.8 23 13.8 24 7.1 25 14 26 10 27 17.4 28 14.6 29 18.9 21.2