00:01
So in this question, we are given some values of x and values of y.
00:06
And we're first asked to develop the regression equation between x and y.
00:14
So basically y equals b0 plus b1 x.
00:17
So let's go ahead and do that.
00:19
So our input y range is b1 through 6.
00:28
Our input x range is a1 through 6.
00:34
Click okay, put in our output range, so we're going to put the output over here.
00:45
Take a look.
00:50
So we have our regression statistics here.
00:53
Our adjusted r squared is pretty low.
00:57
And if we look, we see we have the intercept and we have the coefficient for x.
01:05
So basically the equation that we have is going to write it over here.
01:22
Part a y is equals to 9 .315 plus 0 .424 so this is basically our equation we're asked to comment on the adequacy of this equation for predicting y so basically we see from this equation we see two things we see that the adjusted r squared it's less than 0 .5 we also see that the p -value for x for the coefficient of x is basically point one -one, which is less than 0 .05.
02:20
So we say that the relationship is not significant between x and 1.
02:36
So that's our answer to part a.
02:42
Now let's move on to part b.
02:44
We're asked to develop an estimated regression equation.
02:47
Of the form y is equals to b0 b1 x b2 x squared so let's go ahead and do that so we're going to open up another sheet and copy these values we're going to add another column for x squared so let's do that so let's square all of our values here so we have equals square.
03:45
So we have our two independent variables and our dependent variables.
03:51
And then let's go ahead and create our multiple regression equation...