We will start this activity in class when we begin Module 3 Use the provided data set to perform the operations listed below 1 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 2 Create a histogram with one of the quantitative variables You decide the appropriate number of bins Copy and paste to a Word pdf document 3 Comment on the histogram's center, variability, shape, and any unusual values 4 Create a pie chart or bar chart with one of the categorical variables Copy and paste to your Word pdf document 5 Comment on what you see in the pie bar chart 6 Create another visualization of your choice Comment on the variable and visualization you selected and what relationships, patterns, or insights you found 7 Turn in your 1 2 page Word pdf document Id Num FilingType TaxPaid AGI TaxPct Exemptions Audited Age of Primary 2961 Married Joint 8084 69720 11 59 2 0 47 2396 Head of Household 0 12010 0 1 0 91 5055 Married Joint 1676 18400 9 11 1 0 66 2504 Married Joint 12630 93980 13 44 1 0 68 4466 Single 17920 77290 23 19 0 0 66 2139 Married Joint 31850 165300 19 27 2 0 43 5599 Single 917 8767 10 46 0 0 60 4875 Married Joint 11410 96220 11 86 3 0 49 4823 Single 1031 9455 10 9 0 0 87 3980 Single 538300 1310000 41 09 0 0 52 3206 Married Joint 489500 1425000 34 35 0 0 70 3941 Single 3551 27100 13 1 0 0 52 5127 Head of Household 2097 17300 12 12 1 0 29 5626 Married Joint 3861 44580 8 66 3 0 67 3841 Married Joint 9640 61460 15 68 0 0 64 1645 Married Joint 0 76000 0 1 0 80 5063 Married Joint 10610 77040 13 77 0 0 61 4665 Married Joint 632900 3324000 19 04 0 0 88 2585 Single 788 7895 9 98 0 0 74 5109 Married Joint 3720 32930 11 3 0 0 83 1279 Married Joint 0 12380 0 0 0 60 4965 Single 6155 39230 15 69 0 0 78 1872 Single 17 1863 0 91 0 1 42 2338 Married Joint 1122 11470 9 78 0 0 49 3958 Head of Household 7558 40730 18 56 1 0 35 3091 Married Joint 2656 24990 10 63 0 0 88 3212 Married Joint 193200 616400 31 34 0 0 77 5518 Single 253 2198 11 51 0 0 51 1351 Married Joint 1715 20370 8 42 0 0 27 1397 Married Joint 7772 43610 17 82 0 0 67 2271 Single 14 227 6 17 0 0 78 1664 Married Joint 6053 50630 11 96 0 0 27 3263 Head of Household 2899 24900 11 64 2 0 71 5347 Married Joint 9807 65760 14 91 0 0 39 3862 Single 1640 13580 12 08 0 1 80 1312 Head of Household 799 19080 4 19 4 0 92 2426 Married Joint 45970 208700 22 03 2 0 90 4305 Married Separate 4934 45090 10 94 2 0 73 4955 Head of Household 9025 60070 15 02 0 0 62 4733 Single 1332 16070 8 29 0 0 54 1887 Married Joint 11090 88560 12 52 2 0 38 5158 Married Joint 6026 30130 20 0 0 66 2096 Head of Household 2297 29090 7 9 2 0 58 1342 Married Joint 5038 42800 11 77 1 0 70 5508 Married Joint 8688 68040 12 77 0 0 66 3554 Married Joint 5785 61290 9 44 4 0 69 1862 Single 3812 34390 11 08 0 0 56 2391 Married Joint 859900 3160000 27 21 0 0 94 3960 Married Joint 216500 803600 26 94 0 0 30 2785 Single 641900 2102000 30 54 0 0 93 5385 Married Joint 4374 166500 2 63 2 1 47 1061 Married Joint 2335 26460 8 82 0 0 29 4553 Married Joint 966600 4295000 22 51 0 0 64 3379 Single 261 3787 6 89 0 0 40 3701 Single 4980 32720 15 22 0 0 52 3087 Single 0 122600 0 0 0 86 1043 Single 5949 30220 19 69 0 0 38 3527 Single 2294 18140 12 65 0 0 63 3009 Single 4297 31270 13 74 0 0 44 3659 Married Joint 359800 1679000 21 43 0 0 28 3556 Married Joint 5857 37850 15 47 2 0 47 3153 Married Joint 100 11780 0 85 0 0 84 2126 Married Joint 150900 466500 32 35 1 0 54 3640 Single 4750 32110 14 79 0 0 65 1594 Single 6729 60150 11 19 0 0 85 1134 Single 5964 42840 13 92 0 0 93 2051 Single 787 7172 10 97 0 0 31 1744 Married Joint 18750 3115000 0 6 2 0 50 3205 Head of Household 1768 15680 11 28 1 0 28 4381 Married Joint 0 13540 0 3 0 72 2888 Married Joint 129400 440500 29 38 3 0 41 2038 Head of Household 1498 19210 7 8 2 0 70 4245 Married Joint 33830 110100 30 73 0 0 83 5272 Single 366 4241 8 63 0 0 90 2052 Married Joint 235400 414100 56 85 0 0 64 1865 Married Joint 268000 2524000 10 62 0 0 76 2122 Head of Household 3447 24320 14 17 3 0 41 2504 Married Joint 405300 875300 46 3 1 1 33 1700 Head of Household 2300 18190 12 64 1 1 55 3174 Head of Household 0 9556 0 2 0 36 5092 Head of Household 2583 26940 9 59 2 0 57 5177 Married Joint 6293 45800 13 74 2 0 69 1953 Head of Household 7303 46480 15 71 0 0 66 3312 Single 1426 12170 11 72 0 0 91 1103 Single 1433 12380 11 58 0 0 52 1008 Married Joint 2944 26790 10 99 0 0 54 1689 Head of Household 1011 11160 9 06 0 0 67 2648 Married Joint 9937 64690 15 36 0 0 84 1902 Married Joint 19830 134200 14 78 1 0 45 4092 Head of Household 1534 23420 6 55 1 0 73 4970 Single 0 42900 0 0 0 32 3518 Married Joint 662200 1866000 35 49 0 0 60 1928 Head of Household 2111 16950 12 45 1 0 29 1794 Single 10490 62050 16 91 0 0 70 5242 Single 340 3970 8 56 0 0 60 5369 Single 245 3600 6 81 0 0 78 5053 Married Joint 2395 25600 9 36 2 0 89 2652 Married Joint 0 119500 0 0 0 79 4372 Single 93 3345 2 78 0 0 62 3551 Single 1702 13660 12 46 0 0 66 Variable Name Variable Description Variable Type (you fill this one in ) ID Num identification number FilingType filing status TaxPaid amount of taxes paid (dollars) AGI adjusted gross income (dollars) TaxPct tax percentile Exemptions number of exemptions claimed Audited has the taxpayer been audited in the last five years (1 yes, 0 no) Age of Primary age of the primary taxpayer A data dictionary is provided in the Excel file in the sheet called Data Dictionary

