0:00
Question.
00:01
It wants you to calculate the least squares method to determine the regression coefficients and to find the regression equation.
00:14
What you have to do in order to do this, and you can use paper, pencil, or you can use excel.
00:19
I'm just using excel as a calculator.
00:21
I'm going to explain the process as i go.
00:24
First thing i'm going to do is i'm going to find the sum of the monthly rents and the sum of the size.
00:34
Then i'm going to find the mean of the monthly rents.
00:39
That is 8.
00:42
I'm sorry, divide that by 8.
00:44
Then i'm going to find the mean of the sizes.
00:49
Then what i'm going to do next is i'm going to take your x values and subtract them from the mean of x.
01:01
The x column is your monthly rent.
01:03
The y column is your size.
01:07
Then how i do this is i'm going to then divide this by 1473.
01:19
I'm going to do it to every single value.
01:30
Then i'm going to do it to the 1.
01:36
I'm going to do it to the y's too.
01:38
I'm going to take each y value, subtract your mean of y.
01:45
I'm going to do 750 minus 1143 .75.
02:01
I'm doing that to every value.
02:03
Then i'm going to find the sum of the products.
02:08
To get the sum of the products, you're going to take each of these values.
02:14
You're going to take your d column and multiply it by your e column.
02:25
Then you're going to total.
02:30
This is called the sum of products.
02:36
You need this value here...