Question

Hey does anyone know how to draw a best fit line on excel

Answer 1

Yes. There are a couple of methods.

The easiest is as follows:
1) Plot the data on a scatter plot.
2) Click on a data point on the chart. The data points should be highlighted.
3) Right click>Add Trendline
4) A format box should come up. Select the options.

Answer 2

what options should i select

Answer 3

Mainly the type of fit. Then you may wish to add the equation of the line to plot and the R^2 value, which represents how well of a fit the line is to the data.

Answer 4

none of my pt went through the line

Answer 5

Attach the excel sheet.

Answer 6

actually it worked once i selected linear but let me attach plez

Answer 7

i want a line to go throught the pts above best fit line and line go below... one sec

Answer 8

Looks perfect.

Answer 9

can you please show me how i can insetrt a line above the best fit line( so it goes throught the pts abpve)