Worksheet Description

WITHIN_OPTS Summarizes chi squared results for the split-sample external validity tests 

with regional responses split by option. Option 1 = Option A and Option 2 

= Option B. ***, **, * indicates significance at 1%, 5%, 10% levels, 

respectively.

MEAN_AND_STDEV Summarizes mean and standard deviation of responses and attribute 

levels split by option and percent fish saved. Option 1 = Option A and 

Option 2 = Option B.

CHISQ_TESTS_FOR_EXTERNAL_SCOPE_12DEC12.xls

Author: Abt Associates Inc.

Created: 12/12/12

Purpose: This is an output file from SAS code for the split-sample external validity test for each 

stated preference (SP) survey region with the data split by option. Refer to Chapter 11 of the 

Benefits Analysis for additional detail regarding the objectives of the test.
WITHIN_OPTS

region option _PCHI_ DF_PCHI P_PCHI significance

Northeast 1 42.42748277 2 6.12335E-10 ***

Northeast 2 58.80628153 2 1.69972E-13 ***

Southeast 1 35.57727314 2 1.88145E-08 ***

Southeast 2 23.29486377 2 8.74147E-06 ***

Pacific 1 53.8912522 2 1.98456E-12 ***

Pacific 2 76.62861403 2 2.29249E-17 ***

Inland 1 5.004617834 2 0.08189569 *

Inland 2 15.76648593 2 0.000377008 ***

National 1 13.60113182 2 0.001113145 ***

National 2 24.05750104 2 5.97008E-06 ***

Page 1
MEAN_AND_STDEV

reg region Option fish_save yes sample choice_mean choice_std

Northeast 1 1 5 93 376 0.247340426 0.432041172

Northeast 1 2 5 91 388 0.234536082 0.424255592

Northeast 1 1 50 159 372 0.427419355 0.495370271

Northeast 1 2 50 151 342 0.441520468 0.497295941

Northeast 1 1 95 175 379 0.461741425 0.499193134

Northeast 1 2 95 193 397 0.486146096 0.500438705

Southeast 2 1 25 135 462 0.292207792 0.45527029

Southeast 2 2 25 121 465 0.260215054 0.439224381

Southeast 2 1 55 166 462 0.359307359 0.480317543

Southeast 2 2 55 129 439 0.293849658 0.456043622

Southeast 2 1 90 223 465 0.479569892 0.50012049

Southeast 2 2 90 194 485 0.4 0.49040378

Inland 4 1 2 51 264 0.193181818 0.395544229

Inland 4 2 2 63 270 0.233333333 0.423738013

Inland 4 1 50 99 266 0.372180451 0.484297333

Inland 4 2 50 105 255 0.411764706 0.49312081

Inland 4 1 95 139 282 0.492907801 0.500838498

Inland 4 2 95 172 287 0.599303136 0.490895644

Pacific 3 1 55 260 712 0.365168539 0.481815863

Pacific 3 2 55 195 719 0.271210014 0.444893727

Pacific 3 1 75 288 739 0.389715832 0.48801606

Pacific 3 2 75 229 708 0.323446328 0.468122119

Pacific 3 1 95 308 729 0.422496571 0.494295836

Pacific 3 2 95 277 753 0.367861886 0.482544036

National 5 1 25 85 260 0.326923077 0.469993586

National 5 2 25 78 285 0.273684211 0.446633068

National 5 1 55 95 266 0.357142857 0.480060643

National 5 2 55 72 239 0.30125523 0.459766215

National 5 1 95 125 263 0.475285171 0.500340928

National 5 2 95 122 265 0.460377358 0.499370673

Page 1
MEAN_AND_STDEV

com_fish_mean com_fish_std fish_pop_mean fish_pop_std aquatic_mean aquatic_std

45.29787234 2.143292357 28.42553191 1.332581348 52.42819149 1.24371612

45.31701031 2.120411283 28.32216495 1.203708075 52.38402062 1.217636258

45.0483871 1.985886206 28.25806452 1.218927334 52.29301075 1.236312476

45.41520468 2.067086674 28.41520468 1.27580799 52.28947368 1.256469598

45.38522427 2.077695391 28.06596306 1.165363131 52.34828496 1.249366385

45.33501259 2.025371474 28.5163728 1.256441561 52.21410579 1.235829791

42.30952381 2.095723409 26.36580087 1.308390787 70.37878788 1.248610613

42.18709677 2.114564937 26.24301075 1.174018101 70.32043011 1.24157151

42.22077922 2.032000243 26.2987013 1.239952435 70.31601732 1.249608591

42.41457859 1.999170317 26.38496583 1.249603384 70.29157175 1.262995294

42.5655914 2.065860357 26.06666667 1.167938551 70.34408602 1.246500478

42.41237113 2.005944561 26.56701031 1.27034856 70.22061856 1.210656722

59.22348485 2.11262221 34.36742424 1.307131432 53.41666667 1.245778677

59.15555556 2.111630624 34.2962963 1.210696282 53.36666667 1.244616661

59.15789474 2.018189382 34.31203008 1.211737414 53.30075188 1.255838966

59.42745098 2.023880893 34.29803922 1.215628251 53.30588235 1.258265862

59.62411348 2.056286281 34.16312057 1.205704788 53.35815603 1.23245876

59.47735192 2.027436622 34.55052265 1.288759122 53.12891986 1.177038427

42.27949438 2.05801258 35.40308989 1.330859098 44.41151685 1.266480978

42.20445063 2.131128148 35.18776078 1.18935172 44.38942976 1.270492012

42.19350474 2.066420397 35.31258457 1.234548382 44.28146143 1.238199596

42.40677966 2.006653522 35.36299435 1.234642835 44.29378531 1.256886353

42.57750343 2.053498441 35.14814815 1.167320591 44.35802469 1.260971387

42.41301461 2.012115054 35.6188579 1.264076179 44.21513944 1.185656413

54.3 2.070756115 32.52307692 1.313519747 55.37692308 1.259805615

54.25614035 2.13150558 32.22807018 1.187041889 55.27017544 1.247810041

54.36466165 2.097282896 32.23684211 1.194450924 55.36466165 1.258372443

54.42259414 1.955726338 32.41422594 1.276799491 55.39330544 1.281787894

54.50190114 2.03006886 32.0418251 1.173075692 55.35361217 1.229587637

54.53207547 2.039363907 32.55849057 1.229904216 55.23396226 1.217757408

Page 2
MEAN_AND_STDEV

cost_mean cost_std

40.05319149 19.63608489

39.30927835 20.00457871

41.70967742 20.27204767

41.40350877 20.55636096

42.74406332 20.759786

43.85894207 21.67296533

39.84415584 19.42987721

40.15483871 20.18816931

42.28571429 19.43509615

41.22095672 20.43284843

43.1483871 20.78454547

44.31340206 22.27181644

39.86363636 19.60009805

39.77777778 20.61964511

43.53383459 18.73813541

39.95294118 20.43150987

42.76595745 20.78893707

43.02439024 21.77433766

39.57303371 19.20377813

39.88873435 20.52972228

42.98240866 19.36452388

41.08474576 20.31822209

43.47325103 20.8286352

45.05179283 22.20788448

39.32307692 19.30139547

40.71578947 19.88682582

41.09774436 20.03915588

40.11715481 19.8596673

42.06844106 20.93927681

44.10566038 22.52381244

Page 3