Excel help

[DarkKnight]

I need to perform a least square fit on a set of data points, and find the slope, intercept, and uncertainty of slope and intercept of the line. Does anyone know the excel commands for these functions?

 

[gcol]

LOL

Suggest you try www.nasa.gov for that.

gcol

 

[MrChad]

Originally posted by: DarkKnight
I need to perform a least square fit on a set of data points, and find the slope, intercept, and uncertainty of slope and intercept of the line. Does anyone know the excel commands for these functions?

Here's an add-in that will calculate a least square fit.

EDIT: Here are some instructions (PDF) for line fitting and uncertainty.