On this page:

Scottish Model of Housing Supply and Affordability: Final Report

« Previous | Contents | Next »

Listen

Appendix C - Sub-national models for estimating wages

Table C1 Variable definitions

Variable

Descriptor

RFTWAGE_

Ratio of real average full time wages at housing region level to real average full time wages at national level

RPTWAGE_

Ratio of real average part time wages at housing region level to real average part time wages at national level

RDEGREE_

Ratio of percentage of population with degrees across housing region to percentage of population with degrees at national level

DDEGREE_

Percentage of population with degrees across housing region. D denotes differenced

RNOQUAL_

Ratio of percentage of population with no qualifications across housing region to percentage of population with no qualifications at national level

DNOQUAL_

Percentage of population with no qualifications across housing region, differenced

DFD_

Percentage of female population in housing region with dependents, differenced

RFD_

Ratio of percentage of female population in housing region with dependents to percentage of female population at national level with dependents

RFIN_

Ratio of percentage of employed workforce in financial and business services industries in housing region to percentage of employed workforce in financial and business services industries at Scottish level

DFIN_

Percentage of employed workforce in financial and business services industries in housing region. D denotes differenced.

RPROD_

Ratio of percentage of employed workforce in production industries in housing region to percentage of employed workforce in production industries at Scottish level

RPUB

Ratio of percentage of employed workforce in public service industries in housing region to percentage of employed workforce in production industries at Scottish level

DLNNETGS

Net trade in Goods and Services (real prices), differenced and in natural logs

DLNRAVEREX

Real average rate of exchange for $ to £. Ratio of USGDP to UKGDP used to estimate real exchange rate.

DLNTOURISM

Number of international visitors to UK, differences and in natural logs

DMINWAGE

Minimum wage, differenced

DBASICTAX

Basic rate of taxation, differenced

UU_

Unemployment rate across housing market region

RU_

Ratio of housing region unemployment rate to national unemployment rate

SCOTU

Unemployment rate across Scotland

DPARTRATE

Rate of participation in the labour market across housing market region. D denotes differenced.

UCC_; DUCC_

Real User Cost of Capital across housing region

D denotes differences.

Table C2 Aberdeen and Aberdeenshire full-time wages

Dependent Variable: RFTWAGE_ ABER

Sample(adjusted): 1994 2007

Variable

Coefficient

INTERCEPT

0.42039**

(0.15026)

0.037067- UU_ ABER

-2.14529

(1.45155)

RDEGREE_ ABER

0.221977***

(0.04764)

RPROD_ ABER

0.364589**

(0.10914)

DLNNETGS

-0.18974**

(0.07491)

DLNRAVEREX

-0.22058**

(0.08074)

BASIC DIAGNOSTICS

R-squared

0.70297

Mean dependent var

1.12725

Adjusted R-squared

0.517327

S.D. dependent var

0.036256

S.E. of regression

0.025189

Akaike info criterion

-4.2273

Sum squared resid

0.005076

Schwarz criterion

-3.95342

Log likelihood

35.59108

F-statistic

3.786668

Durbin-Watson stat

2.187908

Prob(F-statistic)

0.046825

Table C3 Aberdeen and Aberdeenshire part-time wages

Dependent Variable: RPTWAGE_ ABER

Sample(adjusted): 1998 2007

Variable

Coefficient

INTERCEPT

-0.00622

(0.241873)

0.037067- UU_ ABER

-3.62861**

(0.904277)

RFD_ ABER

1.123347**

(0.265387)

DMINWAGE

0.071901***

(0.008346)

DNOQUAL_ ABER

0.00989*

(0.003883)

DDEGREE_ ABER

-0.00783*

(0.003059)

AR(4)

-0.89306**

(0.173095)

BASIC DIAGNOSTICS

R-squared

0.952431

Mean dependent var

1.038258

Adjusted R-squared

0.857292

S.D. dependent var

0.079938

S.E. of regression

0.030198

Akaike info criterion

-3.96605

Sum squared resid

0.002736

Schwarz criterion

-3.75424

Log likelihood

26.83027

F-statistic

10.01101

Durbin-Watson stat

1.955072

Prob(F-statistic)

0.042844

Table C4 Ayrshire full-time wages

Dependent Variable: RFTWAGE_ AYR

Sample: 1993 2007

Variable

Coefficient

INTERCEPT

0.907229***

0.141741

SCOTU- UU_ AYR

-1.98471

1.100484

RDEGREE_ AYR

0.295605***

