Part of this assignment is locating the data on your own. You should use the IRS's...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Part of this assignment is locating the data on your own. You should use the IRS's Statistics of Income (SOI) data to complete the Tableau visualizations. The SOI data is available at www.irs.gov and you should look for "SOI Tax Stats - Individual Income Tax Returns with Small Business Income and Losses" and then for the 2019 (which is the most recently available) data for "Individual Returns with Business Attributes: Selected Income Items, Adjustments, Credits, and Taxes." Your focus in analyzing the data should relate to "Partnerships & S- corporations" (columns BG-BJ) and the "Qualified Business Income Deduction" (columns DG DH). You may still use other information in the Excel, but at a minimum must include the QBI information for these pass- through entities. Please be sure you download the correct SOI data set. You'll see that 10% of the assignment's grade is "Data used is appropriate and sufficient for the analysis." Failure to use the correct data set is an automatic 10% grade loss (which equates to a full letter grade for the assignment). The grading rubric is attached here for your convenience. Once you download the data set you should proceed to open/import it to Tableau. Your objective is to produce 3 meaningful visualizations-the visuals should tell a story without the necessity of written words. However, you are not precluded from adding some narrative and/or a dashboard and/or a storyboard. You may work in groups (max of 3) and all syllabus stipulations apply (e.g., you should only be sharing files among your group members). EACH student (regardless of whether you work in a group or solo) should upload the following to iCollege: 1) The Tableau packaged workbook file (*.twbx) you created. You may need to use the drop down to see the *.twbx option for saving your Tableau file. The packaged version includes your data file. 2) PDFs of the 3 visualizations; and PDFs of your dashboard and/or storyboard. NOTE: You can "print to PDF" from Tableau to create the PDFs. I MUST have the PDFs to grade your projects. 3) All file names should include your name or all group members' names. For example IRS.IRA.data. Smith Mike; Tableau.Smith.Mike; Viz1.Smith Mike; Viz2.Smith Mike; Viz3.Smith Mike; Dash B.Smith.Mike; StoryB.Smith Mike Although the assignment is not due until near the end of the term, it is provided in Module 1 so you may begin to work on it as soon as your schedule permits. Part of this assignment is locating the data on your own. You should use the IRS's Statistics of Income (SOI) data to complete the Tableau visualizations. The SOI data is available at www.irs.gov and you should look for "SOI Tax Stats - Individual Income Tax Returns with Small Business Income and Losses" and then for the 2019 (which is the most recently available) data for "Individual Returns with Business Attributes: Selected Income Items, Adjustments, Credits, and Taxes." Your focus in analyzing the data should relate to "Partnerships & S- corporations" (columns BG-BJ) and the "Qualified Business Income Deduction" (columns DG DH). You may still use other information in the Excel, but at a minimum must include the QBI information for these pass- through entities. Please be sure you download the correct SOI data set. You'll see that 10% of the assignment's grade is "Data used is appropriate and sufficient for the analysis." Failure to use the correct data set is an automatic 10% grade loss (which equates to a full letter grade for the assignment). The grading rubric is attached here for your convenience. Once you download the data set you should proceed to open/import it to Tableau. Your objective is to produce 3 meaningful visualizations-the visuals should tell a story without the necessity of written words. However, you are not precluded from adding some narrative and/or a dashboard and/or a storyboard. You may work in groups (max of 3) and all syllabus stipulations apply (e.g., you should only be sharing files among your group members). EACH student (regardless of whether you work in a group or solo) should upload the following to iCollege: 1) The Tableau packaged workbook file (*.twbx) you created. You may need to use the drop down to see the *.twbx option for saving your Tableau file. The packaged version includes your data file. 2) PDFs of the 3 visualizations; and PDFs of your dashboard and/or storyboard. NOTE: You can "print to PDF" from Tableau to create the PDFs. I MUST have the PDFs to grade your projects. 3) All file names should include your name or all group members' names. For example IRS.IRA.data. Smith Mike; Tableau.Smith.Mike; Viz1.Smith Mike; Viz2.Smith Mike; Viz3.Smith Mike; Dash B.Smith.Mike; StoryB.Smith Mike Although the assignment is not due until near the end of the term, it is provided in Module 1 so you may begin to work on it as soon as your schedule permits.
Expert Answer:
Answer rating: 100% (QA)
I understand that you need to work on a data analysis assignment using Tableau specifically with IRS SOI data for partnerships Scorporations and the Q... View the full answer
Related Book For
Discovering Advanced Algebra An Investigative Approach
ISBN: 978-1559539845
1st edition
Authors: Jerald Murdock, Ellen Kamischke, Eric Kamischke
Posted Date:
Students also viewed these mathematics questions
-
The purpose of this assignment is to conduct research related to how a specific company utilizes information related to consumer behavior, product mix or service processes, and pricing to create...
-
The learning outcome of this assignment is to understand how to conduct research on a given topic. Also, the outcome includes the application of your research about strategic human resources planning...
-
Assignment Goal The goal of this Assignment is to improve students' ability to develop applications using Java. It will help students to face potential pits and falls of real world data structure...
-
The following is a symbolic microprogram for an instruction in the computer defined in Sec. 7-3. a. Specify the operation performed when the instruction is executed. b. Convert the four...
-
At the end of January 2012, the records of Southport Company showed the following for a particular item that sold at $15 per unit: Required: 1. Assuming the use of a periodic inventory system,...
-
What is a ratio? What are the different ways of expressing the relationship of two amounts? What information does a ratio provide?
-
Hank Maupin & Company is in the process of replacing its existing computer system. The following three proposals are being considered: Required: a. Determine the internal rate of return for each of...
-
The following are activities that occurred at Franklin Manufacturing, a nonpublic company. 1. Franklin's accountant did not record checks written in the last few days of the year until the next...
-
AP 2-3 Individual tax instalments Taxation-1, Course code: ACCT2028 For the three taxation years ending December 31, 2019,2020 and 2021, assume that Bronson james Had the following actual and...
-
D. Deni commenced business on 1 April 2014 by depositing Sh.8 million into the business bank account. All receipts and payments were channelled through this business account. During the year ended 31...
-
Plot a Histogram for the column 'disp' in the data set 'mtcars'. 6. Plot the data set 'women' while limiting the x-axis to 55 through 70. 7. Can you set limits for the Y-axis like done above for the...
-
An employee borrows $7000 from a bank to purchase some household items. She plans to repay the loan with a bonus she is supposed to receive in 75 days. If she borrows the money at 10.0% find the...
-
According to the idea of the "invisible hand" in Adam Smith's theory of political economy, intentional pursuit by the individual of one's own self interest leads to unintentional benefits for the...
-
Alexa owns a condominium near Cocoa Beach in Florida. In 2023, she incurs the following expenses in connection with her condo: Insurance Mortgage interest Property taxes Repairs & maintenance...
-
The Arkansas Lighting Company would like to estimate the cost of equity. They decide to use CAPM for the calculation. For the risk-free rate, they decide to use the interest rate on 10-Year U. S....
-
A company bought a new machine for its new project. The machine s original cost was $ 7 0 0 , 0 0 0 , it generates annual revenues of $ 9 0 , 0 0 0 and annual expenses of $ 6 0 , 0 0 0 . Calculate...
-
Delta Company produces a single product. The cost of producing and selling a single unit of this product at the company's normal activity level of 87,600 units per year is: Direct materials Direct...
-
Find the APR in each of the following cases: NUMBER OF TIMES COMPOUNDED Semiannually Monthly Weekly Infinite EAR APR 10.4% 8.9 11.6 15.4
-
Solve for θ. Express your answers in radians. a. b. c. COS6 12
-
Rita is practicing darts. On this particular dartboard, she can score 20 points for a bull's- ye and 10 points, 5 points, or 1 point for the other regions. Although Rita doesn't know exactly where...
-
A ball rolls off the edge of a 12 m tall cliff at a velocity of 2 m/s. a. Write parametric equations to simulate this motion. b. What equation can you solve to determine when the ball hits the...
-
Consider the following game trees. (a) Find all equilibria for the game tree on the left. Which of these are subgameperfect? (b) In the game tree on the right, the payoffs \ (a, b, c, d\) are...
-
Consider the following game tree. (a) What is the number of strategies of player I and of player II? How many reduced strategies does each of the players have? (b) Give the reduced strategic form of...
-
Consider a game \(G\) in strategic form. Recall that the commitment game derived from \(G\) is defined by letting player I choose one of his strategies \(x\), which is then announced to player II,...
Study smarter with the SolutionInn App