|
Question 155091: Using Excel, plot each point on the same graph where the first coordinate is the number of hours and the second coordinate is the number of cars sold (hours, cars). After plotting each point, explain if there is a linear relationship between the number of hours worked and the number of cars sold.
Sales Hours Worked Cars
Sold
Tim 40 3
Bob 26 5
Brandi 10 1
Kurt 60 1
Kelly 30 7
Graph:
Explanation of linear relationship:
What is the first step I take to answer this question?
Answer by stanbon(75887)   (Show Source):
You can put this solution on YOUR website!
Using Excel, plot each point on the same graph where the first coordinate is the number of hours and the second coordinate is the number of cars sold (hours, cars). After plotting each point, explain if there is a linear relationship between the number of hours worked and the number of cars sold.
Sales Hours Worked Cars
Sold
Tim 40 3
Bob 26 5
Brandi 10 1
Kurt 60 1
Kelly 30 7
Graph:
Explanation of linear relationship:
------------------------------------------
I entered the hours worked and cars sold data into
a TI-83 and ran a Linear Regression program on the
data. The "r" correlation coefficient turned out to
be -0.178542 which is not significant.
--------------------
Cheers,
Stan H.
|
|
|
| |