0.075957

RPUB_ AYR

-0.22222*

0.109628

DLNTOURISM

0.589388**

0.238317

BASIC DIAGNOSTICS

R-squared

0.809462

Mean dependent var

0.968233

Adjusted R-squared

0.733247

S.D. dependent var

0.056737

S.E. of regression

0.029303

Akaike info criterion

-3.96103

Sum squared resid

0.008587

Schwarz criterion

-3.72501

Log likelihood

34.70771

F-statistic

10.62077

Durbin-Watson stat

2.106841

Prob(F-statistic)

0.001268

Table C5 Ayrshire part-time wages

Dependent Variable: RPTWAGE_ AYR

Sample(adjusted): 1994 2007

Variable

Coefficient

intercept

1.930673***

0.303148

RU_ AYR

-0.13189

0.094168

RDEGREE_ AYR

-0.62004***

0.124646

RNOQUAL_ AYR

-0.28183

0.176858

DMINWAGE

-0.04694***

0.00631

BASIC DIAGNOSTICS

R-squared

0.558117

Mean dependent var

0.944726

Adjusted R-squared

0.361725

S.D. dependent var

0.097307

S.E. of regression

0.077741

Akaike info criterion

-1.99842

Sum squared resid

0.054393

Schwarz criterion

-1.77018

Log likelihood

18.98891

F-statistic

2.841851

Durbin-Watson stat

1.90003

Prob(F-statistic)

0.088997

Table C6 Border, Dumfries and Galloway full-time wages

Dependent Variable: RFTWAGE_ BOR

Sample(adjusted): 1994 2007

Variable

Coefficient

INTERCEPT

-0.39553**

(0.114458)

0.0414670- UU_ BOR

-2.72***

(0.411826)

DDEGREE_ BOR

-0.04072***

(0.002387)

RPUB_ BOR

1.312352***

(0.117244)

DNOQUAL_ BOR

-0.03729***

(0.003157)

DLNTOURISM

0.697612***

(0.147945)

DFIN_ BOR

0.003971**

(0.001619)

MA(3)

-0.97015***

(0.000458)

BASIC DIAGNOSTICS

R-squared

0.933199

Mean dependent var

0.865843

Adjusted R-squared

0.855265

S.D. dependent var

0.060166

S.E. of regression

0.022889

Akaike info criterion

-4.42073

Sum squared resid

0.003144

Schwarz criterion

-4.05555

Log likelihood

38.94509

F-statistic

11.97421

Durbin-Watson stat

1.76145

Prob(F-statistic)

0.003786

Table C7 Borders, Dumfries and Galloway part-time wages

Dependent Variable: RPTWAGE_ BOR

Sample(adjusted): 1996 2007

Variable

Coefficient

INTERCEPT

1.061099***

(0.075356)

0.041467- UU_ BOR

-1.2875*

(0.602667)

DMINWAGE

-0.04752***

(0.010434)

DBASICTAX

13.34679***

(2.700299)

RNOQUAL_ BOR

-0.10233

(0.075605)

AR(2)

-0.76902***

(0.089433)

BASIC DIAGNOSTICS

R-squared

0.939684

Mean dependent var

0.888036

Adjusted R-squared

0.88942

S.D. dependent var

0.097274

S.E. of regression

0.032347

Akaike info criterion

-3.71774

Sum squared resid

0.006278

Schwarz criterion

-3.47529

Log likelihood

28.30645

F-statistic

18.69513

Durbin-Watson stat

2.360927

Prob(F-statistic)

0.001344

Table C8 Dundee and Tayside full-time wages

Dependent Variable: RFTWAGE_ DUN

Sample(adjusted): 1996 2007

Variable

Coefficient

INTERCEPT

0.084283

(0.101638)

0.060067- UU_ DUN

-1.44852***

(0.323755)

RPROD_ DUN

0.612935***

(0.088392)

RDEGREE_ DUN

0.276816***

(0.029759)

DRAVEREX

0.528481***

(0.069618)

AR(2)

-0.55313**

(0.186433)

BASIC DIAGNOSTICS

R-squared

0.925934

Mean dependent var

0.94349

Adjusted R-squared

0.864212

S.D. dependent var

0.03809

S.E. of regression

0.014036

Akaike info criterion

-5.38755

Sum squared resid

0.001182

Schwarz criterion

-5.1451

Log likelihood

38.32529

F-statistic

15.00171

Durbin-Watson stat

2.054731

Prob(F-statistic)

0.002448

