00:01
In this problem, we're given a dataset and you have the speed of execution and the satisfaction rating for different companies.
00:16
So we want to find a scattered diagram or make a scattered diagram.
00:27
So that's part a.
00:31
You want a scatter diagram.
00:38
So what we do is you put the data in excel, as i have done.
00:46
Just type it up.
00:47
And then you go to data.
00:52
So to get this scattered diagram, which is here on the left, you go to data.
00:58
And then you go to and then insert and then you'll get scatter so that will give you this scattered diagram here of course you would need to edit the title here satisfaction to speed and then this is the graph you'll get so moving on to part b so for part b, we want to know what do we see here? just what's happening here.
01:59
So, i mean, just by looking at it, right? these points are very close together.
02:16
When there's more points.
02:17
So if we're to draw a very light trend line, you could talk about to do this, but it was not asked for.
02:27
So, well, let's say we do.
02:29
So this is just an example of a trend line.
02:38
It would be something like that.
02:40
So as you can see, as speed is increasing, satisfaction is also increasing.
02:51
Seeing right it's going up so that's what we need to say that's what we visually see so we'll say there is a strong and then you're going to say why is this strong well if you get the correlation coefficient that's a step further the correlation coefficient will be very close to one but just by looking at as well so there is a strong and it's positive right positive linear relationship between feed and satisfaction so between both of the variables okay so now from here we want to find the least squares regret function.
04:10
Okay, so let's focus on this output here.
04:23
This is part c, the least squares regression function, or how do you find that, right? so what you need to do is you still go to data, but now you're going to go to data analysis.
04:50
So data analysis will be on the top of the ribbon.
04:56
So the ribbon is just the top of the excel sheet.
05:05
And then from there you'll put regression.
05:10
And you'll use the data that you input it on excel.
05:15
And once you do that, you'll get this output right here.
05:26
Okay.
05:28
So, so...