Review the data in Table 1 It covers the median income for t

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

Solution