Table C9 Dundee and Tayside part-time wages

Dependent Variable: RPTWAGE_ DUN

Sample(adjusted): 1995 2007

Variable

Coefficient

INTERCEPT

1.862963***

(0.115366)

0.060067- UU_ DUN

2.512074***

(0.429558)

RFD_ DUN

-0.74716***

(0.114508)

DNOQUAL_ DUN

0.01173**

(0.003789)

RDEGREE_ DUN

-0.19081***

(0.043777)

AR(1)

-0.96539***

(0.1546)

BASIC DIAGNOSTICS

R-squared

0.903814

Mean dependent var

0.967733

Adjusted R-squared

0.807629

S.D. dependent var

0.082982

S.E. of regression

0.036396

Akaike info criterion

-3.48497

Sum squared resid

0.007948

Schwarz criterion

-3.18077

Log likelihood

29.65232

F-statistic

9.396568

Durbin-Watson stat

1.611267

Prob(F-statistic)

0.007664

Table C10 Edinburgh city region full-time wages

Dependent Variable: RFTWAGE_ EDIN

Sample(adjusted): 1998 2007

Variable

Coefficient

INTERCEPT

0.653319***

0.066625

RU_ EDIN

-0.06491**

0.015956

RFIN_ EDIN

0.070077**

0.024981

RPUB_ EDIN

0.340169***

0.055622

DDEGREE_ EDIN

-0.00602***

0.000914

AR(4)

-0.55228***

0.078088

BASIC DIAGNOSTICS

R-squared

0.98094

Mean dependent var

1.040146

Adjusted R-squared

0.957114

S.D. dependent var

0.021637

S.E. of regression

0.004481

Akaike info criterion

-7.69433

Sum squared resid

8.03E-05

Schwarz criterion

-7.51278

Log likelihood

44.47164

F-statistic

41.17211

Durbin-Watson stat

1.606936

Prob(F-statistic)

0.001559

Table C11 Edinburgh city region part-time wages

Dependent Variable: RPTWAGE_ EDIN

Sample(adjusted): 1998 2007

Variable

Coefficient

INTERCEPT

1.274872***

(0.092897)

0.048867- UU_ EDIN

-0.70213*

(0.305375)

RFD_ EDIN

-0.26167*

(0.097102)

DNOQUAL_ EDIN

-0.00831***

(0.001327)

DDEGREE_ EDIN

0.006523**

(0.001527)

AR(4)

-0.72472***

(0.148691)

BASIC DIAGNOSTICS

R-squared

0.951123

Mean dependent var

1.02183

Adjusted R-squared

0.890028

S.D. dependent var

0.022626

S.E. of regression

0.007503

Akaike info criterion

-6.66328

Sum squared resid

0.000225

Schwarz criterion

-6.48173

Log likelihood

39.3164

F-statistic

15.56774

Durbin-Watson stat

1.888919

Prob(F-statistic)

0.009945

Table C12 Glasgow city region full-time wages

Dependent Variable: RFTWAGE_ GLAS

Sample(adjusted): 1994 2006

Variable

Coefficient

INTERCEPT

0.955342***

(0.011541)

SCTOTU- UU_ GLAS

-1.61013

(1.412613)

DNOQUAL_ GLAS

0.009418***

(0.002218)

DDEGREE_ GLAS

0.010857*

(0.005005)

UCC_ GLAS

0.211711**

(0.078022)

DLNRP_ GLAS

0.129998

(0.072656)

BASIC DIAGNOSTICS

R-squared

0.729354

Mean dependent var

0.990345

Adjusted R-squared

0.536036

S.D. dependent var

0.020301

S.E. of regression

0.013828

Akaike info criterion

-5.42018

Sum squared resid

0.001339

Schwarz criterion

-5.15944

Log likelihood

41.23118

F-statistic

3.77281

Durbin-Watson stat

2.065188

Prob(F-statistic)

0.056225

Table C13 Glasgow city region part-time wages

Dependent Variable: RPTWAGE_ GLAS

Sample(adjusted): 1997 2007

Variable

Coefficient

INTERCEPT

-0.973**

(0.171692)

RU_ GLAS

-0.16784***

(0.022225)

RNOQUAL_ GLAS

0.536392***

(0.057698)

RFD_ GLAS

1.064085***

(0.078535)

RPROD_ GLAS

0.456031***

(0.074024)

DBASICTAX

6.595932***

(0.472408)

AR(3)

-0.83622***

(0.121137)

MA(5)

-0.95064***

