Question: MS Excel question 1. Compute the Average Adjusted Gross Income (In Thousands) and Average Wages and Salaries Income (In Thousands) for each county. Compute another

MS Excel question

1. Compute the Average Adjusted Gross Income (In Thousands) and Average Wages and Salaries Income (In Thousands) for each county. Compute another variable for each county that shows how many percent of the Adjusted Gross Income is coming from Wages and Salaries Income (Percentage of Wages and Salaries Income). In the report, only show ten rows from the table with the new columns. (IMPORTANT: Show the steps in Excel on how to do it)

State Abbreviation	County Name	Total Number of Tax Returns	Adjusted Gross Income (In Thousands)	Wages and Salaries Income (In Thousands)
AL	Autauga County	22651	$1052483	$824809
AL	Baldwin County	75255	$3913872	$2551398
AL	Barbour County	11644	$382539	$270389
AL	Bibb County	9379	$325458	$263779
AL	Blount County	23178	$941507	$729702
AL	Bullock County	4147	$108430	$82966

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Identify three of the documents required by the Securities Exchange Act of 1934 that are commonly encountered by auditors. Briefly describe the purpose of each of these documents

Hello, I have the attached assignment due on 11/29. Could you help? TAX CONFUSION AND FORM 1040 TURMOIL It was the night of April 14 and Daniel was pacing furiously around the house muttering to...

Hello, Please see the attached assignment and let me know if you can help TAX CONFUSION AND FORM 1040 TURMOIL It was the night of April 14 and Daniel was pacing furiously around the house muttering...

plz answer correctly Personal Budget Assignment Businesses use budgets to plan for the future. That's what you will be doing for this assignment. Rather than budgeting for your current financial...

this looks like a lot but its for one hw project! Personal Budget Assignment Businesses use budgets to plan for the future. That's what you will be doing for this assignment. Rather than budgeting...

Prepare an Excel sheet summary comparison summary that addresses the following: What type of pension fund does the state provide to employees How is the pension fund actually funded - who pays for it...

1. Monica and Thomas, ages 32 and 36, are married and file a joint return. In addition to having THREE dependent children (Lemisse, Cristine and James), Monica and Thomas have adjusted gross income...

Juan and Bettyna, ages 34 and 31, are married and file a joint return. In addition to having THREE dependent children (Talha, Maidelin, and Nicholas), Juan and Bettyna have adjusted gross income...

ohn and Elaine, ages 29 and 28, are married and file a joint return. In addition to having TWO dependent children (Jacqueline and Jesse), John and Elaine have adjusted gross income (AGI) of $90,000...

Please help! Magic entry amounts by quarter Amounts in thousands of US dollars Q1 Year 1 1,200 Q2 Year 1 700 Q3 Year 1 800 Q4 Year 1 1,400 Q1 Year 2 800 Question #1 (fill in the blank cells) Amounts...

Magic entry amounts by quarter Amounts in thousands of US dollars Q1 Year 1 1,200 Q2 Year 1 700 Q3 Year 1 800 Q4 Year 1 1,400 Q1 Year 2 800 Question #1 (fill in the blank cells) Amounts in thousands...

Brainstorm with your team members about what types of output are most appropriate for a variety of executives and high-level managers of Dizzyland, a large theme park in Florida. Include a list of...

Explain how current organizational structure and how that is damaging the business. Conflicts distract workers and cause less efficient work to be Task environment and general environment After...

If the NPV is a positive $ 5 0 , 0 0 0 and the discoumt rate is 1 0 % , the IRR is A . greater than 1 0 % B . less than 1 0 % C . 1 2 % D . only Boudreaux knows

You are buying $10,000 of merchandise. You receive the following discount terms: 3/10 Net 30. What is the equivalent APR of that discount? If a bank will finance the purchase at 24% interest, should...