NxTrendline

Information about the calculated trendline.

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

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!