Skip to main content Skip to complementary content

NxTrendline

Information about the calculated trendline.

Warning noteEXPERIMENTAL.
This API is under development. Do not rely on it. It may change or be removed in future versions.

Properties

Name Description Type
qType

Type of trendline

One of:

  • AVERAGE or Average
  • LINEAR or Linear
  • POLYNOMIAL2 or Polynomial2
  • POLYNOMIAL3 or Polynomial3
  • POLYNOMIAL4 or Polynomial4
  • EXPONENTIAL or Exponential
  • POWER or Power
  • LOG or Logarithmic
String
qError NxValidationError
qCoeff

Coefficent c0..cN depending on the trendline type.

Array of Number
qR2

R2 score. Value between 0..1 that shows the correlation between the trendline and the data. Higher value means higher correlation.

Number (double)
qExpression

Trendline expression

String
qElemNo

Inner Dim elem no

Integer

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!