The Answer is in the image, click to view ...

Question: We will start this activity in class when we begin Module 3. Use the provided data set to perform the operations listed below. 1. Determine

We will start this activity in class when we begin Module 3. Use the provided data set to perform the operations listed below.

1. 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.

2. Create a histogram with one of the quantitative variables. You decide the appropriate number of bins. Copy and paste to a Word/pdf document.

3. Comment on the histogram's center, variability, shape, and any unusual values.

4. Create a pie chart or bar chart with one of the categorical variables. Copy and paste to your Word/pdf document.

5. Comment on what you see in the pie/bar chart.

6. Create another visualization of your choice. Comment on the variable and visualization you selected and what relationships, patterns, or insights you found.

7. Turn in your 1-2 page Word/pdf document.

Id Num FilingType TaxPaid AGI TaxPct Exemptions Audited? Age of Primary 2961 Married Joint 8084 69720 11.59 2 0 47 2396 Head of Household 0 12010 0 1 0 91 5055. Married Joint 1676 18400 9.11 1 0 66 2504 Married Joint 12630 93980 13.44 1 0 68 4466. Single 17920 77290 23.19 0 0 66 2139. Married Joint 31850 165300 19.27 2 0 43 5599 Single 917 8767 10.46 0 0 60 4875 Married Joint 11410 96220 11.86 3 0 49 4823 Single 1031 9455 10.9 0 0 87 3980 Single 538300 1310000 41.09 0 0 52 3206 Married Joint 489500 1425000 34.35 0 0 70 3941 Single 3551 27100 13.1 0 0 52 5127 Head of Household 2097 17300 12.12 1 0 29 5626 Married Joint 3861 44580 8.66 3 0 67 3841 Married Joint 9640 61460 15.68 0 0 64 1645 Married Joint 0 76000 0 1 0 80 5063 Married Joint 10610 77040 13.77 0 0 61 4665 Married Joint 632900 3324000 19.04 0 0 88 2585 Single 788 7895 9.98 0 0 74 5109 Married Joint 3720 32930 11.3 0 0 83 1279 Married Joint 0 12380 0 0 0 60 4965 Single 6155 39230 15.69 0 0 78 1872 Single 17 1863 0.91 0 1 42 2338 Married Joint 1122 11470 9.78 0 0 49 3958 Head of Household 7558 40730 18.56 1 0 35 3091 Married Joint 2656 24990 10.63 0 0 88 3212 Married Joint 193200 616400 31.34 0 0 77 5518 Single 253 2198 11.51 0 0 51 1351 Married Joint 1715 20370 8.42 0 0 27 1397 Married Joint 7772 43610 17.82 0 0 67 2271 Single 14 227 6.17 0 0 78 1664 Married Joint 6053 50630 11.96 0 0 27 3263 Head of Household 2899 24900 11.64 2 0 71 5347 Married Joint 9807 65760 14.91 0 0 39 3862 Single 1640 13580 12.08 0 1 80 1312 Head of Household 799 19080 4.19 4 0 92 2426 Married Joint 45970 208700 22.03 2 0 90 4305 Married Separate 4934 45090 10.94 2 0 73 4955 Head of Household 9025 60070 15.02 0 0 62 4733 Single 1332 16070 8.29 0 0 54 1887 Married Joint 11090 88560 12.52 2 0 38 5158 Married Joint 6026 30130 20 0 0 66 2096 Head of Household 2297 29090 7.9 2 0 58 1342 Married Joint 5038 42800 11.77 1 0 70 5508 Married Joint 8688 68040 12.77 0 0 66 3554 Married Joint 5785 61290 9.44 4 0 69 1862 Single 3812 34390 11.08 0 0 56 2391 Married Joint 859900 3160000 27.21 0 0 94 3960 Married Joint 216500 803600 26.94 0 0 30 2785 Single 641900 2102000 30.54 0 0 93 5385 Married Joint 4374 166500 2.63 2 1 47 1061 Married Joint 2335 26460 8.82 0 0 29 4553 Married Joint 966600 4295000 22.51 0 0 64 3379 Single 261 3787 6.89 0 0 40 3701 Single 4980 32720 15.22 0 0 52 3087 Single 0 122600 0 0 0 86 1043 Single 5949 30220 19.69 0 0 38 3527 Single 2294 18140 12.65 0 0 63 3009 Single 4297 31270 13.74 0 0 44 3659 Married Joint 359800 1679000 21.43 0 0 28 3556 Married Joint 5857 37850 15.47 2 0 47 3153 Married Joint 100 11780 0.85 0 0 84 2126 Married Joint 150900 466500 32.35 1 0 54 3640 Single 4750 32110 14.79 0 0 65 1594 Single 6729 60150 11.19 0 0 85 1134 Single 5964 42840 13.92 0 0 93 2051 Single 787 7172 10.97 0 0 31 1744 Married Joint 18750 3115000 0.6 2 0 50 3205 Head of Household 1768 15680 11.28 1 0 28 4381 Married Joint 0 13540 0 3 0 72 2888 Married Joint 129400 440500 29.38 3 0 41 2038 Head of Household 1498 19210 7.8 2 0 70 4245 Married Joint 33830 110100 30.73 0 0 83 5272 Single 366 4241 8.63 0 0 90 2052 Married Joint 235400 414100 56.85 0 0 64 1865 Married Joint 268000 2524000 10.62 0 0 76 2122 Head of Household 3447 24320 14.17 3 0 41 2504 Married Joint 405300 875300 46.3 1 1 33 1700 Head of Household 2300 18190 12.64 1 1 55 3174 Head of Household 0 9556 0 2 0 36 5092 Head of Household 2583 26940 9.59 2 0 57 5177 Married Joint 6293 45800 13.74 2 0 69 1953 Head of Household 7303 46480 15.71 0 0 66 3312 Single 1426 12170 11.72 0 0 91 1103 Single 1433 12380 11.58 0 0 52 1008 Married Joint 2944 26790 10.99 0 0 54 1689 Head of Household 1011 11160 9.06 0 0 67 2648 Married Joint 9937 64690 15.36 0 0 84 1902 Married Joint 19830 134200 14.78 1 0 45 4092 Head of Household 1534 23420 6.55 1 0 73 4970 Single 0 42900 0 0 0 32 3518 Married Joint 662200 1866000 35.49 0 0 60 1928 Head of Household 2111 16950 12.45 1 0 29 1794 Single 10490 62050 16.91 0 0 70 5242 Single 340 3970 8.56 0 0 60 5369 Single 245 3600 6.81 0 0 78 5053 Married Joint 2395 25600 9.36 2 0 89 2652 Married Joint 0 119500 0 0 0 79 4372 Single 93 3345 2.78 0 0 62 3551 Single 1702 13660 12.46 0 0 66

