00:01
So a regional express delivery service company recently conducted a study to investigate the relationship between the cost of shipping package y, the package weight x1, and the distance shipped x2.
00:14
Okay.
00:15
So 20 packages were randomly selected from among a large number received shipment.
00:23
In the detail analysis of the shipping cost was conducted for each package.
00:27
This sample observations are given in the file and it gives the file.
00:31
Estimate the simple linear regression equation involving the shipping cost and the package weight.
00:42
Interpret the slope coefficient of the least squares line and the r squared value.
00:47
So i'm using excel to do this and so i'm going to insert.
00:53
I'm going to highlight what i want and i'm going to insert a scatter plot.
00:58
And this is, i'm going to add in a title.
01:04
Oops.
01:08
And this is going to be for the axis title.
01:15
This is package weight.
01:22
And then, i have package weight.
01:31
And then i have for axis title for the x, it's cost of shipment.
01:42
And then i want to include the trend line, which is going to be linear.
01:54
And to get the equation and the r squared, i'm going to make this bigger so that you can see this.
02:10
So the equation of the trend line is y equals 0 .3101 x plus 4 .4 .1.
02:18
1 .9571 and r squared equals 0 .3361.
02:26
And then it says add another explanatory variable, distance shipped to the regression model in part a.
02:36
Estimate and interpret this expanded equation.
02:40
How does the r squared value for this multiple regression equation compare to that of the simple regression equation in part a.
02:48
So it wants to add another.
02:52
Let me see if it will do this...