Business, 22.02.2021 19:20 MJKjmkp1

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 questions below. 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: 3

Show answers

Another question on Business

Business, 21.06.2019 16:00

Danny "dimes" donahue is a neighborhood's 9-year-old entrepreneur. his most recent venture is selling homemade brownies that he bakes himself. at a price of $2 each, he sells 100. at a price of $1.5 each, he sells 300. instructions: round your answer to 1 decimal place. a. what is the elasticity of demand? 3.50 â± 0.1 . b. is demand elastic or inelastic over this price range? . c. if demand had the same elasticity for a price decline from $1.5 to $1 as it does for the decline from $2 to $1.5, would cutting the price from $1.5 to $1 increase or decrease danny's total revenue? .

Answers: 1

Answer

Business, 22.06.2019 20:30

Contrast two economies that transitioned to capitalism and explain what factors affected the ease kf their transition as welas the “face” of capitalism that each has adopted

Answers: 2

Answer

Business, 23.06.2019 01:10

Mountain mouse makes freeze-dried meals for hikers. one of mountain mouse's biggest customers is a sporting goods superstore. every 66 days, mountain mouse checks the inventory level at the superstore and places an order to restock the meals. these meals are delivered by ups in 55 days. average demand during the reorder period and order lead time is 8585 meals, and the standard deviation of demand during this same time period is about 1919 meals.calculate the restocking level for mountain mouse. assume that the superstore wants a 95\% service level. what happens to the restocking level if the superstore wants a higher level of service-say, 99]%? the restocking level for the 95% service level is 117 mealssuppose there are 25 meals in the superstore when mountain mouse checks inventory levels. how many meals should be ordered, assuming a 95% service level?

Answers: 3

Answer

Business, 23.06.2019 03:30

Jiffy printing shops does a lot of printing job for college students. the shop use an average of 25 cases of copy paper each day during the 312 days last year. the shop opens 6 days a week for 52 weeks each year and closes on sundays. each case of paper costs $35. it conducts a count of its paper inventory at the end of every quarter of the year. the table below shows the inventory counting records for last year. inventory end of quarter 1 700 cases end of quarter 2 1,050 cases end of quarter 3 920 cases end of quarter 4 800 cases 1. what's jiffy's cost of goods sold last year? 2. what's jiffy's average aggregate inventory value? 3. what's jiffy's inventory turnover last year? 4. what is the printing shop's weeks of supply last year?

Answers: 2

Answer

You know the right answer?

The file TaxData contains information from federal tax returns filed in 2007 for all counties in the...

Questions