Page History

<table class="diff-macro"><thead><tr><th class="diff-macro-title">unmigrated-wiki-markup</th></tr></thead><tbody><tr><td class="diff-macro-body"><pre>
 public Regression RegressionType{ get; set; }
{signature}{signature:</pre></td></tr></tbody></table>

<p>Public Property RegressionType() As Regression
{signature}
{remarks}
This object will return a [Regression</p>

This object will return a Trendline.Regression

value

specifying

what

sort

of

equation

is

used

to

calculate

the

trendline.

Note

that

linear

trendlines

have

a

RegressionType

of

Polynomial,

with

a

Trendline.RegressionValue

of

1.

After

modifying

this

property,

the

Trendline.RegressionValue

property

may

be

adjusted

to

ensure

it

is

within

the

valid

range

for

the

new

regression

type.

If

the

current

RegressionValue

is

larger

than

the

new

regression

type

allows,

it

will

be

set

to

the

largest

value

allowed

for

the

new

type.

Similarly,

if

the

current

RegressionValue

is

smaller

than

the

new

regression

type

allows,

it

will

be

set

to

the

smallest

value

allowed.

For

example,

if

the

RegressionValue

is

13,

and

you

change

the

regression

type

to

Polynomial,

the

RegressionValue

will

be

changed

to

6

-

the

maximum

value

Excel

allows

for

Polynomial

regressions.