For the exercise, use the first 500 observations only. Using data for average hourly earnings only (ahe), describe the earnings distribution. Use summary statistics, such as the mean, median, variance, and skewness. Produce a frequency distribution ("histogram") using reasonable earnings class sizes
What will be an ideal response?
Answer:
ahe
Mean 19.79
Standard Error 0.51
Median 16.83
Mode 19.23
Standard Deviation 11.49
Sample Variance 131.98
Kurtosis 0.23
Skewness 0.96
Range 58.44
Minimum 2.14
Maximum 60.58
Sum 9897.45
Count 500.0
The mean is $19.79. The median ($16.83) is lower than the average, suggesting that the mean is being pulled up by individuals with fairly high average hourly earnings. This is confirmed by the skewness measure, which is positive, and therefore suggests a distribution with a long tail to the right. The variance is $2131.96, while the standard deviation is $11.49.
To generate the frequency distribution in Excel, you first have to settle on the number of class intervals. Once you have decided on these, then the minimum and maximum in the data suggests the class width. In Excel, you then define "bins" (the upper limits of the class intervals). Sturges's formula can be used to suggest the number of class intervals (1+3.31log(n) ), which would suggest about 9 intervals here. Instead I settled for 8 intervals with a class width of $8 — minimum wages in California are currently $8 and approximately the same in other U.S. states.
The table produces the absolute frequencies, and relative frequencies can be calculated in a straightforward way.
bins Frequency rel. freq.
8 50 0.1
16 187 0.374
24 115 0.23
32 68 0.136
40 38 0.076
48 33 0.066
56 8 0.016
66 1 0.002
More 0
Substitution of the relative frequencies into the histogram table then produces the following graph (after eliminating the gaps between the bars).
You might also like to view...
Explain how the largest sources of state tax revenues differs from the largest sources of federal tax revenues
What will be an ideal response?
Which of the following is a true statement about recent immigrants to the U.S.?
a. Approximately one-third of immigrants over 25 lack a high school diploma. b. Nearly half of immigrants are from various countries in Asia. c. Approximately two-thirds of immigrants are employed in high-tech jobs. d. Most immigrants have the education and skills of the existing U.S. population.
Which of the following contributes to economic? growth?
A) increase in environmental protection policies
B) increase in labor regulations restricting the hours of overtime allowed
C) increase in labor productivity
D) increase in consumer spending
A circular-flow diagram is a model that
a. helps to explain how participants in the economy interact with one another.
b. helps to explain how the economy is organized.
c. incorporates all aspects of the real economy.
d. Both (a) and (b) are correct.