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
Other questions on the subject: Business
Business, 22.06.2019 11:30, khynia11
Given the following information about the closed economy of brittania, what is the level of investment spending and private savings, and what is the budget balance? assume there are no government transfers. gdp=$1180.00 million =$510.00 million =$380.00 million =$280.00 million
Answers: 3
Business, 22.06.2019 12:20, kayleewoodard
Alarge university wanted to study the relationship between completing an internship during college and students' future earning potential. prom the same graduating class, they selected a random sample of 80 students who completed an internship and 100 students who did not complete an internship and examined their salaries five years after graduation. they found that there was a statistically higher mean salary for the internship group than for the noninternship group. which of the following interpretations is the most appropriate? a. there could be a confounding variable, such as student major, that explains the difference in mean salary between the internship and no internship groups. b. we cannot infer anything from these data since the distribution of salaries is likely right skewed. c. you cannot draw any valid conclusions because the sample sizes are different. d. more students should complete internships because having an internship produces a higher salary.
Answers: 1
Business, 22.06.2019 18:00, judali
David paid $975,000 for two beachfront lots in coastal south carolina, with the intention of building residential homes on each. two years later, the south carolina legislature passed the beachfront management act, barring any further development of the coast, including david's lots. when david files a complaint to seek compensation for his property, south carolina refuses, pointing to a passage in david's own complaint that states "the beachfront management act [was] properly and validly designed to south carolina's " is south carolina required to compensate david under the takings clause?
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 in other subjects:
Arts, 12.02.2020 00:38
Mathematics, 12.02.2020 00:38
Mathematics, 12.02.2020 00:38
Mathematics, 12.02.2020 00:38
Spanish, 12.02.2020 00:38
