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
Other questions on the subject: Business
Business, 22.06.2019 05:50, eksdeeexe
Cosmetic profits. sally is the executive vice president of big name cosmetics company. through important and material, nonpublic information, she learns that the company is soon going to purchase a smaller chain of stores. it is expected that stock in big name cosmetics will rise dramatically at that point. sally immediately buys a number of shares of her company's stock. she also tells her friend alice about the expected purchase of stores. alice wanted to purchase stock in the company but lacked the funds with which to do so. although she did not have the funds in bank a, alice decided to draw a check on bank a and deposit the check in bank b and then proceed to write a check on bank b to cover the purchase of the stock. she hoped that she would have sufficient funds to deposit before the check was presented for payment. of which of the following offenses, if any, is alice guilty of by buying stock?
Answers: 2
Business, 22.06.2019 11:30, Coltong121
Buyer henry is going to accept seller shannon's $282,500 counteroffer. when will this counteroffer become a contract. a. counteroffers cannot become contracts b. when henry gives shannon notice of the acceptance c. when henry signs the counteroffer d. when shannon first made the counteroffer
Answers: 3
Business, 22.06.2019 12:20, lamwil9432
Selected transactions of the carolina company are listed below. classify each transaction as either an operating activity, an investing activity, a financing activity, or a noncash activity. 1. common stock is sold for cash above par value. 2. bonds payable are issued for cash at a discount
Answers: 2
Business, 22.06.2019 18:00, firesoccer53881
If you would like to ask a question you will have to spend some points
Answers: 1
Do you know the correct answer?
The file TaxData contains information from federal tax returns filed in 2007 for all counties in the...
Questions in other subjects:
English, 06.07.2019 22:50
Social Studies, 06.07.2019 22:50
History, 06.07.2019 22:50
Mathematics, 06.07.2019 22:50
