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:40

Oceanside marine company manufactures special metallic materials and decorative fittings for luxury yachts that require highly skilled labor. oceanside uses standard costs to prepare its flexible budget. for the first quarter of the year, direct materials and direct labor standards for one of their popular products were as follows: direct materials: 2 pound per unit; $ 11 per pound direct labor: 2 hours per unit; $ 19 per hour oceanside produced 2 comma 000 units during the quarter. at the end of the quarter, an examination of the direct materials records showed that the company used 7 comma 500 pounds of direct materials and actual total materials costs were $ 98 comma 100. what is the direct materials cost variance? (round any intermediate calculations to the nearest cent, and your final answer to the nearest dollar.)

Answers: 1

Answer

Business, 22.06.2019 09:50

Beck company had the following accounts and balances at the end of the year. what is net income or net loss for the year? cash $ 74 comma 000 accounts payable $12,000 common stock $21,000 dividends $12,000 operating expenses $ 13 comma 000 accounts receivable $ 49 comma 000 inventory $ 47 comma 000 longminusterm notes payable $33,000 revenues $ 91 comma 000 salaries payable $ 30 comma 000

Answers: 1

Answer

Business, 22.06.2019 16:10

Omnidata uses the annualized income method to determine its quarterly federal income tax payments. it had $100,000, $50,000, and $90,000 of taxable income for the first, second, and third quarters, respectively ($240,000 in total through the first three quarters). what is omnidata's annual estimated taxable income for purposes of calculating the third quarter estimated payment?

Answers: 1

Answer

Business, 22.06.2019 21:30

Which of the following best explains why online retail companies have an advantage over regular stores? a. their employees make less money because they mostly perform unskilled tasks. b. they are able to keep distribution costs low by negotiating deals with shipping companies. c. their transactions require expensive state-of-the-art technological devices. d. they have a larger number of potential customers because people anywhere can buy from them.

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