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, 22.06.2019 02:00

What is the main role of ctsos at the local level? at the local level, the main role of ctsos is to encourage students to become urge them to programs and competitive events.1. a.internsb.traineesc.members2.a.participateb.trainc.win

Answers: 3

Answer

Business, 22.06.2019 13:50

Which one of the following statements is true? ddt does not prevent disease from passing from agricultural animals to humans. cost was a major factor in the united states government's decision to ban ddt. many african governments concluded that the potential long-term health effects of ddt were not as serious as the immediate problem of insect control. ddt cannot accumulate in the fat of animals. the ddt ban in the united states has made it very difficult to control agricultural insect pests.

Answers: 3

Answer

Business, 22.06.2019 14:20

Cardinal company is considering a project that would require a $2,725,000 investment in equipment with a useful life of five years. at the end of five years, the project would terminate and the equipment would be sold for its salvage value of $400,000. the company’s discount rate is 14%. the project would provide net operating income each year as follows: sales $2,867,000 variable expenses 1,125,000 contribution margin 1,742,000 fixed expenses: advertising, salaries, and other fixed out-of-pocket costs $706,000 depreciation 465,000 total fixed expenses 1,171,000 net operating income $571,000 1. which item(s) in the income statement shown above will not affect cash flows? (you may select more than one answer. single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. any boxes left with a question mark will be automatically graded as incorrect.) (a)sales (b)variable expenses (c) advertising, salaries, and other fixed out-of-pocket costs expenses (d) depreciation expense 2. what are the project’s annual net cash inflows? 3.what is the present value of the project’s annual net cash inflows? (use the appropriate table to determine the discount factor(s) and final answer to the nearest dollar amount.) 4.what is the present value of the equipment’s salvage value at the end of five years? (use the appropriate table to determine the discount factor(s) and final answer to the nearest dollar amount.) 5.what is the project’s net present value? (use the appropriate table to determine the discount factor(s) and final answer to the nearest dollar amount.)

Answers: 2

Answer

Business, 22.06.2019 21:20

What business practice contributed most to andrew carnegie’s ability to form a monopoly?

Answers: 1

Answer

You know the right answer?

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

Questions