SPSS output for exemplar 2

Black output is produced by SPSS. Other colours are comments.

For comments on how torun code see the html version of SPSS source code

Links in this page

Simple means and proportions Table 2.3
Effect of design aspects on precision of estimates table 2.4
Chi square tests tables 2.6 onwards
Internet use by council area

Complex Samples: Plan

Warnings

This procedure does not check the consistency of the working data file with the plan file. We recommend looking at the output table or the plan file to check consistency before performing selection or analysis.

Summary

Stage 1

Design Variables

Stratification

1

stratum

Cluster

1

psu

Analysis Information

Estimator Assumption

Sampling with replacement

Plan File: G:\peas\ex2datafiles\data\ex2.csaplanWeight Variable: gross_wt

Complex Samples: Tables

back to top uparrow

Whether person uses the --internet

sex

Estimate

Standard Error

Design Effect

Unweighted Count

male

% of Total

0

61.5%

.5%

1.415

7806

1

38.5%

.5%

1.415

4368

Total

100.0%

.0%

.

12174

female

% of Total

0

69.3%

.4%

1.421

12017

1

30.7%

.4%

1.421

4494

Total

100.0%

.0%

.

16511

Nice table layout with unweighted counts in RH column

Complex Samples: Tables

Time spent using internet each week

Estimate

Standard Error

95% Confidence Interval

Design Effect

Square Root Design Effect

Lower

Upper

% of Total

Up to 1 hour a week

40.8%

.6%

39.6%

42.0%

1.372

1.171

Over 1 hour, up to 5 hours

40.7%

.6%

39.5%

41.9%

1.352

1.163

Over 5 hours up to 10 hours

10.8%

.4%

10.1%

11.6%

1.305

1.142

Over 10 hours up to 20 hours

5.1%

.3%

4.6%

5.6%

1.409

1.187

Over 20 hours

2.6%

.2%

2.2%

3.0%

1.371

1.171

Total

100.0%

.0%

100.0%

100.0%

.

.

Complex Samples: Tables

back to top uparrow

Whether person uses the --internet * sex

Need to do as a crosstab to get chi square tests


Whether person uses the --internet

sex

male

female

Total

0

Population Size

Estimate

1085041.355

1544784.484

2629825.839

Standard Error

13515.456

15126.185

19604.871

Design Effect

1.672

1.747

3.095

Square Root Design Effect

1.293

1.322

1.759

1

Population Size

Estimate

679710.624

684513.833

1364224.456

Standard Error

11303.619

11424.669

15743.647

Design Effect

1.639

1.665

1.996

Square Root Design Effect

1.280

1.290

1.413

Total

Population Size

Estimate

1764751.979

2229298.317

3994050.296

Standard Error

16839.217

17816.269

22072.643

Design Effect

2.082

2.331

.

Square Root Design Effect

1.443

1.527

.

Tests of Independence

Statistic

F

df1

df2

Sig.

Whether person uses the --internet * sex

Pearson

191.894

143.812

1

11656

.000

Likelihood Ratio

191.395

143.438

1

11656

.000

Measures of Association

Estimate

Whether person uses the --internet * sex

Odds Ratio

.707

Statistics are computed only for 2-by-2 tables with all cells observed.

Complex Samples: Tables

back to top uparrow

Whether person uses the --internet * council

Note that design effects are with respect to a sample of the whole country

 

council

Estimate

Standard Error

Design Effect

Unweighted Count

Aberdeen City

% of Total

0

57.4%

1.5%

1.295

727

1

42.6%

1.5%

1.295

437

Total

100.0%

.0%

.

1164

Aberdeenshire

% of Total

0

62.7%

1.8%

1.600

731

1

37.3%

1.8%

1.600

396

Total

100.0%

.0%

.

1127

Angus

% of Total

0

64.3%

2.2%

1.343

429

1

35.7%

2.2%

1.343

206

Total

100.0%

.0%

.

635

Argyll & Bute

% of Total

0

67.6%

2.7%

1.703

388

1

32.4%

2.7%

1.703

160

Total

100.0%

.0%

.

548

Clackmannanshire

% of Total

0

69.9%

3.0%

1.167

377

1

30.1%

3.0%

1.167

143

Total

100.0%

.0%

.

520

Dumfries & Galloway

% of Total

0

74.8%

1.7%

1.252

595

1

25.2%

1.7%

1.252

180

Total

100.0%

.0%

.

775

Dundee City

% of Total

0

68.3%

1.8%

1.363

563

1

31.7%

1.8%

1.363

225

Total

100.0%

.0%

.

788

East Ayrshire

% of Total

0

70.0%

2.3%

1.612

482

1

30.0%

2.3%

1.612

173

Total

100.0%

.0%

.

655

East Dunbartonshire

% of Total

0

52.9%

2.4%

1.247

331

1

47.1%

2.4%

1.247

225

Total

100.0%

.0%

.

556

