PR data - UK regions where rent goes the furthest.xlsx

	A	B	C	D	E	F	G	H
1	The % of income spent on rent across UK regions:
2	Rank	Country	Region	Median monthly income (£)	Median weekly income (£)	Median monthly rent (£)	Median weekly rent (£)	% of income that goes to rent
3	1	England	North East	2125.93	490.60	500.00	115.38	23.5%
4	2	Wales	Wales	1933.53	446.20	525.00	121.15	27.2%
5	3	England	Yorkshire and the Humber	2164.07	499.40	600.00	138.46	27.7%
6	4	England	North West	2186.17	504.50	610.00	140.77	27.9%
7	5	England	East Midlands	2188.77	505.10	650.00	150.00	29.7%
8	6	England	West Midlands	2236.87	516.20	675.00	155.77	30.2%
9	7	Scotland	Scotland	2290.60	528.60	736.00	169.85	32.1%
10	8	England	South West	2198.73	507.40	795.00	183.46	36.2%
11	9	England	East	2379.43	549.10	875.00	201.92	36.8%
12	10	England	South East	2464.80	568.80	995.00	229.62	40.4%
13	11	England	London	2798.47	645.80	1500.00	346.15	53.6%
14
15
16		Country comparison of the % of income spent on rent
17		Rank	Country	Median monthly income (£)	Median weekly income (£)	Median monthly rent (£)	Median weekly rent (£)	% of income that goes to rent
18		1	Wales	1933.53	446.20	525.00	121.15	27.2%
19		2	Scotland	2290.60	528.60	736.00	169.85	32.1%
20		3	England	2325.27	536.60	793.00	183.00	34.1%
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100