naseeam

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 ?

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 ?

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Good explanation Ejgil

ASKER

Very nice explanation! Thank you!

ASKER