• Support PF! Buy your school textbooks, materials and every day products Here!

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,303
998
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
3
Views
619
  • Last Post
Replies
2
Views
7K
  • Last Post
Replies
3
Views
3K
  • Last Post
Replies
13
Views
3K
  • Last Post
Replies
1
Views
933
Replies
4
Views
3K
  • Last Post
Replies
3
Views
3K
  • Last Post
Replies
5
Views
6K
  • Last Post
Replies
8
Views
56K
  • Last Post
Replies
0
Views
8K
Top