00:01
To given question, we need to find the regression fit and for that we need to use the excel for tabulate the data in the right order.
00:15
And here we will column we will enter in the column we will enter 0 to 10 corresponding to the years which are 1964 to 1970 and jlp in column b, second column this is for column a.
00:35
And after that we can go to the data tab and then data analysis we will select the regression from the list.
00:44
And we will input our value as y range and then select g &p data in the excel sheet for 1 to 11.
01:06
And for input range, again we will put our range for x range.
01:16
We will select here our years from 1964 to 19704.
01:28
And to select the location where you want to output, click ok.
01:32
So then we can see our graph like this.
01:35
As we can see here, this is our graph.
01:39
By using halts method, we can predict our j and v10.
01:46
So now for the halts method, method to predict g &p.
02:02
Here our value for alpha is 0 .2 and beta is given as 0 .1.
02:09
So the formula, forecasted value, forecasted value, yt plus ht will be equal to.
02:22
Lt plus hbt.
02:26
So let's find out our value at level lt...