question 3 please!

Help with solving queation 3 and 4 please!

7598 ... Clipboard Font Format as Alignment Number Cell Styles 3. The attached spreadsheet contains the Gini coefficient for households each year from 1967 to 2019. In what year does the Gini index indicate the most equitable distribution of wealth? SI C6 1995 (25) D b. For that year, solve forn, and write the Lorenz function in the form f(x)=x" 25 C. According to the model, what percentage of the wealth was owned by the least wealthy 50% of households in 2019? 0.250 1200 2 9 To 4 000 00 d. According the model, what percentage of the wealth was owned by the wealthiest 19 of households in 2019? 1320 04 04 C Table H-4 Gini Indexes for Households:1967 to 2019 Year 200 Gint Index 1987 DE 6 20 7 460199824 0472 0 11/2017 09 12200 1401 870 151200 00 106 16 172000 1600 6941 193005 1.03.18 60 2020 212004 2220 320 ta 101 M2001 000 25-1001 ST 27 015 28 20 0230 ST 29323 33 Get 1962 34 4. Between what two years is there the greatest change in the Gini coefficient? * What was the change in the percentage of wealth owned by the wealthiest of households over those two years? 04 0414 og DE 404 000 0 26 Use the data from the Household Income 2019 report to answer the following questions. 5. Identify the estimated Gini coefficient for Connecticut households in 2012 a Solve forn, and write the Lorenz function in the form 70 - 015 39 b. According to the model what percentage of the wealth was owned by the least wealthy 50% of Connecticut households in 2019 h04 Styles F29 X fx B D E 9 2015 2 Table H-4. Gini Indexes for Households:1967 to 2019 3 Year Gini Index 42 0484 1997 5 2015 0486/1996 6 2017 201 0.489 1995125) 7 2017 8 2016 0.482 1994 T24 0.481 1983 (23) 0479 1982 (22) 10 2014 0.480 1991 112013739) 12 2013 (38) 0.482 1990 13 2012 0.476 1989 14 2011 0.477/1988 15 2010 (371 0.477 1887 (21) 16 2009 (36) 04701395 17 2008 0.468 1885 (20) 0466 984 (19) 18 2007 19/2006 0.4637983 20 2005 0.470 1982 0.469 1981 21 2004 (35) 22 2003 0.466 7980 23 2002 0.464 1979 (18) 24 2001 0462 1978 25 2000 (30) 0.466 1977 26 1999 (29) 0.462 1976 (17) 27 1998 0.458 1975 (15) 2811937 0.456 1974 [15 (15) 291996 0.459 1373 30 1395 251 0.455 1972 (14) 31 1994 124 0450 1971131 32 1993 (23) 0.456 1970 33 1582122) 0454 1969 34 1991 0433 1968 35 0428 1957 (121 36 37 38 39 0.459 0455 0.450 0.456 0454 0.433 0429 0.429 0.431 0.426 0.425 0.425 0.419 0415 0.414 0412 0.406 0403 0.404 0.402 0.402 0.398 0.397 0.395 0.400 0.401 0.396 0.394 0.391 0386 0.397 h04 Ready b. According to the model, what percentage of the wealth was owned by the least wealthy 50% of households in 2019? c. According the model, what percentage of the wealth was owned by the wealthiest 1% of households in 2019? 3. The attached spreadsheet contains the Gini coefficient for households each year from 1967 to 2019. a. In what year does the Gini index indicate the most equitable distribution of wealth? b. For that year, solve for n, and write the Lorenz function in the form f(x) = x". C. According to the model, what percentage of the wealth was owned by the least wealthy 50% of households in 2019? d. According the model, what percentage of the wealth was owned by the wealthiest 1% of households in 2019? 4. Between what two years is there the greatest change in the Gini coefficient? a. What was the change in the percentage of wealth owned by the wealthiest 1% of households over those two years? and C8 1993 (23) D B 2 Table H-4. Gini Indexes for Households:1967 to 2019 3 Year Gini Index 4 2013 0.484 1997 5 2018 0.486 1995 6. 2017 (40) 0.489 1995 (25) 7 2017 0.482 1994 (24) 8 2016 9 2015 0481 1993 (23) 10 2014 0.479 1992 (22) 11 2013 (39) 0.480. 1991 0.482 1990 12 2013 (38) 13 2012 0.476 1989 14 2011 0.477 1988 15 2010 (37) 0.477 1987 (21) 16 2009 (36) 0.470 1986 17 2008 0.468 1985 (20) 18 2007 0466 7984 (19) 19 2006 0.463 1983 20 2005 0.470 1982 21 2004 (35) 0.469 1981 22 2006 0.466 1980 23 2002 0 464 1979 (18) 24 2001 0.462 1978 25 2000 (30) 0.466 1977 26 1999 (29) 0.462 1976 (17) 27 1938 0.458 1975 (15) 28 1997 0.456 1974 (16)(15) 29 1896 0.459 1973 30 1995 125 0.455 1972 (14) 31 1894 124 0 450 1971 (13) 32 1993 (23 0.456. 1970 33 1992 (22) 0454 1969 34 1991 0.433 1968 35 0.428 1967 (12) 36 37 38 39 0.459 0.455 0.450 0.456 0.454 0.433 0.428 0.428 0.431 0.426 0.426 0.425 0.419 0.415 0.414 0.412 0.406 0.403 0404 0.402 0.402 0.398 0.397 0.395 0.400 0.401 0.396 0.394 0.391 0.386 0.397 h04 7598 ... Clipboard Font Format as Alignment Number Cell Styles 3. The attached spreadsheet contains the Gini coefficient for households each year from 1967 to 2019. In what year does the Gini index indicate the most equitable distribution of wealth? SI C6 1995 (25) D b. For that year, solve forn, and write the Lorenz function in the form f(x)=x" 25 C. According to the model, what percentage of the wealth was owned by the least wealthy 50% of households in 2019? 0.250 1200 2 9 To 4 000 00 d. According the model, what percentage of the wealth was owned by the wealthiest 19 of households in 2019? 1320 04 04 C Table H-4 Gini Indexes for Households:1967 to 2019 Year 200 Gint Index 1987 DE 6 20 7 460199824 0472 0 11/2017 09 12200 1401 870 151200 00 106 16 172000 1600 6941 193005 1.03.18 60 2020 212004 2220 320 ta 101 M2001 000 25-1001 ST 27 015 28 20 0230 ST 29323 33 Get 1962 34 4. Between what two years is there the greatest change in the Gini coefficient? * What was the change in the percentage of wealth owned by the wealthiest of households over those two years? 04 0414 og DE 404 000 0 26 Use the data from the Household Income 2019 report to answer the following questions. 5. Identify the estimated Gini coefficient for Connecticut households in 2012 a Solve forn, and write the Lorenz function in the form 70 - 015 39 b. According to the model what percentage of the wealth was owned by the least wealthy 50% of Connecticut households in 2019 h04 Styles F29 X fx B D E 9 2015 2 Table H-4. Gini Indexes for Households:1967 to 2019 3 Year Gini Index 42 0484 1997 5 2015 0486/1996 6 2017 201 0.489 1995125) 7 2017 8 2016 0.482 1994 T24 0.481 1983 (23) 0479 1982 (22) 10 2014 0.480 1991 112013739) 12 2013 (38) 0.482 1990 13 2012 0.476 1989 14 2011 0.477/1988 15 2010 (371 0.477 1887 (21) 16 2009 (36) 04701395 17 2008 0.468 1885 (20) 0466 984 (19) 18 2007 19/2006 0.4637983 20 2005 0.470 1982 0.469 1981 21 2004 (35) 22 2003 0.466 7980 23 2002 0.464 1979 (18) 24 2001 0462 1978 25 2000 (30) 0.466 1977 26 1999 (29) 0.462 1976 (17) 27 1998 0.458 1975 (15) 2811937 0.456 1974 [15 (15) 291996 0.459 1373 30 1395 251 0.455 1972 (14) 31 1994 124 0450 1971131 32 1993 (23) 0.456 1970 33 1582122) 0454 1969 34 1991 0433 1968 35 0428 1957 (121 36 37 38 39 0.459 0455 0.450 0.456 0454 0.433 0429 0.429 0.431 0.426 0.425 0.425 0.419 0415 0.414 0412 0.406 0403 0.404 0.402 0.402 0.398 0.397 0.395 0.400 0.401 0.396 0.394 0.391 0386 0.397 h04 Ready b. According to the model, what percentage of the wealth was owned by the least wealthy 50% of households in 2019? c. According the model, what percentage of the wealth was owned by the wealthiest 1% of households in 2019? 3. The attached spreadsheet contains the Gini coefficient for households each year from 1967 to 2019. a. In what year does the Gini index indicate the most equitable distribution of wealth? b. For that year, solve for n, and write the Lorenz function in the form f(x) = x". C. According to the model, what percentage of the wealth was owned by the least wealthy 50% of households in 2019? d. According the model, what percentage of the wealth was owned by the wealthiest 1% of households in 2019? 4. Between what two years is there the greatest change in the Gini coefficient? a. What was the change in the percentage of wealth owned by the wealthiest 1% of households over those two years? and C8 1993 (23) D B 2 Table H-4. Gini Indexes for Households:1967 to 2019 3 Year Gini Index 4 2013 0.484 1997 5 2018 0.486 1995 6. 2017 (40) 0.489 1995 (25) 7 2017 0.482 1994 (24) 8 2016 9 2015 0481 1993 (23) 10 2014 0.479 1992 (22) 11 2013 (39) 0.480. 1991 0.482 1990 12 2013 (38) 13 2012 0.476 1989 14 2011 0.477 1988 15 2010 (37) 0.477 1987 (21) 16 2009 (36) 0.470 1986 17 2008 0.468 1985 (20) 18 2007 0466 7984 (19) 19 2006 0.463 1983 20 2005 0.470 1982 21 2004 (35) 0.469 1981 22 2006 0.466 1980 23 2002 0 464 1979 (18) 24 2001 0.462 1978 25 2000 (30) 0.466 1977 26 1999 (29) 0.462 1976 (17) 27 1938 0.458 1975 (15) 28 1997 0.456 1974 (16)(15) 29 1896 0.459 1973 30 1995 125 0.455 1972 (14) 31 1894 124 0 450 1971 (13) 32 1993 (23 0.456. 1970 33 1992 (22) 0454 1969 34 1991 0.433 1968 35 0.428 1967 (12) 36 37 38 39 0.459 0.455 0.450 0.456 0.454 0.433 0.428 0.428 0.431 0.426 0.426 0.425 0.419 0.415 0.414 0.412 0.406 0.403 0404 0.402 0.402 0.398 0.397 0.395 0.400 0.401 0.396 0.394 0.391 0.386 0.397 h04