Business, 22.02.2021 19:20 MJKjmkp1

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 questions below. 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: 3

Show answers

Another question on Business

Business, 21.06.2019 19:30

How does knowing about supply and demand

Answers: 1

Answer

Business, 22.06.2019 19:00

1. what must one do to perform the essential managerial task of controlling in achieving organizational goals? a. motivate, coordinate, and energize individuals and groups to work together to achieve organizational goals b. choose appropriate organizational goals and courses of action to best achieve those goals c. establish task and authority relationships that allow people to work together to achieve organizational goals d. establish accurate measuring and monitoring systems to evaluate how well the organization has achieved its goals

Answers: 1

Answer

Business, 23.06.2019 13:30

Cvp analysis, shoe stores. the highstep shoe company operates a chain of shoe stores that sell 10 different styles of inexpensive men's shoes with identical unit costs and selling prices. a unit is defined as a pair of shoes. each store has a store manager who is paid a fixed salary. individual salespeople receive a fixed salary and a sales commission. highstep is considering opening another store that is expected to have the revenue and cost relationships shown here.

Answers: 2

Answer

Business, 23.06.2019 14:30

Anew japanese restaurant opens two blocks from your home. the owner, reiko, is a personal friend of yours. you don't particularly like japanese food, but you decide to go anyway; however, there is nothing on the menu that sounds appealing. unfortunately, it turns out that most of the people in your town don't like japanese cuisine either. reiko confides that business is not good, but she isn't sure what to do from an economic standpoint. which of the following would most likely describe adam smith's perspective on this problem? select one: a. reiko should ask the government for assistance. b. reiko should close the restaurant and find a different career. c. reiko should lay off workers and do everything herself to save money. d. reiko should add other foods to the menu and offer discounts to attract more people to her restaurant.

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