• For each of the five variables, process, organize, present and summarize the data. Analyze each variable by itself using graphical and numerical techniques of summarization

Aniah84
data.xls

Worksheet 1

Location Income HH Size Years Resid. Credit Balance C7-T
Urban $70,026 6 17.1 $6,360 f
Rural $70,009 3 10.8 $5,002
Suburban $69,988 4 2.8 $5,399
Suburban $70,015 5 16.7 $6,785
Rural $70,021 3 8.5 $5,923
Urban $69,986 5 14.3 $5,380
Rural $69,968 5 18.9 $4,219
Urban $70,006 5 12.5 $6,422
Suburban $69,997 -1 11.9 $3,549
Urban $69,991 6 17.3 $5,510
Urban $70,015 6 13.3 $6,903
Urban $69,975 6 19.8 $5,345
Rural $69,996 4 16.0 $6,020
Rural $70,012 6 12.7 $6,580
Urban $70,003 4 21.9 $6,206
Suburban $70,010 2 10.6 $5,843
Urban $70,004 7 9.5 $6,185
Urban $69,987 1 8.7 $4,022
Rural $70,034 6 24.3 $7,483
Urban $69,985 0 5.8 $3,543
Suburban $70,025 4 13.2 $6,101
Urban $70,023 5 22.7 $6,734
Suburban $69,986 4 19.7 $5,328
Rural $70,034 8 23.1 $8,960
Urban $69,979 3 9.6 $4,598
Suburban $69,991 4 10.9 $5,063
Rural $69,985 4 5.0 $4,225
Urban $70,013 4 13.6 $5,467
Urban $70,004 6 10.5 $6,457
Suburban $69,987 2 2.5 $4,887
Rural $70,011 4 6.1 $5,976
Urban $70,013 4 13.1 $5,956
Urban $70,019 6 15.5 $6,501
Urban $69,995 5 20.5 $5,787
Urban $69,957 6 21.3 $4,961
Urban $70,002 5 19.3 $6,452
Suburban $70,008 7 18.1 $7,067
Urban $70,001 5 17.2 $5,392
Suburban $70,002 5 19.2 $5,691
Rural $69,997 4 17.1 $4,996
Urban $70,023 1 9.8 $5,497
Suburban $70,008 4 13.0 $5,627
Suburban $69,989 6 16.9 $5,250
Rural $70,010 3 4.8 $4,965
Urban $69,966 5 13.7 $5,428
Suburban $69,998 4 19.5 $5,906
Rural $70,024 4 19.5 $6,492
Rural $70,024 4 9.7 $6,489
Suburban $70,005 6 13.6 $5,985
Suburban $70,026 4 11.4 $5,918
Urban $69,999 8 14.2 $6,143
Rural $70,009 1 7.5 $4,728
Suburban $70,020 6 13.5 $6,729
Suburban $69,993 1 8.2 $3,774
Rural $69,994 2 12.2 $4,828
Urban $70,015 7 20.6 $7,035
Rural $70,024 2 8.6 $5,688
Urban $69,971 3 8.0 $4,362
Suburban $69,998 8 23.5 $6,546
Urban $70,004 5 9.0 $6,156
Urban $70,003 4 13.6 $5,438
Urban $70,021 5 10.1 $5,678
Rural $70,007 5 7.7 $5,927
Rural $70,004 8 17.9 $6,896
Urban $69,997 2 6.6 $4,577
Suburban $69,998 4 17.3 $5,824
Urban $69,994 1 11.7 $4,187
Urban $70,002 8 14.2 $7,101
Rural $70,026 4 19.8 $6,569
Urban $69,993 3 10.9 $4,867
Suburban $70,007 5 2.7 $5,523
Urban $69,979 3 13.5 $4,265
Suburban $70,013 6 12.3 $6,674
Rural $70,021 4 15.2 $6,953
Urban $69,973 5 16.5 $4,919
Suburban $69,973 3 19.4 $4,304
Rural $69,990 4 20.3 $5,258
Urban $70,026 5 4.6 $6,248
Urban $69,999 3 17.0 $4,534
Suburban $70,021 7 19.6 $7,281
Rural $69,987 7 19.2 $6,072
Urban $69,996 4 17.1 $5,143
Urban $70,016 6 23.2 $6,433
Urban $69,973 2 12.5 $4,249
Urban $69,997 5 21.9 $5,369
Urban $70,022 5 13.2 $6,340
Suburban $70,001 3 12.7 $5,205
Urban $69,995 6 21.5 $6,549
Suburban $70,021 5 20.7 $6,761
Rural $70,008 3 8.1 $5,313
Urban $69,998 4 19.4 $5,605
Suburban $70,008 3 19.0 $4,618
Suburban $69,988 5 12.7 $4,985
Rural $69,984 4 13.3 $5,391
Urban $70,006 3 11.6 $5,313
Suburban $70,029 6 20.3 $6,871
Rural $69,988 3 9.9 $4,496
Rural $70,009 7 21.6 $6,672
Suburban $69,991 3 10.7 $5,379
Suburban $69,978 5 18.2 $5,206
Urban $69,975 3 6.9 $3,107
Rural $70,001 7 19.8 $6,300
Suburban $69,995 7 23.0 $6,121
Suburban $69,994 2 13.0 $4,934
Rural $69,972 4 6.6 $4,365
Urban $69,977 3 22.8 $4,149
Rural $70,003 2 12.4 $4,297
Urban $69,980 4 21.2 $4,708
Suburban $69,982 0 13.1 $3,959
Urban $70,015 4 16.7 $6,828
Urban $69,981 5 17.2 $4,805
Urban $70,000 7 8.1 $6,194
Rural $70,014 4 6.4 $5,955
Rural $70,003 3 13.3 $5,589
Urban $70,006 6 18.6 $6,143
Suburban $70,013 3 18.4 $5,943
Urban $70,003 3 8.7 $5,222
Urban $69,983 4 16.0 $5,030
Rural $69,996 4 17.4 $5,396
Urban $70,030 2 4.8 $5,444
Suburban $69,992 5 15.6 $5,327
Urban $70,001 5 23.5 $6,300
Suburban $69,992 5 17.2 $5,015
Rural $69,996 3 1.4 $5,067
Urban $70,002 6 12.0 $5,573
Suburban $69,999 6 23.1 $6,095
Rural $69,993 3 24.6 $4,829
Urban $69,985 0 6.1 $3,270
Urban $69,995 4 18.0 $5,435
Suburban $69,984 3 13.2 $4,901
Rural $69,981 4 17.2 $4,843
Urban $70,014 5 7.0 $6,250
Urban $69,990 5 17.2 $5,780
Urban $69,977 6 12.2 $5,164
Urban $69,993 1 19.6 $4,118
Urban $69,999 5 5.4 $5,602
Suburban $69,983 7 15.9 $6,074
Urban $69,985 2 16.5 $4,927
Suburban $70,001 2 8.6 $5,161
Rural $70,000 6 10.9 $6,044
Urban $69,988 -0 10.0 $3,307
Suburban $69,986 6 11.6 $4,911
Suburban $70,009 3 14.4 $5,142
Rural $70,013 4 18.2 $5,634
Urban $70,009 5 15.1 $6,014
Suburban $70,006 3 14.5 $5,597
Rural $70,010 5 9.7 $6,784
Rural $69,988 7 13.9 $6,399
Suburban $69,996 5 17.5 $6,017
Suburban $69,990 3 28.3 $5,345
Urban $70,002 5 18.9 $5,766
Rural $69,995 6 13.7 $6,821
Suburban $69,985 3 22.8 $4,738
Suburban $69,968 3 17.0 $4,068
Rural $70,009 5 18.4 $6,343
Urban $70,021 4 10.5 $5,110
Rural $69,995 3 15.0 $5,003
Urban $70,006 4 12.8 $6,413
Suburban $69,957 3 18.4 $3,750
Urban $70,005 6 3.7 $6,132
Urban $70,012 6 11.4 $6,982
Urban $69,984 4 22.1 $4,090
Rural $70,000 1 -1.2 $3,919
Rural $69,988 2 7.7 $4,102
Urban $69,992 3 20.4 $5,376
Suburban $70,003 7 16.6 $6,254
Urban $69,965 3 15.0 $4,464
Urban $70,034 3 21.6 $6,127
Rural $69,992 6 9.8 $5,536
Urban $70,019 4 12.6 $5,898
Suburban $69,985 4 18.0 $5,332
Urban $69,988 3 4.8 $4,687
Suburban $69,998 5 13.8 $6,655
Rural $69,996 3 21.7 $5,792
Urban $70,022 6 4.9 $6,450
Suburban $69,986 4 17.9 $4,937
Rural $69,969 5 14.8 $4,508
Urban $69,986 5 17.2 $4,726
Urban $69,997 2 8.5 $4,452
Suburban $70,030 5 13.4 $7,079
Rural $69,984 4 13.0 $5,146
Urban $69,981 5 17.7 $5,369
Urban $69,989 6 12.9 $5,636
Urban $70,013 3 4.9 $5,801
Urban $69,993 2 2.4 $4,636
Urban $69,984 6 10.3 $5,884
Suburban $70,013 4 15.4 $5,541
Urban $69,995 5 13.1 $5,263
Suburban $70,008 7 7.4 $6,767
Rural $70,002 4 10.9 $6,253
Urban $70,009 4 11.9 $6,167
Suburban $70,004 2 17.9 $5,189
Suburban $69,994 1 24.1 $4,345
Rural $70,017 4 5.6 $6,446
Urban $70,015 6 13.6 $6,524
Suburban $70,007 6 16.0 $6,582
Rural $69,997 4 13.0 $5,039
Rural $70,029 6 11.5 $6,450
Suburban $69,975 4 13.3 $4,076
Suburban $70,007 5 16.8 $6,301
Urban $69,977 1 13.2 $3,657
Rural $70,018 6 7.6 $6,214
Suburban $69,998 4 15.8 $5,493
Suburban $69,981 4 7.5 $5,128
Rural $69,993 4 17.1 $5,042
Urban $70,002 4 19.8 $5,575
Rural $69,977 2 17.1 $4,511
Urban $70,024 3 16.8 $6,043
Suburban $69,989 5 21.8 $5,283
Urban $69,987 3 11.3 $4,881
Urban $69,999 2 10.4 $4,930
Urban $70,033 2 12.5 $6,594
Rural $70,032 5 13.6 $7,026
Rural $69,981 5 11.9 $5,034
Urban $69,999 5 13.3 $6,093
Suburban $69,995 2 8.3 $4,735
Urban $70,010 4 8.4 $6,161
Urban $69,999 2 10.6 $4,390
Rural $70,008 7 9.4 $7,227
Urban $70,016 6 9.8 $7,148
Suburban $69,990 8 22.0 $6,528
Urban $70,014 5 14.8 $5,873
Suburban $70,006 7 10.7 $6,278
Rural $69,994 4 19.3 $5,161
Urban $70,011 4 9.6 $5,662
Suburban $70,009 6 20.4 $6,595
Rural $70,041 5 5.8 $6,576
Urban $69,981 6 16.7 $4,604
Urban $70,009 6 21.7 $7,002
Suburban $70,006 6 21.0 $6,628
Rural $70,003 6 11.6 $6,123
Urban $69,990 6 19.1 $5,724
Urban $70,015 7 13.4 $7,041
Urban $70,009 9 22.3 $7,238
Urban $70,000 5 13.1 $6,212
Urban $69,973 5 8.2 $5,154
Suburban $69,996 4 16.5 $5,697
Urban $69,997 5 11.7 $5,440
Suburban $70,026 4 17.7 $6,514
Rural $69,980 7 16.0 $5,629
Urban $69,989 3 10.1 $3,925
Suburban $69,983 4 6.1 $5,445
Suburban $69,994 3 8.3 $5,106
Rural $70,009 7 18.8 $6,535
Urban $69,993 3 7.6 $5,193
Suburban $70,005 4 18.2 $5,282
Rural $69,994 7 19.7 $6,326
Rural $70,023 3 11.5 $4,923
Suburban $70,015 4 2.9 $5,763
Suburban $70,007 2 10.6 $5,309