.
...
| Description |
|---|
| Excerpt |
|---|
...
value |
...
specifies |
...
the |
...
type |
...
of |
...
trendline |
...
to |
...
display |
...
on |
...
the |
...
graph. |
...
| Signature | ||||
|---|---|---|---|---|
| ||||
public sealed class Regression : TypesafeEnum
{signature}{signature: |
| Signature | ||||||
|---|---|---|---|---|---|---|
| }
| |||||
Public NotInheritable Class Regression
Inherits TypesafeEnum
{signature}
{remarks}
A linear trendline can be achieved by setting the [Trendline.RegressionType] to Polynomial, and the [Trendline.RegressionValue] to 1.
{remarks}
{values}
|| Name || Description ||
| {anchor: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 | 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 | A line that smoothes out fluctuations in data to show a pattern or trend more clearly. |
| {anchor: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 | 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. |
| Values |
|---|
Name | Description | ||||||
|---|---|---|---|---|---|---|---|
| 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. | ||||||
| A best-fit curved line used when the rate of change in the data increases or decreases quickly and then levels out. | ||||||
| A line that smoothes out fluctuations in data to show a pattern or trend more clearly. | ||||||
| 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. | ||||||
| A curved line that is best used with data sets that compare measurements that increase at a specific rate. |