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, 22.06.2019 22:40

Southeastern oklahoma state university's business program has the facilities and faculty to handle an enrollment of 2,000 new students per semester. however, in an effort to limit class sizes to a "reasonable" level (under 200 generally), southeastern's dean, holly lutze, placed a ceiling on enrollment of 1,600 new students. although there was ample demand for business courses last semester, conflicting schedules allowed only 1,440 new students to take business courses.the utilization rate for southeastern=%the efficiency rate for southeastern=%

Answers: 3

Answer

Business, 23.06.2019 00:00

Which example would the government consider as intellectual property? a. product design that contains a hologram of the logo of the company b. a copy of a famous artist’s painting in a new medium c. a plant species discovered in the united states for the first time d. a method of production that is common to an entire industry e. a discount structure offered to the customer at a store

Answers: 3

Answer

Business, 23.06.2019 10:00

Francesca opened a checking account at first bank one month ago. during the month she wrote 25 checks. first bank will charge her $.25 per check. this fee per check is called a a. service charge b. monthly charge c. transfer charge d. debit charge

Answers: 2

Answer

Business, 23.06.2019 13:30

Wyome has a career in manufacturing and goes to an office to work every day. at the office, he most likely works with

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