In: Statistics and Probability
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 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
Provide your answer below:
y = _x + _
The regression equation is:
The model run in excel gives the following output:
Let me know in the comments if anything is not clear. I will reply ASAP! Please do upvote if satisfied!