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

Other questions on the subject: Business

Business, 21.06.2019 23:00, E1nst31n44

You and your new australian bride matilda, are applying for a loan and are required to submit a balance sheet with your net worth. you own a 2008 toyota camry that you bought last month for $9,995. the kelly blue book value for this car is $13,995. you owe $8,150 on the car loan for the camry. you pay off your visa credit card every month and have not paid any credit card interest this year. the current visa credit card balance is $3,522, and the next statement is due in 15 days. you have a student loan balance of $6,500. you presently have $425 in your checking account and $1,540 in your savings account. you own 100 shares of ibm stock that you purchased for $85.50 per share. one share of ibm is now selling for $158.42. you own computers and other electronics that you purchased for $4,100 but could probably sell today on e-bay for $1,800. your gross income is $80,000 per year. what is your current net worth? (see wb ch. 2 example 2.3)

Answers: 1

continue

Business, 21.06.2019 23:30, BrezzyGirl9148

Afinancial institution, the thriftem bank, is in the process of formulating its loan policy for the next quarter. a total of $12 million is allocated for that purpose. being a full-service facility, the bank is obligated to grant loans to different clientele. the following table provides the types of loans, the interest rate charged by the bank, and the possibility of bad debt as estimated from past experience. type of loaninterest rateprobability of bad debtpersonal.140.10car.130.07home.1 20.03farm.125.05commercial.100.02 bad debts are assumed unrecoverable and hence produce no interest revenue either. competition with other financial institutions in the area requires that the bank allocate at least 40% of the total funds to farm and commercial loans. to assist the housing industry in the region, home loans must equal at least 50% of the personal, car, and home loans. the bank also has a stated policy specifying that the overall ratio for bad debts on all loans may not exceed .04. formulate this problem as a linear program. define your variables clearly and write all the constraints explaining the significance of each.

Answers: 1

continue

Business, 22.06.2019 08:30, cyaransteenberg

Blank is the internal operation that arranges information resources to support business performance and outcomes

Answers: 2

continue

Business, 22.06.2019 10:40, jonnaevans4856

You were able to purchase two tickets to an upcoming concert for $100 apiece when the concert was first announced three months ago. recently, you saw that stubhub was listing similar seats for $225 apiece. what does it cost you to attend the concert?

Answers: 1

continue

Do you know the correct answer?

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