NxTrendline

Information about the calculated trendline.

Stability index

EXPERIMENTAL.
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

This parameter is optional and is displayed in case of error.

NxValidationError
qCoeff

Coefficent c0..cN depending on the trendline type.

Array of Doubles
qR2

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

Double
qExpression

Trendline expression

String
qElemNo

Inner Dim elem no

Integer