Calculating a and b in excel (any excel masters)?

4 replies · 3K views · last reply
PCSL
Messages
146
Reaction score
0
Attached is a problem that I am supposed to use excel to find the best estimates of a and b. As I am horrible at excel could someone give me some pointers or an idea how to start? Please don't do it for me, I want to learn how to do it - I just need some help.
 
Attachments
  • Typeset summary of the weighted least-squares method for fitting y = a + bx to a line, giving formulas for Delta, a, b, the uncertainty in each y-value, and the uncertainties in a and b.
    Untitled.jpg
    22.5 KB · Views: 442
I guess a simpler question would be how would I go about entering summations in excel.
 
PCSL said:
I guess a simpler question would be how would I go about entering summations in excel.

One way is to select a cell, type "= sum(", then (left click) drag the mouse over the set of cells to be summed (release left click), then finish typing ")". The sum of the contents of the selected cells should then appear in the chosen cell.
 
Thanks for that gneill - can no one help me on the original question? :(
 
Another small question, is the sigma in the equations referring to the standard deviation or uncertainty?