00:01
For the given, for the given data of x and y, we have to develop the 95 percent confidence interval and prediction interval when x naught, that is the given x value, that is equal to 4.
00:40
Here, we are going to use, going to use excel, excel for data calculations, data calculations.
01:01
We are going to use here excel functions to calculate the data.
01:09
For basic calculations, we use excel here.
01:12
So, the given value of n is equal to 5, that means x having 5 observations and y also having 5 observations, both having same size.
01:22
Then the degrees of freedom is equal to n minus 2, that is equal to 3.
01:29
Next, mean of x, that is equal to average of x.
01:40
We are using average function in the excel and selecting the data range of x, we get the result for, this also be denoted with x bar, x bar is equal to 9, x bar is equal to 9.
01:57
And the given, given value of x naught is equal to 4, under these value of x naught, we have to estimate the value of y, that is estimated value of y, that is y naught cap by using the function in the excel forecast, forecast of x naught value comma y data range and excel data range has to be selected, that is equal to 10 .988, 10 .988...