Variable Name Variable Description Variable Type (you fill this one in!) ID Num identification number FilingType. filing status TaxPaid amount of taxes paid (dollars) AGI adjusted gross income (dollars) TaxPct. tax percentile Exemptions number of exemptions claimed Audited? has the taxpayer been audited in the last five years (1=yes, 0=no) Age of Primary age of the primary taxpayer

A data dictionary is provided in the Excel file in the sheet called "Data Dictionary."

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Use the FAM100.xls data set to perform the operations listed below. Determine each variable's type - quantitative or qualitative. This will help determine which graphical display to use. Create a...

Jupiter Notebook We have covered some of the limitations of single layer neural networks in class, but they are still powerful learning systems that provide a good way to begin learning about how to...

CSEBank has decided to offer a new collection of credit cards to its customers: a basic/traditional credit card, a rewards card, and a prepaid/stored-balance card. For this assignment, you will...

Scenario: Please write a few lines describing your scenario and the four variables (in addition to income) you have selected. Use Table 1 to report the variables selected for this assignment. Note:...

BA 1605: Midterm Recap (Due: Feb. 27, 2015) Name _____________________________ 50 Student ID _____________________________ Section 01B 10:00~11:20 am Section 02B 01:00~02:20 pm [Questions 4 ~ 7] The...

