Business, 18.06.2020 21:57 ttorres013

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 incomeb. 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

Show answers

Another question on Business

Business, 21.06.2019 21:30

8. agreement and disagreement among economists suppose that bob, an economist from a university in arizona, and cho, an economist from a public television program, are arguing over saving incentives. the following dialogue shows an excerpt from their debate: cho: i think it's safe to say that, in general, the savings rate of households in today's economy is much lower than it really needs to be to sustain an improvement in living standards. bob: i think a switch from the income tax to a consumption tax would bring growth in living standards. cho: you really think households would change their saving behavior enough in response to this to make a difference? because i don't. the disagreement between these economists is most likely due to . despite their differences, with which proposition are two economists chosen at random most likely to agree? rent ceilings reduce the quantity and quality of available housing. immigrants receive more in government benefits than they contribute in taxes. having a single income tax rate would improve economic performance.

Answers: 1

Answer

Business, 21.06.2019 23:00

The impact fiscal multiplier is a. usually estimated to have an average value of 2. b. usually estimated to have an average value of 0. c. the actual immediate multiplier effect of a fiscal policy action after taking into consideration direct fiscal offsets and other short-term crowding out of private spending. d. the multiplier effect of a fiscal policy action that applies to a long-run period after all influences on equilibrium real gdp have been taken into account.

Answers: 3

Answer

Business, 22.06.2019 08:40

Which of the following statements is true regarding the reporting of outside interests and the management of conflicts? investigators are responsible for developing their own management plans for significant financial interests. the institution must report identified financial conflicts of interest to the u.s. office of research integrity. investigators must disclose their significant financial interests related to their institutional responsibilities and not just those related to a particular project. investigators must disclose all of their financial interests regardless of whether they are related to a research project.

Answers: 3

Answer

Business, 22.06.2019 12:30

Acorporation a. can use different depreciation methods for tax and financial reporting purposes b. must use the straight - line depreciation method for tax purposes and double declining depreciation method financial reporting purposes c. must use different depreciation method for tax purposes, but strictly mandated depreciation methods for financial reporting purposes d. can use straight- line depreciation method for tax purposes and macrs depreciation method financial reporting purposes

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