Question

The data below shows the duration of eruption (in seconds) of a geyser in a national park and the height (in feet) of the eruptions for a typical day. Use Excel to find the best fit linear regression equation, where duration of eruption is the explanatory variable. Round the slope and intercept to one decimal place.Duration Height240 140237 154122 140267 140113 160258 140232 150105 150186 160248 155243 125241 136214 140114 155272 130227 125237 125238 139203 125270 140218 140226 135250 141245 140120 139267 110103 140270 135241 140239 135Provide your answer below:y = _x + _

Answer 1

ŷ = -0.08522X + 157.7779

The slope = - 0.1

Intercept = 157.8

Explanation:

Given the data :

Duration __ Height

240 140

237 154

122 140

267 140

113 160

258 140

232 150

105 150

186 160

248 155

243 125

241 136

214 140

114 155

272 130

227 125

237 125

238 139

203 125

270 140

218 140

226 135

250 141

245 140

120 139

267 110

103 140

270 135

241 140

239 135

General regression equation :

y = mx + c

Where

y = predicted variable

x = predictor / explanatory variable

m = slope or gradient

c = Intercept

The regression equation obtained ;

ŷ = -0.08522X + 157.7779

To one decimal place :

ŷ = -0.1X + 157.8

The slope = - 0.1

Intercept = 157.8