00:01
That you need help with this problem and it says the following data represents property crime rate against individual crimes 1 ,000 per household in their household income in dollars in the united states in 2009.
00:12
So using a graphing utility, dry scatter diagram of this data using income x as the independent variable and crime rate y is a dependent variable.
00:22
So i'm going to show you how to use excel in order to solve this problem.
00:27
So first thing i'm going to do is i'm going to highlight the information, the income level is going to be x, and property crime rate is going to be y, the dependent variable.
00:37
And i'm going to insert a scatter diagram, and it says here, based on the scatter diagram, draw in part, and decide a model, linear, quadratic, cubic, exponential, or logarithmic, or logistic.
00:56
So if i go to add chart and i want to add a trend line there's all of these different options that i do have and i'm going to say that this is linear yes there is a little bit of a curvature here so i could delete this and we can see what a trend line that's exponential looks like but again it will be pretty linear again so i'm going to delete this and i'm going to move back to a linear trend line.
01:33
And so then what i'm going to do is i'm going to display the equation in the chart.
01:41
And i'm going to make it bold and bigger.
01:48
And this is the equation that i'm going to get.
01:53
And it says using the graphing utility, find the model best fit.
01:58
So i did do that...