Question

1. Please use Excel. For each state and Washington DC, the percentage of people without health insurance was determined. Given the data set below create the following using spreadsheet software. Use 5-20 classes with a "nice" class width when creating the distribution tables.

a. Grouped frequency distribution (table)

b. Grouped relative frequency distribution (table)

c. frequency histogram (graph)

d. relative frequency histogram (graph)

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, 21.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

2. A survey of 50 college students was conducted to determine how much weekly income they earned from employment. Using the data set below, complete the following.

a. Find the 5 number summary of the data set.

Min=

Q1=

Median=

Q3=

Max=

b. Create a box-plot for the data set using any software.

c. Identify any outliers. List the individual numbers that are outliers for this data set. If there are multiple outliers, separate them by commas.

d. Give a possible explanation as to why the individual (or individuals) from part c might have a number (or numbers) that are so high (or so low).

e. Interpret yourself as a percentile in the data set. First estimate your weekly income from employment (If you are not employed then use 0). Then find the percentile for your income using the sample data below. Then interpret the percentile using the definition and writing a complete sentence

Amount of money earned weekly from employment (Enter 0 if not employed)

0, 244, 1277, 83, 719, 479, 375, 0, 0,671, 262, 521, 567, 159, 0, 0, 347, 203, 454, 95, 0, 476, 310, 0, 367, 82, 331, 149, 67, 736, 635, 100, 527, 547, 316, 579, 281, 0, 389, 300, 0, 650, 0, 188, 0, 289, 628, 403, 0, 181

Answer 1

Answer:

1.

a) & b)

c)

d)