Main survey variable: xpmg Last total monthly mortgage payment

Last total monthly mortgage payment

Datafile

hhresp

Index terms

Variable note:

Starting from wave 13, the response range was adjusted from 1 â 99,997 to 0 â 99,997. This modification was made to include cases where individuals may have mortgages without associated repayments, such as with lifetime mortgages.

Question asked in the latest wave:

household_w14.xpmg

Question label:

Last total monthly mortgage payment

Question text:

How much was your last total monthly instalment on all mortgages or loans for this property?

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)

Question interviewer instructions:

ENTER TOTAL MORTGAGE PAYMENT FOR ALL MORTGAGES INCLUDING EXISTING AND NEW MORTGAGES. INCLUDE LIFE INSURANCE PAYMENTS IF PAID WITH MORTGAGE. IF ENDOWMENT MORTGAGE, INCLUDE BOTH PREMIUMS AND INTEREST. IF DON’T KNOW, PROBE FOR APPROXIMATE AMOUNT. WRITE IN AMOUNT IN Â£

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

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	14104	65.95%
refusal	-2	465	2.17%
don't know	-1	421	1.97%
[Value >= 0]	1	6395	29.9%
	Total	21385	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
827.14	14990	0	93830.0	2490.71	6395

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	10508	65.04%
refusal	-2	375	2.32%
don't know	-1	336	2.08%
[Value >= 0]	1	4937	30.56%
	Total	16156	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
790.83	11219	0	68600.0	2099.3	4937

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	11109	65.91%
refusal	-2	402	2.38%
don't know	-1	365	2.17%
[Value >= 0]	1	4980	29.54%
	Total	16856	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
840.56	11876	1.0	95130.0	2873.45	4980

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	12022	66.28%
refusal	-2	347	1.91%
don't know	-1	342	1.89%
[Value >= 0]	1	5428	29.92%
	Total	18139	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
810.24	12711	1.0	96000.0	2619.7	5428

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	12661	65.76%
refusal	-2	356	1.85%
don't know	-1	382	1.98%
[Value >= 0]	1	5853	30.4%
	Total	19252	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
694.91	13399	1.0	80000.0	1483.3	5853

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	13235	66.02%
refusal	-2	297	1.48%
don't know	-1	382	1.91%
[Value >= 0]	1	6134	30.6%
	Total	20048	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
783.04	13914	1.0	90000.0	2919.11	6134

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	14448	66.44%
refusal	-2	237	1.09%
don't know	-1	359	1.65%
[Value >= 0]	1	6702	30.82%
	Total	21746	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
747.14	15044	1.0	75000.0	2536.94	6702

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	15361	66.69%
refusal	-2	149	0.65%
don't know	-1	494	2.14%
[Value >= 0]	1	7029	30.52%
	Total	23033	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
658.39	16004	1.0	88900.0	1513.23	7029

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	16359	66.9%
refusal	-2	177	0.72%
don't know	-1	595	2.43%
[Value >= 0]	1	7323	29.95%
	Total	24454	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
614.35	17131	1.0	18000.0	566.87	7323

Value label	Value	Absolute frequency	Relative frequency
missing	-9	7	0.03%
inapplicable	-8	15868	65.23%
refusal	-2	122	0.5%
don't know	-1	477	1.96%
[Value >= 0]	1	7851	32.28%
	Total	24325	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
595.86	16474	1.0	31000.0	662.25	7851

Value label	Value	Absolute frequency	Relative frequency
missing	-9	2	0.01%
inapplicable	-8	16648	64.48%
refusal	-2	125	0.48%
don't know	-1	569	2.2%
[Value >= 0]	1	8473	32.82%
	Total	25817	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
583.55	17344	1.0	69000.0	990.85	8473

Value label	Value	Absolute frequency	Relative frequency
missing	-9	2	0.01%
inapplicable	-8	17783	64.08%
refusal	-2	165	0.59%
don't know	-1	651	2.35%
[Value >= 0]	1	9150	32.97%
	Total	27751	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
566.24	18601	1.0	65000.0	802.2	9150

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	19555	64.15%
refusal	-2	182	0.6%
don't know	-1	703	2.31%
[Value >= 0]	1	10044	32.95%
	Total	30484	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
588.3	20440	1.0	78187.0	1354.72	10044

Value label	Value	Absolute frequency	Relative frequency
missing	-9	12	0.04%
inapplicable	-8	19801	65.63%
refusal	-2	441	1.46%
don't know	-1	898	2.98%
[Value >= 0]	1	9017	29.89%
	Total	30169	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
607.57	21152	1.0	90926.0	1532.49	9017

Value label	Value	Absolute frequency	Relative frequency
missing	-9	66	0.81%
inapplicable	-8	4942	60.68%
[Value >= 0]	1	3136	38.51%
	Total	8144	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
580.19	5008	1.0	9999.0	431.78	3136

Value label	Value	Absolute frequency	Relative frequency
missing	-9	51	0.61%
inapplicable	-8	4976	59.62%
[Value >= 0]	1	3319	39.77%
	Total	8346	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
544.05	5027	0	5600.0	381.58	3319

Value label	Value	Absolute frequency	Relative frequency
missing	-9	58	0.67%
inapplicable	-8	5070	58.93%
[Value >= 0]	1	3475	40.39%
	Total	8603	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
485.61	5128	0	5500.0	350.14	3475

