Answer:
Check the explanation
Step-by-step explanation:
Open file in excel.
Click on Data->Data Analysis and select Regression.
Enter wait time data range in y-variable.
Enter Duration data range in x-variable.
Click ok.
From above output:
#1 The equation of the linear regression line is:
A 95% confidence interval for the slope of the regression line is:
[tex]{(10.110,11.349)}[/tex]
In excel, ise formula =FORECAST(6,wait time data range, duration data range) and press enter. The wait time between eruptions following a 6 minute eruption is [tex]\hat{Y}_{x=6}= 97.9} .[/tex]
Since (for F test) [tex]p-value=0.000<0.05[/tex] , we can conclude that there is a statistically significant linear relationship between the duration of the eruptions and the wait time between eruptions.
The correct null and alternative hypotheses for this analysis:
[tex]{ H_0:\beta_1=0 \ H_a:\beta_1\ne 0}[/tex]
Kindly check the output below