attachment_23.docx

First Name Last Name Section (9:05am OR 10:45am)

Part I “Lies, Damn Lies and Statistics”

Q4

Mean

Median

1

Total net worth

746.82

2

Total assets

225.50

3

Total debt

4

Primary residence

5

Residential property excluding primary residence

6

Debt secured by primary residence

75.97

7

Debt secured by other residential property

8

Age

9

Income

10

Directly held stocks

11

“housing”

130.00

12

“mortgages”

85.53

Q 5 – 11

5

6

7

8

9

10

11

H/A

0.6433

0.5158

M/D

0.7949

0.8668

0.4757

H/NW

1.0677

0.5511

Q 12

Top 10% income

0.4655

Top 10% housing

Top 10% stocks

Part II Visualizing the impossible

1. Put plots here in the order of the question

a. homeownership rate

b. net worth

c. Assets and parts. You can combine (like I did in the example) but do not plot two lines on one axis plane (scale will be off)

i. (1) assets

ii. (2) stocks

iii. (3) non-stock financial assets (fin assets minus stocks)

iv. (4) housing

v. (5) non-housing non-financial assets (non-financial assets minus housing)

d. Debt and parts

i. (1) debt

ii. (2) mortgages & home equity loans on primary residence (NH_MORT variable)

iii. (3) other residential debt (HELOC+RESDBT)

iv. (4) education loans

v. (5) all other debt (DEBT minus the above debt categories)

e. Your two variables

f. Interpretation for your two variables

2. Loan-to-Value and Payment-to-Income (3D and/or 2D plot)

3. Lorenz and Gini

Three Lorenz curves on one plot. Here are the answers for income.

Gini coefficients

Income

0.5718

Stocks

Housing

References

Put here a list of sources you used. Include direct links if possible (e.g. not “Wikipedia”, but https://en.wikipedia.org/wiki/Weighted_arithmetic_mean#Basic_example)