Eco-04/ revision

Sheet1

zone	total visits/year	zone population	visits/1000
0	400	1000	400
1	400	2000	200
2	400	3000	100
3	400	8000	50
beyond 3	0
total visits	1600	14000	750
zone	total visits	total travel cost/trip
0	400	0
1	400	10.5
2	400	21
3	400	42
SUMMARY OUTPUT
Regression Statistics
Multiple R	0.9999943711
R Square	0.9999887422
Adjusted R Square	0.9999662265
Standard Error	0.0075026053
Observations	4
ANOVA
	df	SS	MS	F	Significance F
Regression	2	4.9999437109	2.4999718555	44413.0830925111	0.0033552671
Residual	1	0.0000562891	0.0000562891
Total	3	5
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	0.2	0.0058114931	34.4145640071	0.0184933533	0.1261579793	0.2738420207	0.1261579793	0.2738420207
X Variable 1	0	0	65535	ERROR:#NUM!	0	0	0	0
X Variable 2	0.0707482993	0.0002415565	292.88506849	ERROR:#NUM!	0.0676790327	0.073817566	0.0676790327	0.073817566
zone	travel cost plus $10	visits/1000	population	total visits
0	10	252	1000	252
1	20.5	171	2000	342
2	31	90	4000	360
3	52	0	8000	0
			total visits	954
entry fee	total visits
$20	409
$30	129
$40	20
$50	0

zone 0 1 2 3 total visits 400 400 400 400 total travel cost/trip 0 10.5 21 42

demand curve

entry fee 20 30 40 50 total visits 409 129 20 0