Make sure you use American Community Survey S1901 data (2020: ACS 5-Year Estimates Subject Tables -...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Make sure you use American Community Survey S1901 data (2020: ACS 5-Year Estimates Subject Tables - do not use ACS 1-year averages or others) and use household incomes. Also, for some counties, the names may be case sensitive (New York vs. new york). Be extra careful and always check on the left that you have the data for the correct county (if you mistype, it will automatically use National data). There will no credit it you use wrong data! Calculate the income GINI coefficient for households in Queens County. Do the same for the other remaining 10 counties. You need to calculate a total of 11 GINI coefficients. Show your work on 11 different Excel worksheets. Also calculate the respective mean/median income ratios. Make sure you use American Community Survey S1901 data (2020: ACS 5-Year Estimates Subject Tables - do not use ACS 1-year averages or others) and use household incomes. Also, for some counties, the names may be case sensitive (New York vs. new york). Be extra careful and always check on the left that you have the data for the correct county (if you mistype, it will automatically use National data). There will no credit it you use wrong data! Calculate the income GINI coefficient for households in Queens County. Do the same for the other remaining 10 counties. You need to calculate a total of 11 GINI coefficients. Show your work on 11 different Excel worksheets. Also calculate the respective mean/median income ratios.
Expert Answer:
Answer rating: 100% (QA)
how to calculate the income GINI coefficient and meanmedian income ratios using the American Community Survey ACS S1901 data for households in Queens ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these economics questions
-
Having read the material in Sentence-Level Stylistics, share the following: What was unsurprising? In other words, what did you know or suspect already that you already practice and find easy to...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
There were no other non-current assets acquisitions or disposals. A dividend of 150m was paid on ordinary shares during the year. Required a) Prepare a cash flow statement for Blackheath plc for the...
-
AvtoVAZ OAO, a leading auto manufacturer in Russia, was launching a new automobile model in 2001, and is in the midst of completing a complete pricing analysis of the car for sales in Russia and...
-
A company that makes granola and other "healthy" snacks has the following mission statement: "Our goal is to profitably sell good-tasting, healthy products and to better society." Although its...
-
A large company has the opportunity to select one of seven projects-A, B, C, D, E, F, G-or choose the null (donothing) alternative. Each project requires a single initial investment as shown in the...
-
Using the planned orders generated in Problem 17, complete inventory records for components AB501, AB511, and AB521. Use the lot size rule, lead time, and usage information given in Problem 12.
-
In one month Ashton earned $800 at her part-time job, and $80 was withheld for federal income tax. Suppose she earns $1200 next month. How much will be withheld for federal income tax?
-
Jenny and Max are involved in an intimate relationship although Max is married. They decided that they should spice up their sex lives and engage in consensual sexual activities that included...
-
Julia is appointed as the Project Manager for a new software development project. In the first week, she sets up a meeting between the team she has been assigned, the client, and the development team...
-
An arrow is fired horizontally at 37.7 m towards the target. The arrow takes 0.456 seconds to reach the target. i. Calculate the distance from the archer to the target. Assume negligible air...
-
A force F = bx acts in the x direction, where the value of b is 3.70 N/m. How much work is done in Joules by this force in moving an object from to x = 0.000m to x = 2.600 m Do not enter the units.
-
Many companies are going beyond government regulation and are developing strategies and practices that create a world economy that the planet can support indefinitely. This represents O A....
-
Question 12 Which strategy, used to achieve the hybridization of global standards and local norms, provides local HR managers the authority to adjust global HR policies and procedures to match the...
-
What is the IUPAC name for the major product of the following reaction? H*, H,0 dilute aqueous acid Answer:
-
The Strahler Stream Order System ranks streams based on the number of tributaries that have merged. It is a top-down system where rivers of the first order are the headwaters (aka outermost...
-
Leslie and Leon Lazo are married and file a joint return for 2012. Leslie's Social Security number is 466-47-3311 and Leon's is 467-74-4451. They live at 143 Snapdragon Drive, Reno, NV 82102. For...
-
Ann hires a nanny to watch her two children while she works at a local hospital. She pays the 19-year-old nanny $125 per week for 48 weeks during the current year. a. What is the employer's portion...
-
a. Wilson filed his individual tax return on the original due date, but failed to pay $700 in taxes that were due with the return. If Wilson pays the taxes exactly 2 months late, calculate the amount...
-
Ariad Pharmaceuticals, Inc. (Ariad), is a small Cambridge-based pharmaceutical company whose shares are traded on the Nasdaq exchange. Maureen Curran joined Ariad in 2006 and eventually became the...
-
John Marshall and Alan Tucker began working together at Marshalls financial consulting firm in approximately 1995, and they renamed the firm Marshall, Tucker & Associates, LLC. In addition to working...
-
The Brian B. Sand & Zachary B. Sand Joint Trust (the Trust) sued the Biotechnology Value Fund (BVF) under Section 16(b) of the Securities Exchange Act of 1934. Mark Lampert controlled BVF as well as...
Study smarter with the SolutionInn App