SOLUTION: 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
Algebra.Com
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.
RELATED QUESTIONS
Graphing a parabola exercise
o Choose a graphing program to work with, either... (answered by solver91311)
How to you find the caresian coordinat of x and y point when the coordinates of the point (answered by venugopalramana)
Graph 2x - y = 6 and x + 3y = 3 on the same coordinate plane. What is the point of... (answered by Fombitz)
Plot points with coordinates (2, 3), (3, 4), and (4, 5) on a graph. What do you observe?... (answered by josmiceli)
if you were plotting the point (0,16) on a coordinate graph, how would you plot... (answered by Fombitz)
On the rectangular coordinate system, plot the point (-1,... (answered by richwmiller)
On the rectangular coordinate system, plot the point (–1,... (answered by MathLover1)
Where on the graph of 2x-6y=7 is the x-coordinate twice the... (answered by sudhanshu_kmr)
On a number line, point A has coordinate -5 and point B has coordinate 1. Find the... (answered by stanbon)