Value label	Value	Absolute frequency	Relative frequency
missing	-9	34	0.39%
inapplicable	-8	5077	58.3%
[Value >= 0]	1	3598	41.31%
	Total	8709	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
442.73	5111	1.0	3329.0	306.8	3598

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	4906	55.14%
proxy	-7	448	5.04%
[Value >= 0]	1	3543	39.82%
	Total	8897	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
407.32	5354	5.0	9999.0	327.46	3543

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	5116	56.56%
proxy	-7	301	3.33%
[Value >= 0]	1	3628	40.11%
	Total	9045	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
353.85	5417	4.0	9999.0	292.36	3628

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	5541	59.25%
[Value >= 0]	1	3811	40.75%
	Total	9352	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
330.84	5541	1.0	5000.0	241.54	3811

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	6427	60.46%
[Value >= 0]	1	4204	39.54%
	Total	10631	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
314.76	6427	1.0	5000.0	238.77	4204

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	5147	58.75%
proxy	-7	154	1.76%
[Value >= 0]	1	3460	39.49%
	Total	8761	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
328.99	5301	8.0	9500.0	298.62	3460

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	5253	59.71%
proxy	-7	55	0.63%
[Value >= 0]	1	3489	39.66%
	Total	8797	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
291.46	5308	1.0	4000.0	219.62	3489

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	3541	58.97%
proxy	-7	59	0.98%
[Value >= 0]	1	2405	40.05%
	Total	6005	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
323.21	3600	0	4500.0	223.04	2405

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	3611	59.29%
proxy	-7	31	0.51%
[Value >= 0]	1	2448	40.2%
	Total	6090	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
292.52	3642	0	5000.0	218.17	2448

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	2788	55.06%
proxy	-7	40	0.79%
[Value >= 0]	1	2236	44.15%
	Total	5064	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
266.57	2828	0	1600.0	178.14	2236

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	2736	54.36%
proxy	-7	98	1.95%
[Value >= 0]	1	2199	43.69%
	Total	5033	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
272.21	2834	8.0	1680.0	184.56	2199

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	2802	54.65%
proxy	-7	88	1.72%
[Value >= 0]	1	2237	43.63%
	Total	5127	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
264.17	2890	0	8000.0	311.14	2237

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	2784	53.21%
proxy	-7	211	4.03%
[Value >= 0]	1	2237	42.76%
	Total	5232	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
248.51	2995	3.0	4000.0	205.07	2237

Value label	Value	Absolute frequency	Relative frequency
missing	-9	16	0.31%
inapplicable	-8	2882	55.14%
[Value >= 0]	1	2329	44.56%
	Total	5227	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
281.33	2898	8.0	4270.0	244.18	2329

Value label	Value	Absolute frequency	Relative frequency
inapplicable	-8	3117	56.56%
[Value >= 0]	1	2394	43.44%
	Total	5511	100.0%

Mean	Number Missing	Min	Max	Std Dev	N
278.98	3117	0	4300.0	232.65	2394

Code creator
0

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

xpmg

Datafile

Index terms

Variable note:

Question asked in the latest wave:

household_w14.xpmg

Question label:

Question text:

Question universe:

Question interviewer instructions:

Code creator
0

Saved variables

What else is Understanding Society doing?

Children’s worries include good grades and rising prices

Calendar Year 2023 data now available

Professor Annette Jäckle debates survey methods on BBC Radio 4

Young people’s aspirations rise with parents’ income

Email newsletter

Datafile

Index terms

Variable note:

Question asked in the latest wave:

household_w14.xpmg

Question label:

Question text:

Question universe:

Question interviewer instructions:

Wave 14 (n_xpmg hhresp)

Wave 13 (m_xpmg hhresp)

Wave 12 (l_xpmg hhresp)

Wave 11 (k_xpmg hhresp)

Wave 10 (j_xpmg hhresp)

Wave 9 (i_xpmg hhresp)

Wave 8 (h_xpmg hhresp)

Wave 7 (g_xpmg hhresp)

Wave 6 (f_xpmg hhresp)

Wave 5 (e_xpmg hhresp)

Wave 4 (d_xpmg hhresp)

Wave 3 (c_xpmg hhresp)

Wave 2 (b_xpmg hhresp)

Wave 1 (a_xpmg hhresp)

Wave B18 (br_xpmg hhresp)

Wave B17 (bq_xpmg hhresp)

Wave B16 (bp_xpmg hhresp)

Wave B15 (bo_xpmg hhresp)

Wave B14 (bn_xpmg hhresp)

Wave B13 (bm_xpmg hhresp)

Wave B12 (bl_xpmg hhresp)

Wave B11 (bk_xpmg hhresp)

Wave B10 (bj_xpmg hhresp)

Wave B9 (bi_xpmg hhresp)

Wave B8 (bh_xpmg hhresp)

Wave B7 (bg_xpmg hhresp)

Wave B6 (bf_xpmg hhresp)

Wave B5 (be_xpmg hhresp)

Wave B4 (bd_xpmg hhresp)

Wave B3 (bc_xpmg hhresp)

Wave B2 (bb_xpmg hhresp)

Wave B1 (ba_xpmg hhresp)

Code creator 0

Saved variables

What else is Understanding Society doing?

Children’s worries include good grades and rising prices

Calendar Year 2023 data now available

Professor Annette Jäckle debates survey methods on BBC Radio 4

Young people’s aspirations rise with parents’ income

Email newsletter

Code creator
0