subject
Business, 08.07.2021 16:40 manman1773

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?

ansver
Answers: 2

Another question on Business

question
Business, 22.06.2019 11:30
(select all that apply) examples of email use that could be considered unethical include denying receiving an e-mail requesting that you work late forwarding a chain letter asking for donations to a good cause sending a quick message to your friend about last weekend sending your boss the monthly sales figures in an attachment setting up a meeting with your co-worker sharing a funny joke with other employees
Answers: 2
question
Business, 22.06.2019 19:00
Gus needs to purée his soup while it's still in the pot. what is the best tool for him to use? a. potato masher b. immersion blender c. rotary mixer d. whisk
Answers: 2
question
Business, 22.06.2019 21:30
Suppose that alexi and tony can sell all their street tacos for $2 each and all their cuban sandwiches for $7.25 each. if each of them worked 20 hours per week, how should they split their time between the production of street tacos and cuban sandwiches? what is their maximum joint revenue?
Answers: 3
question
Business, 23.06.2019 02:10
Which of the following best describes what production accomplishes? a. efficient use of natural resources. b. a reduction in the size of the labor force. c. an increase in supply that lowers prices. d. value added to resources that already exist.
Answers: 1
You know the right answer?
The file taxdata contains information from federal tax returns filed in 2007 for all counties in the...
Questions
question
Chemistry, 14.04.2020 22:47
question
English, 14.04.2020 22:47