Question: based on part 1 to answer part 2, use python to find the following and calculate the proportion in which PUMAs, the median income of

based on part 1 to answer part 2, use python to find the following and calculate the proportion

in which PUMAs, the median income of R65=0> R65=1 and R65=2

the median income of R65=1> R65=0 and R65=2

the median income of R65=2> R65=1 and R65=0

write down the code

based on part 1 to answer part 2, use python to find the following and calculate the proportion in which PUMAs, the median income

Part 1 The ACS "PUMA" variable defines a collection of geographically contiguous areas of the United States, each containing around 100,000 people. Using the R65 variable, calculate the median household income per PUMA within each of three subpopulations: A) households with nobody of age 65 and over; B) households with (exactly) 1 person of age 65 and over; and C) households with 2 or more people of age 65 and over (consult the data dictionary to see how the R65 variable encodes this information). ta df. groupby ( ['R65', PUMA']) ['HINCP'). agg (np. median). unstack() PUMA 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 R65 0.0 60000.0 69000.0 82350.0 75000.0 62700.0 98000.0 92010.0 104000.0 114000.0 135370.0 134000.0 102000.0 144000.0 104000.0 69000.0 60000.0 58300.0 65000.0 43000.0 52500.0 100000.0 56000.0 30000.0 48250.0 42000.0 42000.0 75500.0 70000.0 100465.0 99500.0 62500.0 72100.0 91400.0 68000.0 1.0 33000.0 39000.0 47000.0 49300.0 37700.0 60000.0 76800.0 58030.0 42000.0 76300.0 55000.0 69900.0 84500.0 36870.0 54000.0 36000.0 37200.0 44800.0 24500.0 32200.0 28550.0 35650.0 45840.0 50700.0 34100.0 50600.0 43150.0 51500.0 24650.0 50100.0 29750.0 26200.0 45175.0 43670.0 2.0 55200.0 72200.0 71610.0 67850.0 65515.0 71840.0 59100.0 72000.0 125700.0 85400.0 115500.0 71300.0 74400.0 100400.0 47100.0 80250.0 133250.0 114300.0 36600.0 24200.0 119500.0 54400.0 53225.0 65800.0 26700.0 93750.0 73350.0 40400.0 55000.0 80900.0 61500.0 63200.0 53400.0 62200.0 3 rows x 982 columns Part 2 In what proportion of the PUMAs does group A have the highest median household income among the three groups? In what proportion does group B have the highest median household income? Group C? [1691 Part 1 The ACS "PUMA" variable defines a collection of geographically contiguous areas of the United States, each containing around 100,000 people. Using the R65 variable, calculate the median household income per PUMA within each of three subpopulations: A) households with nobody of age 65 and over; B) households with (exactly) 1 person of age 65 and over; and C) households with 2 or more people of age 65 and over (consult the data dictionary to see how the R65 variable encodes this information). ta df. groupby ( ['R65', PUMA']) ['HINCP'). agg (np. median). unstack() PUMA 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 R65 0.0 60000.0 69000.0 82350.0 75000.0 62700.0 98000.0 92010.0 104000.0 114000.0 135370.0 134000.0 102000.0 144000.0 104000.0 69000.0 60000.0 58300.0 65000.0 43000.0 52500.0 100000.0 56000.0 30000.0 48250.0 42000.0 42000.0 75500.0 70000.0 100465.0 99500.0 62500.0 72100.0 91400.0 68000.0 1.0 33000.0 39000.0 47000.0 49300.0 37700.0 60000.0 76800.0 58030.0 42000.0 76300.0 55000.0 69900.0 84500.0 36870.0 54000.0 36000.0 37200.0 44800.0 24500.0 32200.0 28550.0 35650.0 45840.0 50700.0 34100.0 50600.0 43150.0 51500.0 24650.0 50100.0 29750.0 26200.0 45175.0 43670.0 2.0 55200.0 72200.0 71610.0 67850.0 65515.0 71840.0 59100.0 72000.0 125700.0 85400.0 115500.0 71300.0 74400.0 100400.0 47100.0 80250.0 133250.0 114300.0 36600.0 24200.0 119500.0 54400.0 53225.0 65800.0 26700.0 93750.0 73350.0 40400.0 55000.0 80900.0 61500.0 63200.0 53400.0 62200.0 3 rows x 982 columns Part 2 In what proportion of the PUMAs does group A have the highest median household income among the three groups? In what proportion does group B have the highest median household income? Group C? [1691

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 Databases Questions!

Part 1 - Written Answer (Be sure to show all your work) Question 1 [12 Points] The height of elephants are approximately Normal, with a mean of 2.5 metres and standard deviation of 0.5 metres. For...

In a quality control test of parts manufactured at Dabco Corporation, an engineer sampled parts produced on the first, second, and third shifts. The research study was designed to determine if the...

Can someone assist with any of these questions below: Question 1.The time required to play a certain game is uniformly distributed between 30 and 52 minutes. Complete parts a through c below. a. Find...

Your First and Last Name Portfolio Project MATH201 College Mathematics: Quantitative Reasoning Instructor's Name Date The highlighted areas should be deleted before submission as they are directions....

I am so lost with all of this and the worst part it is due in an hour and a half. I don't know what to do please help. In this course you will have the opportunity to apply the concepts learned to a...

Project Description and requirements: Part A: Group work(50%) This is group project with a group size of 2 to 3 members. Each group will work on a continuous data set that has a minimum of 50 values....

Hi there, I need to answer question question three. I have completed part1 but haven't done part 2,3 and 4 for question 3: Financial statement analysis below i have attached my work which you will...

The company selected is Molina Healthcare, Inc. Part 1: Your answer to my question ( 250 word minimum) Each of you should access the annual report for Form 10K filed with the SEC) for one publicly...

I need assistance with the script. Theres are several steps. 1. Part I: Descriptive Statistics (Scenario A) Scenario A: National Weather Service Note: The following information and instructions apply...

MUST SHOW WORK FOR PROBLEMS 40 - 50 Part A: Multiple Choice (1-16) Using the following information to answer questions 1-8: 2 _____1. a) 1.90 _____2. 1 3 0 1 2 0 5 1 4 What is the mean? b) 2.11 What...

A. What is the equilibrium price in this market? $________ At what price is there neither a shortage nor a surplus? $________ B. Graph the demand for wheat and the supply of wheat. Be sure to locate...

1.The incidence of as sales tax will be more on the buyers of the product if a.. the price elasticity of demand is low b. the income elasticity of demand is low c. the price elasticity of demand is...

An investor is considering the purchase of 1 0 0 shares of XYZ Company stock at $ 4 5 per share. The stock is expected to pay dividends at the end of each year of $ 2 2 0 , $ 2 5 0 , and $ 2 7 5 ....

In order to determine inventory for it's balance sheet, it is best for a company to count the inventory at the end of the accounting period for the periodic inventory system. the perpetual inventory...

10. What is organization development? Describe the interventions used to create change.

1. Interview a manager. Ask him to evaluate his companys training department in terms of training delivery, service, expertise, and contribution to the business. Ask him to explain the rationale for...

9. Explain what you believe are the advantages and disadvantages of creating a training consortium or partnership with other companies.