Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Homework Help: Calculating a and b in excel (any excel masters)?

  1. Jan 24, 2012 #1
    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.

    Attached Files:

  2. jcsd
  3. Jan 24, 2012 #2
    I guess a simpler question would be how would I go about entering summations in excel.
  4. Jan 24, 2012 #3


    User Avatar

    Staff: Mentor

    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.
  5. Jan 24, 2012 #4
    Thanks for that gneill - can no one help me on the original question? :(
  6. Jan 25, 2012 #5
    Another small question, is the sigma in the equations referring to the standard deviation or uncertainty?
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook