Uncertainty in Excel (LINEST)

  • #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.
 

Answers and Replies

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

Related Threads on Uncertainty in Excel (LINEST)

  • Last Post
Replies
13
Views
4K
  • Last Post
Replies
2
Views
8K
  • Last Post
Replies
3
Views
3K
  • Last Post
Replies
3
Views
728
  • Last Post
Replies
1
Views
993
  • Last Post
Replies
3
Views
3K
Replies
4
Views
3K
  • Last Post
Replies
8
Views
58K
  • Last Post
Replies
5
Views
6K
  • Last Post
Replies
0
Views
8K
Top