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.

If John earns $62,591 annually in Henry County what would change for him if he moves to Cherokee county?

You want to demonstrate this data, how would you categorize it?

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?

Use Excel to draw the graph and submit it as part of your work.

Consider the Median Income as a variable, report Mean, Median, STD, Variance and Quartiles for it.

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.