ok am this is a request to all those maths ppl am there is a set of data on the top left (note just look at the first 2 columns the points for these results are in blue and not pink) the name of alcohol is taken as ethanol is x=1, propanol is x=2 and so on and the y is those negative numbers not with thap’s help i have been able to get excel to display the formula of the line of best fit in Y = 747.8x - 494.37 format i need to know the formula and the method for how excel got this if any one can help it will be appreciated.
flamez yaar there is a statistical formula to work the Y= bla bla stuff out . and i have the answer and i know if i put X in to the equation i will get an answer . i need to show how i got that equation
The reason you are probably getting contradicting answers is b/c the points plotted do not give you a linear line. It’s the best fit line. And since the slope in this case is created by the computer, you don’t know which two points were used to calculate that. You better option would be to take points on your own and calculate the slope as hayaa and rolo have suggested. Take two points that when connected are a straight line, a line that best fits to the rest of the points as well. Do it by yourself and not the comp