Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Below (in column A) are the income per capita for a sample of 50 different households. Use Excel to draw a histogram on the frequency
Below (in column A) are the income per capita for a sample of 50 different households. | |||||||||||||
Use Excel to draw a histogram on the frequency distribution of per capita income, | |||||||||||||
and provide an appropriate label for each of the horizontal and vertical axes. | |||||||||||||
Your first histgram bin or class (used in excel) could be 18000<22000 (You may use other consistent settings as well.) | |||||||||||||
Place the histogram within the highlighted box below. | |||||||||||||
sub | Per Capita Income | ||||||||||||
1 | 21,500 | ||||||||||||
2 | 25,771 | ||||||||||||
3 | 23,152 | ||||||||||||
4 | 20,393 | ||||||||||||
5 | 27,579 | ||||||||||||
6 | 28,821 | ||||||||||||
7 | 37,700 | ||||||||||||
8 | 29,932 | ||||||||||||
9 | 37,325 | ||||||||||||
10 | 25,922 | ||||||||||||
11 | 25,106 | ||||||||||||
12 | 26,210 | ||||||||||||
13 | 21,080 | ||||||||||||
14 | 28,976 | ||||||||||||
15 | 24,302 | ||||||||||||
16 | 24,007 | ||||||||||||
17 | 25,049 | ||||||||||||
18 | 21,551 | ||||||||||||
19 | 21,385 | ||||||||||||
20 | 23,002 | ||||||||||||
21 | 30,023 | ||||||||||||
22 | 32,902 | ||||||||||||
23 | 25,979 | ||||||||||||
24 | 27,667 | ||||||||||||
25 | 18,998 | ||||||||||||
26 | 24,786 | ||||||||||||
27 | 27,360 | ||||||||||||
28 | 29,219 | ||||||||||||
29 | 33,953 | ||||||||||||
30 | 20,008 | ||||||||||||
31 | 31,679 | ||||||||||||
32 | 24,122 | ||||||||||||
33 | 21,708 | ||||||||||||
34 | 25,239 | ||||||||||||
35 | 21,056 | ||||||||||||
36 | 24,775 | ||||||||||||
37 | 26,889 | ||||||||||||
38 | 26,924 | ||||||||||||
39 | 21,387 | ||||||||||||
40 | 22,201 | ||||||||||||
41 | 23,615 | ||||||||||||
42 | 25,028 | ||||||||||||
43 | 21,096 | ||||||||||||
44 | 24,217 | ||||||||||||
45 | 27,489 | ||||||||||||
46 | 28,066 | ||||||||||||
47 | 19,373 | ||||||||||||
48 | 25,184 | ||||||||||||
49 | 24,447 | ||||||||||||
50 | 20,247 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
The histogram is he frequency distribution is Per Capita Income cumulative lower upper m...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started