Link to home
Start Free TrialLog in
Avatar of naseeam
naseeamFlag for United States of America

asked on

How does LINEST operate in Microsoft Excel ?

I'm using Microsoft Excel 2013.  Please consider following Linear Estimation Formula:

LINEST ( I7 : I9 , H7 : H9)

I7 = 0
I8 = -4000
I9 = 3900

H7 = 637
H8 = 588
H9 = 685

Please explain Linear Estimation and LINEST excel formula ?
Avatar of naseeam
naseeam
Flag of United States of America image

ASKER

Is Linear Estimation same as Linear Approximation ?
ASKER CERTIFIED SOLUTION
Avatar of Ejgil Hedegaard
Ejgil Hedegaard
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Professor J
Professor J

Good explanation Ejgil
Avatar of naseeam

ASKER

Very nice explanation!  Thank you!