Business, 08.07.2021 16:40 manman1773

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? (Hint: To sort data in a PivotTable in Excel, right-click any cell in the PivotTable that contains the data you want to sort, and select Sort.)
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: 2

Show answers

Another question on Business

Business, 21.06.2019 21:30

He set of companies a product goes through on the way to the consumer is called the a. economic utility b. cottage industry c. market saturation d. distribution chain

Answers: 3

Answer

Business, 22.06.2019 11:00

Specialization—the division of labor—enhances productivity and efficiency by a) allowing workers to take advantage of existing differences in their abilities and skills. b) avoiding the time loss involved in shifting from one production task to another. c) allowing workers to develop skills by working on one, or a limited number, of tasks. d)all of the means identified in the other answers.

Answers: 2

Answer

Business, 22.06.2019 11:10

The green fiddle has declared a $5 per share dividend. suppose capital gains are not taxed, but dividends are taxed at 15 percent. new irs regulations require that taxes be withheld at the time the dividend is paid. green fiddle stock sells for $71.50 per share, and the stock is about to go ex-dividend. what will the ex-dividend price be?

Answers: 2

Answer

Business, 22.06.2019 12:50

You are working on a bid to build two city parks a year for the next three years. this project requires the purchase of $249,000 of equipment that will be depreciated using straight-line depreciation to a zero book value over the three-year project life. ignore bonus depreciation. the equipment can be sold at the end of the project for $115,000. you will also need $18.000 in net working capital for the duration of the project. the fixed costs will be $37000 a year and the variable costs will be $148,000 per park. your required rate of return is 14 percent and your tax rate is 21 percent. what is the minimal amount you should bid per park? (round your answer to the nearest $100) (a) $214,300 (b) $214,100 (c) $212,500 (d) $208,200 (e) $208,400

Answers: 3

Answer

You know the right answer?

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

Questions