Directions First, save this file as Cost behavior_name and section number You will upload this file to Canvas when you are finished. Overview: The goal of this project is to better acquaint you with...

Unit 3 Problem Set NAME: Elements of Statistics--FHSU Virtual College--Spring 2017 REMEMBER, these are assessed preparatory problems related to the content of Unit 3. The Unit 3 Exam will consist of...

OPRE 3360: Managerial Methods in Decision Making Under Uncertainty Graded Group Assignment 2: Hypothesis Testing and Statistical Inference This group assignment is open book and notes. However, once...

Question: Evaluate the two forecasting models described in the case for predicting daily check-in volume. What are the strengths and weaknesses of each one? Do you find any of the results surprising?...

What is stagflation? Explain how the increase in the price of oil can cause stagflation and draw a graph to illustrate this outcome.

Using the trial balance provided above, prepare an income statement and statement of changes in equity for the first month ei May 31, 2020, and a balance sheet at May 31, 2020.

A summary of all the financial data in the account ledgers that ensures the figures are correct and balanced is called Multiple Choice a gross margin balance. a trial balance. departmental checks and...

The following accounts appear in the ledger of Marigold Corp. after the books are closed at December 31,2019 Common Stock, no par, $2 stated value, 399,000 shares authorized; 293,000 shares issued...