East Lothian

% of Total

0

62.1%

2.6%

1.442

359

1

37.9%

2.6%

1.442

194

Total

100.0%

.0%

.

553

East Renfrewshire

% of Total

0

56.0%

2.4%

1.035

311

1

44.0%

2.4%

1.035

194

Total

100.0%

.0%

.

505

Edinburgh, City of

% of Total

0

54.8%

1.1%

1.397

1301

1

45.2%

1.1%

1.397

933

Total

100.0%

.0%

.

2234

Eilean Siar

% of Total

0

74.1%

2.0%

.326

481

1

25.9%

2.0%

.326

149

Total

100.0%

.0%

.

630

Falkirk

% of Total

0

66.1%

2.0%

1.388

519

1

33.9%

2.0%

1.388

227

Total

100.0%

.0%

.

746

Fife

% of Total

0

67.0%

1.4%

1.679

1225

1

33.0%

1.4%

1.679

543

Total

100.0%

.0%

.

1768

Glasgow City

% of Total

0

72.1%

.9%

1.455

2262

1

27.9%

.9%

1.455

775

Total

100.0%

.0%

.

3037

Highland

% of Total

0

61.7%

1.7%

1.416

711

1

38.3%

1.7%

1.416

370

Total

100.0%

.0%

.

1081

Inverclyde

% of Total

0

70.4%

2.3%

1.269

371

1

29.6%

2.3%

1.269

128

Total

100.0%

.0%

.

499

Midlothian

% of Total

0

65.7%

2.3%

1.005

405

1

34.3%

2.3%

1.005

199

Total

100.0%

.0%

.

604

Moray

% of Total

0

69.3%

2.5%

1.411

422

1

30.7%

2.5%

1.411

159

Total

100.0%

.0%

.

581

North Ayrshire

% of Total

0

75.4%

2.2%

2.048

570

1

24.6%

2.2%

2.048

158

Total

100.0%

.0%

.

728

North Lanarkshire

% of Total

0

72.0%

1.5%

1.923

1159

1

28.0%

1.5%

1.923

388

Total

100.0%

.0%

.

1547

Orkney Islands

% of Total

0

69.2%

3.0%

.466

442

1

30.8%

3.0%

.466

173

Total

100.0%

.0%

.

615

Perth & Kinross

% of Total

0

62.4%

2.3%

1.646

441

1

37.6%

2.3%

1.646

234

Total

100.0%

.0%

.

675

Renfrewshire

% of Total

0

68.4%

1.7%

1.428

654

1

31.6%

1.7%

1.428

245

Total

100.0%

.0%

.

899

Scottish Borders

% of Total

0

64.2%

2.7%

1.923

412

1

35.8%

2.7%

1.923

197

Total

100.0%

.0%

.

609

Shetland Islands

% of Total

0

52.9%

2.9%

.391

347

1

47.1%

2.9%

.391

259

Total

100.0%

.0%

.

606

South Ayrshire

% of Total

0

67.1%

2.5%

1.889

479

1

32.9%

2.5%

1.889

191

Total

100.0%

.0%

.

670

South Lanarkshire

% of Total

0

68.1%

1.6%

1.851

1105

1

31.9%

1.6%

1.851

422

Total

100.0%

.0%

.

1527

Stirling

% of Total

0

56.7%

2.7%

1.297

350

1

43.3%

2.7%

1.297

220

Total

100.0%

.0%

.

570

West Dunbartonshire

% of Total

0

72.1%

2.4%

1.547

372

1

27.9%

2.4%

1.547

127

Total

100.0%

.0%

.

499

West Lothian

% of Total

0

64.8%

2.1%

1.605

502

1

35.2%

2.1%

1.605

232

Total

100.0%

.0%

.

734

Complex Samples: Plan

back to top uparrow
This sets up a new plan file with no clustering (ie Case number used as cluster

Warnings

This procedure does not check the consistency of the working data file with the plan file. We recommend looking at the output table or the plan file to check consistency before performing selection or analysis.

Summary

Stage 1

Design Variables

Stratification

1

stratum

Cluster

1

unique identifier

Analysis Information

Estimator Assumption

Sampling with replacement

Plan File: G:\peas\ex2datafiles\data\ex2v2.csaplanWeight Variable: gross_wt

Complex Samples: Tables

Whether person uses the --internet

Estimate

Standard Error

95% Confidence Interval

Design Effect

Square Root Design Effect

Lower

Upper

Population Size

0

2629825.839

13922.996

2602536.115

2657115.564

1.561

1.249

1

1364224.456

13660.101

1337450.017

1390998.896

1.503

1.226

Total

3994050.296

11492.375

3971524.701

4016575.890

.

.

% of Total

0

65.8%

.3%

65.2%

66.5%

1.283

1.133

1

34.2%

.3%

33.5%

34.8%

1.283

1.133

Total

100.0%

.0%

100.0%

100.0%

.

.