(0.000167)

BASIC DIAGNOSTICS

R-squared

0.995058

Mean dependent var

1.021085

Adjusted R-squared

0.983526

S.D. dependent var

0.028405

S.E. of regression

0.003646

Akaike info criterion

-8.23518

Sum squared resid

3.99E-05

Schwarz criterion

-7.94581

Log likelihood

53.29351

F-statistic

86.28757

Durbin-Watson stat

2.155768

Prob(F-statistic)

0.001874

Table C14 Highlands, Moray and Islands full-time wages

Dependent Variable: RFTWAGE_ HIGH

Sample(adjusted): 1995 2007

Variable

Coefficient

INTERCEPT

1.021908***

(0.16011)

RU_ HIGH

-0.09811

(0.052027)

RDEGREE_ HIGH

0.248321***

(0.065431)

RPROD_ HIGH

0.210116**

(0.073168)

DLNTOURISM

0.398177***

(0.097138)

RPITY_ HIGH

-0.64082**

(0.193442)

AR(2)

-0.62655**

(0.238763)

BASIC DIAGNOSTICS

R-squared

0.802168

Mean dependent var

0.956353

Adjusted R-squared

0.604336

S.D. dependent var

0.029503

S.E. of regression

0.018558

Akaike info criterion

-4.83212

Sum squared resid

0.002066

Schwarz criterion

-4.52791

Log likelihood

38.40875

F-statistic

4.054798

Durbin-Watson stat

2.163244

Prob(F-statistic)

0.056268

Table C15 Highlands, Moray and Islands part-time wages

Dependent Variable: RPTWAGE_ HIGH

Sample(adjusted): 1997 2007

Variable

Coefficient

INTERCEPT

0.582266***

(0.13703)

0.045667- UU_ HIGH

1.845813

(1.23232)

RFD_ HIGH

0.33667*

(0.127452)

NOQUAL_ HIGH

0.019708*

(0.008318)

DEGREE_ HIGH

0.021233***

(0.00437)

AR(3)

0.455281*

(0.176795)

BASIC DIAGNOSTICS

R-squared

0.865437

Mean dependent var

0.956623

Adjusted R-squared

0.730873

S.D. dependent var

0.057277

S.E. of regression

0.029714

Akaike info criterion

-3.89195

Sum squared resid

0.004415

Schwarz criterion

-3.67492

Log likelihood

27.40573

F-statistic

6.431437

Durbin-Watson stat

2.517755

Prob(F-statistic)

0.03102

Table C16 Stirling and Central Scotland full-time wages

Dependent Variable: RFTWAGE_ STIR

Sample: 1993 2007

Variable

Coefficient

INTERCEPT

0.792513***

(0.093188)

RU_ STIR

-0.22198***

(0.052249)

RDEGREE_ STIR

0.427152***

(0.056324)

DLNTOURISM

-0.93955***

(0.162623)

RFIN_ STIR

0.081181

(0.053343)

MA(2)

-0.97999***

(0.000385)

BASIC DIAGNOSTICS

R-squared

0.846926

Mean dependent var

1.008021

Adjusted R-squared

0.761885

S.D. dependent var

0.060272

S.E. of regression

0.029411

Akaike info criterion

-3.92571

Sum squared resid

0.007785

Schwarz criterion

-3.64249

Log likelihood

35.44282

F-statistic

9.959026

Durbin-Watson stat

1.635091

Prob(F-statistic)

0.001819

Table C17 Stirling and Central Scotland part-time wages

Dependent Variable: RFTWAGE_ STIR

Sample: 1993 2007

Variable

Coefficient

INTERCEPT

1.359325***

(0.130563)

RU_ STIR

-0.47403**

(0.141588)

DNOQUAL_ STIR

-0.02628**

(0.009808)

DFD_ STIR

-0.02925

(0.02148)

DUCC_ STIR

1.775981*

(0.827077)

DPARTRATE_ STIR

-0.01703**

(0.005506)

BASIC DIAGNOSTICS

R-squared

0.686263

Mean dependent var

0.926581

Adjusted R-squared

0.462165

S.D. dependent var

0.080906

S.E. of regression

0.059334

Akaike info criterion

-2.50723

Sum squared resid

0.024644

Schwarz criterion

-2.24649

Log likelihood

22.29702

F-statistic

3.062337

Durbin-Watson stat

1.586418

Prob(F-statistic)

0.088414

« Previous | Contents | Next »

Page updated: Wednesday, December 17, 2008