Uncertainty in Excel (LINEST)

  • #1
johnhuntsman
76
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.
 

Answers and Replies

  • #2
SammyS
Staff Emeritus
Science Advisor
Homework Helper
Gold Member
11,603
1,190
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.
 
  • #3
johnhuntsman
76
0
I managed to figure it out snooping around Excel's help. Thanks : D
 

Suggested for: Uncertainty in Excel (LINEST)

Replies
1
Views
727
Replies
0
Views
260
  • Last Post
Replies
8
Views
1K
  • Last Post
Replies
2
Views
931
  • Last Post
Replies
3
Views
939
  • Last Post
Replies
1
Views
2K
Replies
4
Views
1K
Replies
1
Views
3K
  • Last Post
Replies
5
Views
7K
Top