[
https://issues.apache.org/jira/browse/JENA-1693?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16837859#comment-16837859
]
Marco Neumann commented on JENA-1693:
-------------------------------------
very good [~ajs6f], I have finished and implemented the changes now with the
Apache Commons Math lib on the lotico site for testing. This satisfies my use
case and I will continue to test it here:
www.lotico.com/query/#SELECT%20median%28%3Fx%29%20WHERE%7B%0A%3Fx%20a%20<http%3A%2F%2Fwww.lotico.com%2Fontology%2FMember>%20%20%0A%7D
What would be the next steps for the PR? I still would like to clean up the
code a little and add a test. And I also will change the result set value from
http://www.w3.org/2001/XMLSchema#double to
http://www.w3.org/2001/XMLSchema#decimal.
> Add Aggregate Function MEDIAN To SPARQL ARQ Syntax
> --------------------------------------------------
>
> Key: JENA-1693
> URL: https://issues.apache.org/jira/browse/JENA-1693
> Project: Apache Jena
> Issue Type: New Feature
> Environment: general
>
> Reporter: Marco Neumann
> Priority: Minor
> Labels: features
> Original Estimate: 24h
> Remaining Estimate: 24h
>
> As briefly mentioned to Andy Seaborne I'd like to see the aggregate function
> MEDIAN in the ARQ SPARQL syntax.
> "Median is the value that separates lower half from the higher half when the
> values are ordered in ascending or descending order. It is the middle value
> in a given dataset. Medians are helpful in understanding the distribution of
> data. This can be done by comparing mean and median values. By observing the
> difference between these values we can understand whether the data is left
> skewed or right skewed. The formula for median is: Median = ((n + 1)/2) th
> number in the series where the numbers are ordered. Here, n denotes the
> number of values for the given variable."
> DIVYA SPANDANA MARNEN, SPARQL-R: EXTENDED SPARQL FOR STATISTICAL COMPUTATIONS.
>
> example
>
> SELECT agg:median(?age) AS ?median
> WHERE
> { ?x ex:age ?age }
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
