Main survey variable: mgnew Amount of additional mortgage on home

Amount of additional mortgage on home

Datafile

hhresp

Index terms

Question asked in the latest wave:

household_w15.mgnew

Question label:

Amount of additional mortgage on home

Question text:

How much in total is this additional mortgage or loan?

Question universe:

if [(ff_HsOwnd = 2|3 & HSOWNDCHK = 1) | (HsOwnd = 2|3)] // mortgage/shared ownership at previous wave and still the same or mortgage/shared ownership now
And if [MgExtra = 1] // Taken out additional mortgage/loan

Question interviewer instructions:

ENTER TO NEAREST Â£

Further details:
For further details about this question, please see the questionnaires

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	19369	98.89%
refusal	-2	9	0.05%
don't know	-1	15	0.08%
[Value >= 0]	1	193	0.99%
	Total	19586	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
63629.32	19393	0	750000.0	78690.93	193

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	20807	97.3%
refusal	-2	27	0.13%
don't know	-1	26	0.12%
[Value >= 0]	1	525	2.45%
	Total	21385	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
55531.56	20860	0	545000.0	67483.84	525

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	15917	98.52%
refusal	-2	11	0.07%
don't know	-1	8	0.05%
[Value >= 0]	1	220	1.36%
	Total	16156	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
66991.15	15936	0	775000.0	84698.78	220

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	16492	97.84%
refusal	-2	23	0.14%
don't know	-1	16	0.09%
[Value >= 0]	1	325	1.93%
	Total	16856	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
56749.12	16531	0	660000.0	69716.24	325

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	17683	97.49%
refusal	-2	25	0.14%
don't know	-1	19	0.1%
[Value >= 0]	1	412	2.27%
	Total	18139	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
49935.5	17727	0	750000.0	57004.67	412

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	18999	98.69%
refusal	-2	19	0.1%
don't know	-1	10	0.05%
[Value >= 0]	1	224	1.16%
	Total	19252	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
65719.79	19028	350.0	750000.0	78959.48	224

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	19793	98.73%
refusal	-2	15	0.07%
don't know	-1	7	0.03%
[Value >= 0]	1	233	1.16%
	Total	20048	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
62315.61	19815	40.0	450000.0	74398.11	233

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	21484	98.8%
refusal	-2	11	0.05%
don't know	-1	12	0.06%
[Value >= 0]	1	239	1.1%
	Total	21746	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
58671.59	21507	10.0	630000.0	76901.67	239

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	22803	99.0%
refusal	-2	1	0.0%
don't know	-1	12	0.05%
[Value >= 0]	1	217	0.94%
	Total	23033	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
48183.96	22816	0	380000.0	58059.54	217

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	24150	98.76%
refusal	-2	7	0.03%
don't know	-1	17	0.07%
[Value >= 0]	1	280	1.15%
	Total	24454	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
53667.56	24174	0	800000.0	76461.59	280

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	24063	98.92%
refusal	-2	4	0.02%
don't know	-1	8	0.03%
[Value >= 0]	1	250	1.03%
	Total	24325	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
41275.02	24075	30.0	300000.0	47704.72	250

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	25535	98.91%
refusal	-2	3	0.01%
don't know	-1	15	0.06%
[Value >= 0]	1	264	1.02%
	Total	25817	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
42863.72	25553	2.0	400000.0	54456.6	264

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	27435	98.86%
refusal	-2	3	0.01%
don't know	-1	11	0.04%
[Value >= 0]	1	302	1.09%
	Total	27751	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
41858.27	27449	92.0	450000.0	55005.65	302

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	29899	98.08%
refusal	-2	7	0.02%
don't know	-1	25	0.08%
[Value >= 0]	1	553	1.81%
	Total	30484	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
43834.93	29931	12.0	1000000.0	70410.12	553

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	7439	91.34%
proxy	-7	538	6.61%
refusal	-2	2	0.02%
don't know	-1	2	0.02%
[Value >= 0]	1	163	2.0%
	Total	8144	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
29851.81	7981	1000.0	260000.0	39166.01	163

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	7587	90.91%
proxy	-7	484	5.8%
don't know	-1	3	0.04%
[Value >= 0]	1	272	3.26%
	Total	8346	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
32421.32	8074	2000.0	300000.0	39136.28	272

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	7844	91.18%
proxy	-7	462	5.37%
refusal	-2	4	0.05%
don't know	-1	7	0.08%
[Value >= 0]	1	286	3.32%
	Total	8603	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
28806.64	8317	300.0	200000.0	31073.97	286

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	7938	91.15%
proxy	-7	442	5.08%
refusal	-2	3	0.03%
don't know	-1	7	0.08%
[Value >= 0]	1	319	3.66%
	Total	8709	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
28021.32	8390	800.0	350000.0	35595.66	319

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	8064	90.64%
proxy	-7	448	5.04%
refusal	-2	8	0.09%
don't know	-1	11	0.12%
[Value >= 0]	1	366	4.11%
	Total	8897	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
23972.13	8531	800.0	300000.0	31708.49	366

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	8357	92.39%
proxy	-7	301	3.33%
refusal	-2	5	0.06%
don't know	-1	4	0.04%
[Value >= 0]	1	378	4.18%
	Total	9045	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
20298.54	8667	1000.0	136000.0	19104.3	378

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	8672	92.73%
proxy	-7	351	3.75%
refusal	-2	2	0.02%
don't know	-1	3	0.03%
[Value >= 0]	1	324	3.46%
	Total	9352	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
19422.84	9028	1000.0	160000.0	20496.02	324

Value label	Value	Absolute frequency	Relative frequency
missing	-9	1	0.01%
inapplicable	-8	10002	94.08%
proxy	-7	246	2.31%
refusal	-2	2	0.02%
don't know	-1	7	0.07%
[Value >= 0]	1	373	3.51%
	Total	10631	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
