Question

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.

Answer 1

y = 1.06 x + 0.14

r² = 0.95

Step-by-step 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