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

Working with a word processor requires more than just a knowledge of typing. a good word processor includes a number of tools designed to aid in formatting documents to meet the needs of the reader. in this project you will use your word-processing skills and a basic knowledge of apa style to format a research paper. the skills you will need for this project include the following: adjusting line spacing (double-spacing) breaking text into pages (page break) centering text changing the font, style, and size of the text editing text inserting page numbers inserting a table using spell check

Answers: 1

Answer

Business, 22.06.2019 19:30

Quick calculate the roi dollar amount and percentage for these example investments. a. you invest $50 in a government bond that says you can redeem it a year later for $55. use the instructions in lesson 3 to calculate the roi dollar amount and percentage. (3.0 points) tip: subtract the initial investment from the total return to get the roi dollar amount. then divide the roi dollar amount by the initial investment, and multiply that number by 100 to get the percentage. b. you invest $200 in stocks and sell them one year later for $230. use the instructions in lesson 3 to calculate the roi dollar amount and percentage. (3.0 points) tip: subtract the initial investment from the total return to get the roi dollar amount. then divide the roi dollar amount by the initial investment, and multiply that number by 100 to get the percentage.

Answers: 2

Answer

Business, 22.06.2019 22:50

Clooney corp. establishes a petty cash fund for $225 and issues a credit card to its office manager. by the end of the month, employees made one expenditure from the petty cash fund (entertainment, $20) and three expenditures with the credit card (postage, $59; delivery, $84; supplies expense, $49).record all employee expenditures, and record the entry to replenish the petty cash fund. the credit card balance will be paid later. (if no entry is required for a transaction/event, select "no journal entry required" in the first account record expenditures from credit card and the petty cash fund.

Answers: 2

Answer

Business, 23.06.2019 00:10

Wang distributors has an annual demand for an airport metal detector of 1 comma 350 units. the cost of a typical detector to wang is $400. carrying cost is estimated to be 19% of the unit cost, and the ordering cost is $24 per order. if ping wang, the owner, orders in quantities of 300 or more, he can get a 10% discount on the cost of the detectors. should wang take the quantity discount? \

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