You must use spreadsheet software (e.g. Excel) for this problem. 1….
Question Answered step-by-step You must use spreadsheet software (e.g. Excel) for this problem. 1…. 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.Image transcription textX JX A B C D E F G 1 Percentage ofpeople without health insurance foreach state and Wash 15.2… Show more… Show more Math Statistics and Probability MAT 120 Share QuestionEmailCopy link Comments (0)


