00:01
So for this problem, as you can see, i've copied in all of the data into excel.
00:06
The first thing that i'm going to do here is just slightly change around the way that the data is being displayed.
00:12
Because what i'm going to do here is do a linear regression where we have x is the month number, and then we have y is equal to the value in the bank account at each month.
00:26
So the point of doing this is this will give us the equation so that we can figure out x as a function of y.
00:32
So we'll do equals lin -est, known y's, known x's, b is calculated normally, and we do not need additional regression statistics.
00:46
So what this tells us is that for, we can say that y1 is equal to 2936 .96 plus 61 .822.
00:56
And i'll repeat the same process for y2 equals lin -est, known y's, known x's, true, b is calculated normally.
01:12
We do not need additional regression statistics.
01:15
We have y2 is equal to 3216 .68 plus 32 .99.
01:22
So what we can do now is just going to change the display of these.
01:29
So we have one, two, and then we'll drag this across, so it'll fill in for the remaining months.
01:34
All right.
01:36
So now that we know the equations, we can implement them.
01:41
So we have y equals 293 .96 plus, or, pardon me, that's 293 or 2936 .96 plus 6 .1 .822 times x...