20034.8	10258	32.0	800000.0	45980.97	373

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	8401	95.89%
proxy	-7	154	1.76%
refusal	-2	1	0.01%
don't know	-1	3	0.03%
[Value >= 0]	1	202	2.31%
	Total	8761	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
14836.45	8559	1000.0	175000.0	18996.35	202

Value label	Value	Absolute frequency	Relative frequency
missing	-9	2	0.02%
inapplicable	-8	8388	95.35%
proxy	-7	55	0.63%
don't know	-1	15	0.17%
[Value >= 0]	1	337	3.83%
	Total	8797	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
15159.24	8460	140.0	735000.0	41907.04	337

Value label	Value	Absolute frequency	Relative frequency
missing	-9	17	0.28%
inapplicable	-8	5837	97.2%
proxy	-7	59	0.98%
refusal	-2	1	0.02%
[Value >= 0]	1	91	1.52%
	Total	6005	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
13189.01	5914	800.0	90000.0	13949.63	91

Value label	Value	Absolute frequency	Relative frequency
missing	-9	20	0.33%
inapplicable	-8	5909	97.03%
proxy	-7	31	0.51%
refusal	-2	1	0.02%
don't know	-1	1	0.02%
[Value >= 0]	1	128	2.1%
	Total	6090	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
10426.42	5962	1000.0	87000.0	10428.33	128

Value label	Value	Absolute frequency	Relative frequency
missing	-9	13	0.26%
inapplicable	-8	4908	96.92%
proxy	-7	40	0.79%
refusal	-2	1	0.02%
[Value >= 0]	1	102	2.01%
	Total	5064	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
10247.06	4962	500.0	55000.0	10166.74	102

Value label	Value	Absolute frequency	Relative frequency
missing	-9	35	0.7%
inapplicable	-8	4821	95.79%
proxy	-7	98	1.95%
don't know	-1	1	0.02%
[Value >= 0]	1	78	1.55%
	Total	5033	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
9244.23	4955	1000.0	47000.0	9587.06	78

Value label	Value	Absolute frequency	Relative frequency
missing	-9	11	0.21%
inapplicable	-8	4925	96.06%
proxy	-7	88	1.72%
refusal	-2	3	0.06%
don't know	-1	1	0.02%
[Value >= 0]	1	99	1.93%
	Total	5127	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
9759.6	5028	1200.0	70000.0	9402.54	99

Value label	Value	Absolute frequency	Relative frequency
missing	-9	35	0.67%
inapplicable	-8	4849	92.68%
proxy	-7	211	4.03%
refusal	-2	2	0.04%
don't know	-1	2	0.04%
[Value >= 0]	1	133	2.54%
	Total	5232	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
12082.98	5099	600.0	99999.0	15562.8	133

Value label	Value	Absolute frequency	Relative frequency
missing	-9	22	0.42%
inapplicable	-8	4997	95.6%
refusal	-2	2	0.04%
don't know	-1	2	0.04%
[Value >= 0]	1	204	3.9%
	Total	5227	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
10285.0	5023	700.0	84500.0	11650.37	204

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	4675	84.83%
[Value >= 0]	1	836	15.17%
	Total	5511	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
10791.59	4675	500.0	99997.0	12257.99	836

Saved variables

0

Create your own Stata or R code to extract data from the main end user licence Understanding Society dataset. Find out more

mgnew

Datafile

Index terms

Question asked in the latest wave:

household_w15.mgnew

Question label:

Question text:

Question universe:

Question interviewer instructions:

Saved variables

0

What else is Understanding Society doing?

Call for new fellows open

Diversity or disadvantage? Families and employment of immigrants’ children in the UK

New variable search

New edition of marital and cohabitation histories

Email newsletter

Datafile

Index terms

Question asked in the latest wave:

household_w15.mgnew

Question label:

Question text:

Question universe:

Question interviewer instructions:

Wave 15 (o_mgnew hhresp)

Wave 14 (n_mgnew hhresp)

Wave 13 (m_mgnew hhresp)

Wave 12 (l_mgnew hhresp)

Wave 11 (k_mgnew hhresp)

Wave 10 (j_mgnew hhresp)

Wave 9 (i_mgnew hhresp)

Wave 8 (h_mgnew hhresp)

Wave 7 (g_mgnew hhresp)

Wave 6 (f_mgnew hhresp)

Wave 5 (e_mgnew hhresp)

Wave 4 (d_mgnew hhresp)

Wave 3 (c_mgnew hhresp)

Wave 2 (b_mgnew hhresp)

Wave B18 (br_mgnew hhresp)

Wave B17 (bq_mgnew hhresp)

Wave B16 (bp_mgnew hhresp)

Wave B15 (bo_mgnew hhresp)

Wave B14 (bn_mgnew hhresp)

Wave B13 (bm_mgnew hhresp)

Wave B12 (bl_mgnew hhresp)

Wave B11 (bk_mgnew hhresp)

Wave B10 (bj_mgnew hhresp)

Wave B9 (bi_mgnew hhresp)

Wave B8 (bh_mgnew hhresp)

Wave B7 (bg_mgnew hhresp)

Wave B6 (bf_mgnew hhresp)

Wave B5 (be_mgnew hhresp)

Wave B4 (bd_mgnew hhresp)

Wave B3 (bc_mgnew hhresp)

Wave B2 (bb_mgnew hhresp)

Wave B1 (ba_mgnew hhresp)

Saved variables 0

What else is Understanding Society doing?

Call for new fellows open

Diversity or disadvantage? Families and employment of immigrants’ children in the UK

New variable search

New edition of marital and cohabitation histories

Email newsletter

Saved variables

0