You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2013/01/10 16:34:32 UTC

[Bug 54403] New: [PATCH] Support of statistical function SLOPE

https://issues.apache.org/bugzilla/show_bug.cgi?id=54403

            Bug ID: 54403
           Summary: [PATCH] Support of statistical function SLOPE
           Product: POI
           Version: unspecified
          Hardware: Macintosh
                OS: Mac OS X 10.4
            Status: NEW
          Severity: normal
          Priority: P2
         Component: POI Overall
          Assignee: dev@poi.apache.org
          Reporter: johan.karlsteen@gmail.com
    Classification: Unclassified

Created attachment 29842
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=29842&action=edit
Implementation of SLOPE

Implementation of SLOPE

Patch containing implementation of SLOPE.

Basically SLOPE is just another result from the previously implemented
INTERCEPT so I moved the Intercept-code to LinearRegressionFunction.java and
created Slope.java.

This wasn't the prettiest way to solve but I don't feel that I'm that good at
POI yet to do it in any other way.

Test cases created for Slope and everything works when running with a larger
Excel file that uses both Slope and Intercept.
One test case got input data from:
http://support.microsoft.com/kb/828142

Haven't been able to verify the documentation since I cannot get Apache Forrest
running.

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 54403] [PATCH] Support of statistical function SLOPE

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54403

Yegor Kozlov <ye...@dinom.ru> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |FIXED

--- Comment #3 from Yegor Kozlov <ye...@dinom.ru> ---
Thanks for the patch, applied in r1435633

Regards,
Yegor

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 54403] [PATCH] Support of statistical function SLOPE

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54403

Johan <jo...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #29842|0                           |1
        is obsolete|                            |

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 54403] [PATCH] Support of statistical function SLOPE

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54403

--- Comment #1 from Nick Burch <ap...@gagravarr.org> ---
You need an old version of Apache Forrest, 0.5.1, to make the docs work. You
can download it from http://archive.apache.org/dist/forrest/pre-0.6/ 

(Hopefully someone who knows a bit more about the functions can review and
apply the patch shortly!)

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Re: [Bug 54403] New: [PATCH] Support of statistical function SLOPE

Posted by Johan Karlsteen <jo...@klarna.com>.
Sorry, forgot 1 file. Will add new attachment in a couple of minutes.

/Johan


On Thu, Jan 10, 2013 at 4:34 PM, <bu...@apache.org> wrote:

> https://issues.apache.org/bugzilla/show_bug.cgi?id=54403
>
>             Bug ID: 54403
>            Summary: [PATCH] Support of statistical function SLOPE
>            Product: POI
>            Version: unspecified
>           Hardware: Macintosh
>                 OS: Mac OS X 10.4
>             Status: NEW
>           Severity: normal
>           Priority: P2
>          Component: POI Overall
>           Assignee: dev@poi.apache.org
>           Reporter: johan.karlsteen@gmail.com
>     Classification: Unclassified
>
> Created attachment 29842
>   -->
> https://issues.apache.org/bugzilla/attachment.cgi?id=29842&action=edit
> Implementation of SLOPE
>
> Implementation of SLOPE
>
> Patch containing implementation of SLOPE.
>
> Basically SLOPE is just another result from the previously implemented
> INTERCEPT so I moved the Intercept-code to LinearRegressionFunction.java
> and
> created Slope.java.
>
> This wasn't the prettiest way to solve but I don't feel that I'm that good
> at
> POI yet to do it in any other way.
>
> Test cases created for Slope and everything works when running with a
> larger
> Excel file that uses both Slope and Intercept.
> One test case got input data from:
> http://support.microsoft.com/kb/828142
>
> Haven't been able to verify the documentation since I cannot get Apache
> Forrest
> running.
>
> --
> You are receiving this mail because:
> You are the assignee for the bug.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
> For additional commands, e-mail: dev-help@poi.apache.org
>
>


-- 
* Johan Karlsteen
Software Engineer
Engineering
+46 76 526 00 64

klarna.se  Klarna AB
Norra Stationsgatan 61
11343 Stockholm
+46 8 120 120 00
Org. nr: 556737-0431[image: Klarna] *

[Bug 54403] [PATCH] Support of statistical function SLOPE

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54403

--- Comment #2 from Johan <jo...@gmail.com> ---
Created attachment 29843
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=29843&action=edit
Implementation of SLOPE

Including FunctionEval.java which was missing in last patch.

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org