How can I get the LINEST function in Excel to return more than just slope?

  • Thread starter Thread starter johnhuntsman
  • Start date Start date
  • Tags Tags
    Excel Uncertainty
Join the discussion
Registration is free. Start your own thread to ask a follow-up.
Sign up Log in
2 replies · 3K views
johnhuntsman
Messages
76
Reaction score
0
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.
 
Physics news on Phys.org

Discussion

johnhuntsman said:
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.
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.
 
I managed to figure it out snooping around Excel's help. Thanks : D