Question

A highway department is studying the relationship between traffic flow and speed. The following model has been hypothesized.

y=b0+b1X+E

where
y= traffic flow of vehicles per hour
X= vehicle speed in miles per hour

The following data were collected during rush hour for six highways leading out of the city.

Traffic flow(y)	vehicle speed(X)
1169	30
1134	40
1162	30
1223	35
1166	25
1285	40

a) the following Regression equation
y=___________+__________x (2 decimals)
b) use a=0.05 significance
s=________________ (4 decimals)
r2= ______________
r2 adj= ________________

Source	DF	SS	MS	F	P-Value
regression
residual				----------	---------
total			--------------	-----------	---------

Answer 1

a)

Here, we perform linear regression as :

Regression equation is :

Y = 1066.5 + 3.7 X

b)

Now, to test the significance of linear regression, we use Excel Data Analysis Tool Pack

Output :

Consider Standard error in the above output :

S = 55.9933

Consider R square in the above output :

r² = 0.1668

Consider Adjusted R square in the above output :

r² adj = - 0.0416

ANOVA Table :

Source	df	SS	MS	F	P-value
Regression	1	2509.8333	2509.8333	0.8005	0.4215
Residual	4	12541	3135.2500
Total	5	15050.8333