00:01
All righty, guys.
00:02
Let's go ahead and jump into problem number 22 here.
00:05
Okay, so for part a, we need to find the least squares regression line.
00:09
Looks like they want us to find the equation.
00:11
And so in order to do that, i started a google sheet, and i looked at the table on page 207.
00:16
That's actually underneath problem number 22 in our text.
00:19
And i went ahead and copy down the data with the year being x and the prescriptions being y.
00:23
And now i'm going to go ahead and find my least squares regression equation.
00:26
In order to do that, i'm going to highlight the data.
00:28
I hit insert chart.
00:29
And hopefully it gives me a scatter chart, and it does.
00:32
Fantastic.
00:32
I'm going to move it over here because i want to.
00:36
And then i'm going to go ahead, double click back on the chart.
00:39
If that happens, no big deal.
00:40
If you don't get a scatter chart, you can go under setup chart type.
00:45
It gave me a scatter chart.
00:46
You can click the drop down if you want to choose it yourself.
00:49
Okay, and also notice i did x and y to label it as well.
00:52
All right, the next thing i need to do to find the equation is to go under customize, which is over here, and then series.
00:58
I do need to scroll down a touch, and i'm just going to click on trendline.
01:02
Now, that's a good trend line right there, but it's not what i want.
01:04
I do want the equation.
01:05
If i scroll down even further, my equation, it could be under label, which is right here, use equation, and there we go.
01:12
Very good.
01:13
Okay.
01:13
And so that is our equation there, and that should take care of part a.
01:18
I'm just going to double check really quickly.
01:20
Perfect.
01:21
Okay.
01:22
All right.
01:23
I could click on rscort if i wanted to, but it doesn't look like they want that, so that's okay.
01:26
Okay...