Determine each variable's type - quantitative (discrete or continuous) or categorical. This will help determine which graphical display to use. See the extra sheet in the Excel file. Create a histogram with one of the quantitative variables. You decide the appropriate number of bins. Copy and paste to a Word/pdf document. Comment on the histogram's center, variability, shape, and any unusual values. Create a pie chart or bar chart with one of the categorical variables. Copy and paste to your Word/pdf document. Comment on what you see in the pie/bar chart. Create another visualization of your choice. Comment on the variable and visualization you selected and what relationships, patterns, or insights you found

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
Determine each variable's type - quantitative (discrete or continuous) or categorical. This will help determine which graphical display to use. See the extra sheet in the Excel file. Create a histogram with one of the quantitative variables. You decide the appropriate number of bins. Copy and paste to a Word/pdf document. Comment on the histogram's center, variability, shape, and any unusual values. Create a pie chart or bar chart with one of the categorical variables. Copy and paste to your Word/pdf document. Comment on what you see in the pie/bar chart. Create another visualization of your choice. Comment on the variable and visualization you selected and what relationships, patterns, or insights you found.
Sheet1
Variable Name
ID Num
Filing Type
TaxPaid
AGI
TaxPct
Exemptions
Audited?
Age of Primary
Data Dictionary
Variable Description
identification number
filing status
amount of taxes paid (dollars)
adjusted gross income (dollars)
tax percentile
number of exemptions claimed
has the taxpayer been audited in the last five years (1=yes, 0=no)
age of the primary taxpayer
Variable Type (you fill this one in!)
Transcribed Image Text:Sheet1 Variable Name ID Num Filing Type TaxPaid AGI TaxPct Exemptions Audited? Age of Primary Data Dictionary Variable Description identification number filing status amount of taxes paid (dollars) adjusted gross income (dollars) tax percentile number of exemptions claimed has the taxpayer been audited in the last five years (1=yes, 0=no) age of the primary taxpayer Variable Type (you fill this one in!)
Sheet1
ID Num
2961
2396 Head of Household
5055
2504
4466
2139
5599
4875
4823
3980
3206
3941
5127
5626
3841
1887
5158
2096
1342
5508
3554
1862
2391
3960
2785
1645
5063
4665
2585
5109
1279
4965
1872
2338
3958 Head of Household
3091
5385
1061
4553
3379
3701
3087
1043
Data Dictionary
Filing Type
Married Joint
3527
3009
3659
3556
3153
2126
3640
3212
5518
1351
1397
2271
1664
3263 Head of Household
5347
3862
1594
1134
2051
Married Joint
Married Joint
Single
Married Joint
Single
Married Joint
Single
Single
Married Joint
Single
Head of Household
2888
2038
4245
5272
2052
1865
2122
2504
Married Joint
Married Joint
Married Joint
Married Joint
Married Joint
Single
Married Joint
Married Joint
1312
2426
Married Joint
Married Separate
4305
4955 Head of Household
4733
Single
Single
Married Joint
5242
5369
5053
2652
4372
3551
Married Joint
Married Joint
Single
Married Joint
Married Joint
Single
Married Joint
Married Joint
Single
Head of Household
Single
Married Joint
Married Joint
Head of Household
Married Joint
Married Joint
Married Joint
Single
Married Joint
Married Joint
Single
Married Joint
Married Joint
Married Joint
Single
Single
Single
Single
Single
Single
Married Joint
Married Joint
Married Joint
Married Joint
1744
3205 Head of Household
4381
Single
Single
Single
Single
Married Joint
Married Joint
Married Joint
Head of Household
Married Joint
Single
Married Joint
Married Joint
Head of Household
Married Joint
1700 Head of Household
3174 Head of Household
5092
Head of Household
5177
Married Joint
1953 Head of Household
3312
1103
1008
1689 Head of Household
2648
1902
4092
4970
3518
1928 Head of Household
1794
Single
Single
Married Joint
Married Joint
Married Joint
Head of Household
Single
Married Joint
Single
Single
Single
Married Joint
Married Joint
Single
Single
TaxPaid
8084
0
1676
18400
12630
9:3980
17920
77290
31850 165300
11410
1031
917 8767
96220
9455
538300 1310000
489500 1425000
3551 27100
2097 17300
3861
9640
788
3720
44580
61460
0
76000
10610 77040
632900 3324000
0
6155
17
AGI TaxPet
11.59
0
69720
12010
193200
14
6053
2656 24990
616400
253
2198
1715 20370
7772
43610
227
50630
7895
32930
2899 24900
9807 65760
1640
13580
799
19080
12380
39230
1863
1122 11470
9.78
7558 40730 18.56
10.63
31.34
45970
208700
4934 45090
9025 60070
1332 16070
150900
9.11
13.44
23.19
19.27
129400
1498
33830
366
10.46
11.86
10.9
41.09
34.35
13.1
12.12
3787
32720
122600
8.66
15.68
0
13.77
19.04
9.98
11.3
0
15.69
0.91
11.51
8.42
17.82
6.17
11.96
11.64
14.91
12.08
4.19
11090 88560
6026 30130
2297
29090
5038 42800 11.77
12.77
8688 68040
61290
3812 34390
5785
9.44
11.08
859900 3160000
216500 803600
641900 2102000
4374 166500
2335 26460
966600 4295000
22.03
10.94
15.02
8.29
12.52
20
7.9
27.21
26.94
30.54
261
4980
0
0
5949 30220 19.69
2294 18140 12.65
4297 31270 13.74
359800 1679000
5857 37850
100
11780
466500
2.63
8.82
22.51
6.89
15.22
21.43
15.47
0.85
32.35
4750 32110
14.79
6729 60150
11.19
5964 42840 13.92
787 7172
18750 3115000
10.97
0.6
1768
15680
11.28
0
13540
0
440500
19210
110100
4241
29.38
7.8
30.73
8.63
235400 414100
56.85
268000 2524000 10.62
3447 24320
405300 875300
14.17
46.3
2300 18190 12.64
9556
0
0
2583
9.59
6293
13.74
7303
15.71
11.72
26940
45800
46480
1426 12170
1433 12380 11.58
2944 26790 10.99
1011 11160
9.06
15.36
9937 6-4690
19830 134200
14.78
6.55
1534 23420
0 42900
0
662200 1866000 35.49
16.91
2111 16950 12.45
10490 62050
340
245 3600
3970
8.56
6.81
2395 25600
9.36
0
0 119500
93 3345
1702 13660 12.46
2.78
Exemptions
2
1
1
1
0
2
0
3
0
0
0
0
1
3
0
1
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
2
0
0
4
2
2
0
0
2
0
2
1
0
4
0
0
0
0
2
0
0
0
0
0
0
0
0
0
2
0
1
0
0
0
0
2
1
3
3
2
0
0
0
0
3
1
11
2
2
2
0
0
0
0
0
0
1
1
0
0
1
0
0
0
2
0
0
0
Audited?
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Age of Primary
47
91
66
68
66
43
60
49
87
52
70
52
29
67
64
80
61
88
74
83
60
78
42
49
35
88
77
51
27
67
78
27
71
39
80
92
90
73
62
54
38
66
58
70
66
69
56
94
30
93
47
29
64
40
52
86
38
63
44
28
47
84
54
65
85
93
31
50
28
72
41
70
83
90
64
76
41
33
55
36
57
69
66
91
52
54
67
84
45
73
32
60
29
70
60
78
89
79
62
66
Transcribed Image Text:Sheet1 ID Num 2961 2396 Head of Household 5055 2504 4466 2139 5599 4875 4823 3980 3206 3941 5127 5626 3841 1887 5158 2096 1342 5508 3554 1862 2391 3960 2785 1645 5063 4665 2585 5109 1279 4965 1872 2338 3958 Head of Household 3091 5385 1061 4553 3379 3701 3087 1043 Data Dictionary Filing Type Married Joint 3527 3009 3659 3556 3153 2126 3640 3212 5518 1351 1397 2271 1664 3263 Head of Household 5347 3862 1594 1134 2051 Married Joint Married Joint Single Married Joint Single Married Joint Single Single Married Joint Single Head of Household 2888 2038 4245 5272 2052 1865 2122 2504 Married Joint Married Joint Married Joint Married Joint Married Joint Single Married Joint Married Joint 1312 2426 Married Joint Married Separate 4305 4955 Head of Household 4733 Single Single Married Joint 5242 5369 5053 2652 4372 3551 Married Joint Married Joint Single Married Joint Married Joint Single Married Joint Married Joint Single Head of Household Single Married Joint Married Joint Head of Household Married Joint Married Joint Married Joint Single Married Joint Married Joint Single Married Joint Married Joint Married Joint Single Single Single Single Single Single Married Joint Married Joint Married Joint Married Joint 1744 3205 Head of Household 4381 Single Single Single Single Married Joint Married Joint Married Joint Head of Household Married Joint Single Married Joint Married Joint Head of Household Married Joint 1700 Head of Household 3174 Head of Household 5092 Head of Household 5177 Married Joint 1953 Head of Household 3312 1103 1008 1689 Head of Household 2648 1902 4092 4970 3518 1928 Head of Household 1794 Single Single Married Joint Married Joint Married Joint Head of Household Single Married Joint Single Single Single Married Joint Married Joint Single Single TaxPaid 8084 0 1676 18400 12630 9:3980 17920 77290 31850 165300 11410 1031 917 8767 96220 9455 538300 1310000 489500 1425000 3551 27100 2097 17300 3861 9640 788 3720 44580 61460 0 76000 10610 77040 632900 3324000 0 6155 17 AGI TaxPet 11.59 0 69720 12010 193200 14 6053 2656 24990 616400 253 2198 1715 20370 7772 43610 227 50630 7895 32930 2899 24900 9807 65760 1640 13580 799 19080 12380 39230 1863 1122 11470 9.78 7558 40730 18.56 10.63 31.34 45970 208700 4934 45090 9025 60070 1332 16070 150900 9.11 13.44 23.19 19.27 129400 1498 33830 366 10.46 11.86 10.9 41.09 34.35 13.1 12.12 3787 32720 122600 8.66 15.68 0 13.77 19.04 9.98 11.3 0 15.69 0.91 11.51 8.42 17.82 6.17 11.96 11.64 14.91 12.08 4.19 11090 88560 6026 30130 2297 29090 5038 42800 11.77 12.77 8688 68040 61290 3812 34390 5785 9.44 11.08 859900 3160000 216500 803600 641900 2102000 4374 166500 2335 26460 966600 4295000 22.03 10.94 15.02 8.29 12.52 20 7.9 27.21 26.94 30.54 261 4980 0 0 5949 30220 19.69 2294 18140 12.65 4297 31270 13.74 359800 1679000 5857 37850 100 11780 466500 2.63 8.82 22.51 6.89 15.22 21.43 15.47 0.85 32.35 4750 32110 14.79 6729 60150 11.19 5964 42840 13.92 787 7172 18750 3115000 10.97 0.6 1768 15680 11.28 0 13540 0 440500 19210 110100 4241 29.38 7.8 30.73 8.63 235400 414100 56.85 268000 2524000 10.62 3447 24320 405300 875300 14.17 46.3 2300 18190 12.64 9556 0 0 2583 9.59 6293 13.74 7303 15.71 11.72 26940 45800 46480 1426 12170 1433 12380 11.58 2944 26790 10.99 1011 11160 9.06 15.36 9937 6-4690 19830 134200 14.78 6.55 1534 23420 0 42900 0 662200 1866000 35.49 16.91 2111 16950 12.45 10490 62050 340 245 3600 3970 8.56 6.81 2395 25600 9.36 0 0 119500 93 3345 1702 13660 12.46 2.78 Exemptions 2 1 1 1 0 2 0 3 0 0 0 0 1 3 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 2 0 0 4 2 2 0 0 2 0 2 1 0 4 0 0 0 0 2 0 0 0 0 0 0 0 0 0 2 0 1 0 0 0 0 2 1 3 3 2 0 0 0 0 3 1 11 2 2 2 0 0 0 0 0 0 1 1 0 0 1 0 0 0 2 0 0 0 Audited? 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Age of Primary 47 91 66 68 66 43 60 49 87 52 70 52 29 67 64 80 61 88 74 83 60 78 42 49 35 88 77 51 27 67 78 27 71 39 80 92 90 73 62 54 38 66 58 70 66 69 56 94 30 93 47 29 64 40 52 86 38 63 44 28 47 84 54 65 85 93 31 50 28 72 41 70 83 90 64 76 41 33 55 36 57 69 66 91 52 54 67 84 45 73 32 60 29 70 60 78 89 79 62 66
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 6 images

Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman