Review the data in Table 1. It covers the median income for the top 25 Georgia c

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

Navigate

• Browse (All)
• Browse R
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.