1. Limited time only! Sign up for a free 30min personal tutor trial with Chegg Tutors
    Dismiss Notice
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: Uncertainty in Excel (LINEST)

  1. Sep 20, 2012 #1
    I figured there ought to be some Excel savvy people here. Anyway I can't seem to get the LINEST function in Excel to return anything other than slope. I provide it with y-values, x-values, and say true to constant and stats. All it gives me back is a slope. Maybe I'm being vague, just ask if you need any other information but I don't know why it won't give me back things other than slope.
  2. jcsd
  3. Sep 20, 2012 #2


    User Avatar
    Staff Emeritus
    Science Advisor
    Homework Helper
    Gold Member

    It's been some time since I've used that feature! But it does work.

    Do you know how to use the 'array' feature of Excel?

    Look over all the help Excel gives for the LINEST function and for arrays.
  4. Sep 21, 2012 #3
    I managed to figure it out snooping around Excel's help. Thanks : D
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook