Review the data in Table 1. It covers the median income for the top 25 Georgia c
ID: 2486327 • Letter: R
Question
Review the data in Table 1. It covers the median income for the top 25 Georgia counties. (50 points)
1-If John earns $62,591 annually in Henry County what would change for him if he moves to Cherokee county?
2- You want to demonstrate this data, how would you categorize it?
3- If you want to show the number of counties with a median income within a certain range how do you identify those ranges? How many bins you will choose? What kind of representation you will choose?
4- Use Excel to draw the graph and submit it as part of your work.
5-Consider the Median Income as a variable, report Mean, Median, STD, Variance and Quartiles for it.
6- Would you identify the counties which are between 25 percentile and 75 percentile (second and third quartiles)?
Table 1
Rank
County
Median
1
Forsyth
$84,567
2
Fayette
$77,491
3
Oconee
$74,630
4
Columbia
$68,986
5
Cherokee
$66,972
6
Henry
$63,892
7
Paulding
$63,663
8
Harris
$63,351
9
Cobb
$62,893
10
Coweta
$59,848
11
Gwinnett
$58,732
12
Bryan
$58,092
13
Lee
$57,044
14
Fulton
$56,313
15
Pike
$55,674
16
Effingham
$54,678
17
Monroe
$53,805
18
Dawson
$53,215
19
Rockdale
$51,265
20
Douglas
$50,798
21
Pickens
$50,798
22
Houston
$50,733
23
Jackson
$50,591
24
Walton
$50,321
25
Newton
$50,137
26
DeKalb
$50,092
Table 1
Rank
County
Median
1
Forsyth
$84,567
2
Fayette
$77,491
3
Oconee
$74,630
4
Columbia
$68,986
5
Cherokee
$66,972
6
Henry
$63,892
7
Paulding
$63,663
8
Harris
$63,351
9
Cobb
$62,893
10
Coweta
$59,848
11
Gwinnett
$58,732
12
Bryan
$58,092
13
Lee
$57,044
14
Fulton
$56,313
15
Pike
$55,674
16
Effingham
$54,678
17
Monroe
$53,805
18
Dawson
$53,215
19
Rockdale
$51,265
20
Douglas
$50,798
21
Pickens
$50,798
22
Houston
$50,733
23
Jackson
$50,591
24
Walton
$50,321
25
Newton
$50,137
26
DeKalb
$50,092
Explanation / Answer
Review the data in Table 1. It covers the median income for the top 25 Georgia c
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.