Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Signature
vb.net
vb.net
Public NotInheritable Class Regression
		Inherits TypesafeEnum
Remarks

A linear trendline can be achieved by setting the Trendline.RegressionType to Polynomial, and the Trendline.RegressionValue to 1.

Values

Name

Description

Anchor
Exponential
Exponential
Exponential

A curved line that is most useful when data values rise or fall at increasingly higher rates. You cannot create an exponential trendline if your data contains zero or negative values.

Anchor
Logarithmic
Logarithmic
Logarithmic

A best-fit curved line used when the rate of change in the data increases or decreases quickly and then levels out.

Anchor
MovingAverage
MovingAverage
MovingAverage

A line that smoothes out fluctuations in data to show a pattern or trend more clearly.

Anchor
Polynomial
Polynomial
Polynomial

A curved line used when data fluctuates. The order of the polynomial can be determined by the number of fluctuations in the data or by how many bends (hills and valleys) appear in the curve.

Anchor
Power
Power
Power

A curved line that is best used with data sets that compare measurements that increase at a specific rate.

Remarks

A linear trendline can be achieved by setting the Trendline.RegressionType to Polynomial, and the Trendline.RegressionValue to 1.