[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] (OFFICE-3958) Add polynomial regression type, force-intercept and regression-name
[ https://issues.oasis-open.org/browse/OFFICE-3958?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=70129#comment-70129 ]
Regina Henschel edited comment on OFFICE-3958 at 6/7/18 9:40 AM:
-----------------------------------------------------------------
(2) My suggestion is to drop {{chart:regression-min-degree}} totally. I know no application that offer it. When someone implements it, we can think about adapting the descriptions.
(1)(3) Such description is already missing in the current specification. Of cause we can improve it now, while we work on that section anyway.
We can add the following part to section 20.43. Please review, whether it is correct in content. Improving wording and using formula editor can be done afterwards.
Calculating the model parameter is done by the same algorithm as used for LINEST function.
Let X denote the array of the abscissa of the data points of the series and Y the array of the associated ordinates.
* For case {{chart:regression-force-intercept="false"}} the calculation can be:
For regression type:
{{exponential}}, model y=A*EXP(B*x): LINEST(LN(Y),X,1) results B,LN(A)
{{linear}}, model y=Ax+B: LINEST(Y,X,1) results A,B
{{logarithmic}}, model y=A*LN( x )+B: LINEST(Y,LN(X),1) results A,B
{{polynomial}}, model y = A_0 + A_1 x + A_2 x^2 + ... + A_n x^n : LINEST(Y,X,X^2,...,X^n,1) results A_n,...A_1,A_0
{{power}}, model y = A*x^B : LINEST(LN(Y),LN(X),1) results B,LN(A)
* For case {{chart:regression-force-intercept="true"}} and C the value of {{chart:regression-intercept-value}} the calculation can be:
For regression type
{{exponential}}, model y=C*EXP(B*X): LINEST(LN(Y/C),X,0) results B,0
{{linear}}, model y=Ax+C: LINEST(Y-C,X,0) results A,0
{{polynomial}}, model y = C + A_1 x + A_2 x^2 + ... + A_n x^n: LINEST(Y-C,X,X^2,...,X^n,0) results A_n,...,A_1,0
was (Author: regina.henschel):
(2) My suggestion is to drop {{chart:regression-min-degree}} totally. I know no application that offer it. When someone implements it, we can think about adapting the descriptions.
(1)(3) Such description is already missing in the current specification. Of cause we can improve it now, while we work on that section anyway.
We can add the following part to section 20.43. Please review, whether it is correct in content. Improving wording and using formula editor can be done afterwards.
Calculating the model parameter is done by the same algorithm as used for LINEST function.
Let X denote the array of the abscissa of the data points of the series and Y the array of the associated ordinates.
* For case {{chart:regression-force-intercept="false"}} the calculation can be:
For regression type:
{{exponential}}, model y=A*EXP(B*x): LINEST(LN(Y),X,1) results B,LN(A)
{{linear}}, model y=Ax+B: LINEST(Y,X,1) results A,B
{{logarithmic}}, model y=A*LN(x)+B: LINEST(Y,LN(X),1) results A,B
{{polynomial}}, model y = A_0 + A_1 x + A_2 x^2 + ... + A_n x^n : LINEST(Y,X,X^2,...,X^n,1) results A_n,...A_1,A_0
{{power}}, model y = A*x^B : LINEST(LN(Y),LN(X),1) results B,LN(A)
* For case {{chart:regression-force-intercept="true"}} and C the value of {{chart:regression-intercept-value}} the calculation can be:
For regression type
{{exponential}}, model y=C*EXP(B*X): LINEST(LN(Y/C),X,0) results B,0
{{linear}}, model y=Ax+C: LINEST(Y-C,X,0) results A,0
{{polynomial}}, model y = C + A_1 x + A_2 x^2 + ... + A_n x^n: LINEST(Y-C,X,X^2,...,X^n,0) results A_n,...,A_1,0
> Add polynomial regression type, force-intercept and regression-name
> -------------------------------------------------------------------
>
> Key: OFFICE-3958
> URL: https://issues.oasis-open.org/browse/OFFICE-3958
> Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
> Issue Type: Improvement
> Components: Chart
> Affects Versions: ODF 1.2
> Reporter: Regina Henschel
> Priority: Major
> Fix For: ODF 1.3
>
>
> This is a spin-off from OFFICE-1148. It contains the more complete parts, so that we can at least include these in ODF 1.3:
> * Value {{polynomial}} for {{chart:regression-type}} attribute
> * New attribute {{chart:regression-max-degree}}
> * New attribute {{chart:regression-force-intercept}}
> * New attribute {{chart:regression-intercept-value}}
> * New attribute {{chart:regression-name}}
> I have not included {{chart:regression-min-degree}} attribute from the original proposal, because such attribute is no where implemented.
> I'm unsure about some wording, see email.
> The green texts are comments.
--
This message was sent by Atlassian JIRA
(v7.7.2#77003)
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]