Question

Bus and subway ridership in Washington, D.C. dur- ing the summer months is believed to be heavily tied to the number of tourists visiting the city During the past 12 years, the following data have been obtained NUMBER OF TOURISTS RIDERSHIP YEAR (1000,000s 100000s 15 10 13 15 25 4 4 15 16 12 24 20 27 10 20 34 17 15 (a) Plot these data and determine whether a linear model is reasonable (b) Develop a regression model. (c) What is expected ridership if 10 lion tourists visit the city?

Answer 1

a)

ridership 50 45 40 35 30 25 20 15 10 0 0 10 15 20 25

b

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.916665699
R Square	0.840276003
Adjusted R Square	0.824303603
Standard Error	4.073572418
Observations	12
ANOVA
	df	SS	MS	F	Significance F
Regression	1	872.9767442	872.9767442	52.608	2.74837E-05
Residual	10	165.9399225	16.59399225
Total	11	1038.916667
	Coefficients	Standard Error	t Stat	P-value	Lower 95%
Intercept	5.060077519	2.686944916	1.883208505	0.089052275	-0.926808842
tourist	1.593023256	0.219632305	7.253137252	2.74837E-05	1.103651983

)

y^ = 5.060077 + 1.59302325 * x

c)

x = 10

y^ = 5.060077 + 1.59302325 * 10

= 20.9903095

d)

when x = 0

5.060077 + 1.59302325 * 0

= 5.060077

Please rate