Business, 10.03.2020 00:17 briannarose2003

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 following questions. 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: 1

Show answers

Another question on Business

Business, 21.06.2019 23:30

Select the correct answer. joshua runs a large manufacturing business that is listed on the stock exchange. his company made good profits in the previous financial year. he now plans to reward his shareholders with handsome dividends. under which category of activities in the cash flow statement would the company’s accountants place this outflow of cash? a. investing activities b. operating activities c. financing activities d. non-operating activities

Answers: 3

Answer

Business, 22.06.2019 04:40

Select the correct answerwhat is the responsibility of each of the twelve federal reserve's banks in their districts? a.they set the prime rateob.they monitor functioning of banks in their through onsite and offsite reviewsc.they assess taxes in their destnictd.they write fiscal policies

Answers: 1

Answer

Business, 22.06.2019 16:30

Which of the following has the largest impact on opportunity cost

Answers: 3

Answer

Business, 22.06.2019 22:10

Afirm plans to begin production of a new small appliance. the manager must decide whether to purchase the motors for the appliance from a vendor at $10 each or to produce them in-house. either of two processes could be used for in-house production; process a would have an annual fixed cost of $200,000 and a variable cost of $7 per unit, and process b would have an annual fixed cost of $175,000 and a variable cost of $8 per unit. determine the range of annual volume for which each of the alternatives would be best. (round your first answer to the nearest whole number. include the indifference value itself in this answer.)

Answers: 2

Answer

You know the right answer?

The file taxdata contains information from federal tax returns filed in 2007 for all counties in the...

Questions