A) Using Excel, or some other graphing software, plot the values of y as a function of x. (You will not submit this spreadsheet.
However, the results will be needed later in this problem).
x y
1 2.5
2 3.3
3 4.5
4 4.9
5 7.0
B) Use the trendline option to draw the best fit line for the above data and use it to determine the slope and y-intercept.
x y
1 2.5
2 3.3
3 4.5
4 4.9
5 7.0
B) Use the trendline option to draw the best fit line for the above data and use it to determine the slope and y-intercept.
1 answer:
Answer:
y = 1.06 x + 0.14
r² = 0.95
Explanation:
a) To make this graph, a spreadsheet-type calculation program is used, see attached.
On the y axis are the measured values
On the x-axis, the values checked in the experiment are placed.
From the graph we see that a linear graph and that one of the values has a strong deviation with respect to the others
b) The red line is the best straight line that can be drawn,
for this the quality ajust is r²
the closer to 1 the better the fit
the equation of the line is
y = 1.06 x + 0.14
r² = 0.95
You might be interested in