Business, 03.06.2021 16:40 saigecc14

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? (Hint: To sort data in a PivotTable in Excel, right-click any cell in the PivotTable that contains the data you want to sort, and select Sort.)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 19:40

Bear, inc. estimates its sales at 200,000 units in the first quarter and that sales will increase by 20,000 units each quarter over the year. they have, and desire, a 25% ending inventory of finished goods. each unit sells for $35. 40% of the sales are for cash. 70% of the credit customers pay within the quarter. the remainder is received in the quarter following sale. cash collections for the third quarter are budgeted at

Answers: 3

Answer

Business, 21.06.2019 20:40

•broussard skateboard’s sales are expected to increase by 15% from $8 million in 2016 to $9.2 million in 2017. its assets totaled $5 million at the end of 2016. broussard is already at full capacity, so its assets must grow at the same rate as projected sales. at the end of 2016, current liabilities were $1.4 million, consisting of $450,000 of accounts payable, $500,000 of notes payable, and $450,000 of accruals. the after-tax profit margin is forecasted to be 6%, and the forecasted payout ratio is 40%. use the afn equation to forecast broussard’s additional funds needed for the coming year

Answers: 2

Answer

Business, 21.06.2019 23:30

Which alternative accounting method allows farmers to record expenses and incomes in the year in which they sell their yield? gaap allows for the method, which permits farmers to subtract the expenses of producing the crop in the year in which they sell the yield and earn the revenue.

Answers: 3

Answer

Business, 22.06.2019 01:30

Ben collins plans to buy a house for $166,000. if the real estate in his area is expected to increase in value by 2 percent each year, what will its approximate value be five years from now?

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