All the data points are used to calculate the best straight line.Įxcel can be used to perform a linear regression analysis (and to add the trendline equation determined from this to a graph) in the following fashion:Ĭlick on Add Chart Element and then select Trendline section followed by More Trendline Options.The precision of each y measurement is the same.The precision of x is much greater than that for y.The assumptions usually made in this procedure are: The analysis of experimental results often involves the drawing of a straight line through the data points the linear regression technique allows for the calculation of such a line. Using Excel 2016 - Add a Trendline (with Equation) to a Graph (VIEW THIS TUTORIAL AS A VIDEO)
