Question

The median incomes of females in each state of the United States, including the District of Columbia and Puerto Rico, are given in following table ("Median income of," 2013). $31,862 $40,550 $36,048 $30,752 $41,817 $40,236 $47,476 $40,500 $60,332 $33,823 $35,438 $37,242 $31,238 $39,150 $34,023 $33,745 $33,269 $32,684 $31,844 $34,599 $48,748 $46,185 $36,931 $40,416 $29,548 $33,865 $31,067 $33,424 $35,484 $41,021 $47,155 $32,316 $42,113 $33,459 $32,462 $35,746 $31,274 $36,027 $37,089 $22,117 $41,412 $31,330 $31,329 $33,184 $35,301 $32,843 $38,177 $40,969 $40,993 $29,688 $35,890 $34,381 Create a histogram and relative frequency histogram for the data in the table using 7 class intervals and answer the following questions:

Answer 1

The median incomes of females in each state of the United States, including the District ofColumbia and Puerto Rico, are given in following table ("Median income of," 2013).

There are 52 observations.

We have to construct histogram of the data.

First make classes and find corresponding frequency and then construct histogram.

Smallest number = 22117

Largest number = 60332

We can make the classes of width 6000.

Next step we have to find frequency for each class,

Frequency is the number of observation fall within class limits.

class	frequency
22000-28000	1
28000-34000	21
34000-40000	15
40000-46000	10
46000-52000	4
52000-58000	0
58000-64000	1
total	52

Now we can construct histogram in excel.

steps :

ENTER data into excel sheet --> Select all the range --> Insert --> COlumn --> 2-D column --> Select first option --> ok --> right click on bars --> Format data series --> Adjust gap width to 0% --> close

Now we have to make relative frequency histogram.

Relative frequency = frequency / total frequency

class	relative frequency
22000-28000	0.019230769
28000-34000	0.403846154
34000-40000	0.288461538
40000-46000	0.192307692
46000-52000	0.076923077
52000-58000	0
58000-64000	0.019230769
total	1