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 14:30

When marietta chooses to only purchase a combination of goods that lie within her budget line, she: is decreasing utility. is maximizing utility. likely has negative savings. must reduce the quantity?

Answers: 2

Answer

Business, 21.06.2019 21:00

Captain john's yachts, inc., located in fort lauderdale, florida, rents three types of ocean-going boats: sailboats, cabin cruisers, and captain john's favorite, the luxury yachts. captain john advertises his boats with his famous "you rent"we pilot" slogan, which means that the company supplies the captain and crew for each rented boat. each rented boat has one captain, of course, but the crew sizes (deck hands, galley hands, etc.) differ. the crew requirements, in addition to a captain, are one for sailboats, two for cabin cruisers, and three for yachts. ten employees are captains, and an additional 18 employees fill the various crew positions. currently, captain john has rental requests for all his boats: four sailboats, eight cabin cruisers, and three luxury yachts. if captain john's daily profit contribution is $50 for sailboats, $70 for cruisers, and $100 for luxury yachts, how many boats of each type should he rent?

Answers: 2

Answer

Business, 22.06.2019 03:40

Your parents have accumulated a $170,000 nest egg. they have been planning to use this money to pay college costs to be incurred by you and your sister, courtney. however, courtney has decided to forgo college and start a nail salon. your parents are giving courtney $20,000 to her get started, and they have decided to take year-end vacations costing $8,000 per year for the next four years. use 8 percent as the appropriate interest rate throughout this problem. use appendix a and appendix d for an approximate answer, but calculate your final answer using the formula and financial calculator methods. a. how much money will your parents have at the end of four years to you with graduate school, which you will start then?

Answers: 1

Answer

Business, 22.06.2019 13:10

Trey morgan is an employee who is paid monthly. for the month of january of the current year, he earned a total of $4,538. the fica tax for social security is 6.2% of the first $118,500 earned each calendar year, and the fica tax rate for medicare is 1.45% of all earnings for both the employee and the employer. the amount of federal income tax withheld from his earnings was $680.70. his net pay for the month is .

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