The file TaxData contains information from federal tax returns filed in 2007 for all counties in the United States (3,142 counties in total). Create a PivotTable in Excel to answer the questions below. The PivotTable should have State Abbreviation as Row Labels. The Values in the PivotTable should be the sum of adjusted gross income for each state.
A. Sort the PivotTable data to display the states with the smallest sum of adjusted gross income on top and the largest on the bottom. Which state had the smallest sum of adjusted gross income? What is the total adjusted gross income for federal tax returns filed in this state with the smallest total adjusted gross income
B. Add the County Name to the Row Labels in the PivotTable. Sort the County Names by Sum of Adjusted Gross Income with the lowest values on top and the highest values on bottom. Filter the Row Labels so that only the state of Texas is displayed. Which county had the smallest sum of adjusted gross income in the state of Texas? Which county had the largest sum of adjusted gross income in the state of Texas?
C. Click on Sum of Adjusted Gross Income in the Values area of the PivotTable in Excel. Click Value Field Settings . . . . Click the tab for Show Values As. In the Show values as box, choose % of Parent Row Total. Click OK. This displays the adjusted gross income reported by each county as a percentage of the total state adjusted gross income. Which county has the highest percentage adjusted gross income in the state of Texas? What is this percentage?
D. Remove the filter on the Row Labels to display data for all states. What percentage of total adjusted gross income in the United States was provided by the state of New York?
Answers: 3
Another question on Business
Business, 22.06.2019 03:00
Working with a word processor requires more than just a knowledge of typing. a good word processor includes a number of tools designed to aid in formatting documents to meet the needs of the reader. in this project you will use your word-processing skills and a basic knowledge of apa style to format a research paper. the skills you will need for this project include the following: adjusting line spacing (double-spacing) breaking text into pages (page break) centering text changing the font, style, and size of the text editing text inserting page numbers inserting a table using spell check
Answers: 1
Business, 22.06.2019 04:00
Medtronic, inc., is a medical technology company that competes for customers with st. jude medical s.c., inc. james hughes worked for medtronic as a sales manager. his contract prohibited him from working for a competitor for one year after leaving medtronic. hughes sought a position as a sales director for st. jude. st. jude told hughes that his contract with medtronic was unenforceable and offered him a job. hughes accepted. medtronic filed a suit, alleging wrongful interference. which type of interference was most likely the basis for this suit? did it occur here? medtronic, inc., is a medical technology company that competes for customers with st. jude medical s.c., inc. james hughes worked for medtronic as a sales manager. his contract prohibited him from working for a competitor for one year after leaving medtronic
Answers: 2
Business, 22.06.2019 19:10
Pam is a low-risk careful driver and fran is a high-risk aggressive driver. to reveal their driver types, an auto-insurance company a. refuses to insure high-risk drivers b. charges a higher premium to owners of newer cars than to owners of older cars c. offers policies that enable drivers to reveal their private information d. uses a pooling equilibrium e. requires drivers to categorize themselves as high-risk or low-risk on the application form
Answers: 3
Business, 22.06.2019 19:30
Which of the following constitute the types of unemployment occurring at the natural rate of unemployment? a. frictional and cyclical unemployment.b. structural and frictional unemployment.c. cyclical and structural unemployment.d. frictional, structural, and cyclical unemployment.
Answers: 2
You know the right answer?
The file TaxData contains information from federal tax returns filed in 2007 for all counties in the...
Questions
Mathematics, 04.04.2020 04:32
Medicine, 04.04.2020 04:32
Mathematics, 04.04.2020 04:32
Mathematics, 04.04.2020 04:32
History, 04.04.2020 04:33
