Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

2.1.978 Part 1 Section 18.17.7.199, LOGEST

a. The standard specifies the equation for the curve is y = b * mx or y=b*(m1*x1)*(m2*x2)*...) if there are multiple values

Office uses the following equation for the curve: y = b * (m^x) or y=b*(m1^x1)*(m2^x2)...(mn^xn) if there are multiple values

b. The standard does not place any restrictions on dimensions of known-ys or known-xs.

In Office, if known-ys and known-xs are not the same size, or known-ys does not contain exactly one value for each row or column of known-xs, #REF! is returned.

c. The standard specifies the following syntax: LOGEST ( known-ys [ , [ known-xs ] [ , [ const-flag ] [ , stats-flag ] ] ).

Office uses the following syntax: LOGEST ( known-ys [ , [ known-xs ] [ , [ const-flag ] [ , [ stats-flag ] ] ] ] ).

Show:
© 2015 Microsoft