You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by fa...@apache.org on 2022/01/25 22:49:03 UTC

svn commit: r1897476 - in /poi/trunk/poi/src: main/java/org/apache/poi/ss/formula/functions/NormDist.java test/java/org/apache/poi/ss/formula/functions/TestNormDist.java

Author: fanningpj
Date: Tue Jan 25 22:49:03 2022
New Revision: 1897476

URL: http://svn.apache.org/viewvc?rev=1897476&view=rev
Log:
normdist (init work)

Modified:
    poi/trunk/poi/src/main/java/org/apache/poi/ss/formula/functions/NormDist.java
    poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestNormDist.java

Modified: poi/trunk/poi/src/main/java/org/apache/poi/ss/formula/functions/NormDist.java
URL: http://svn.apache.org/viewvc/poi/trunk/poi/src/main/java/org/apache/poi/ss/formula/functions/NormDist.java?rev=1897476&r1=1897475&r2=1897476&view=diff
==============================================================================
--- poi/trunk/poi/src/main/java/org/apache/poi/ss/formula/functions/NormDist.java (original)
+++ poi/trunk/poi/src/main/java/org/apache/poi/ss/formula/functions/NormDist.java Tue Jan 25 22:49:03 2022
@@ -36,7 +36,7 @@ public final class NormDist extends Fixe
 
     static double probability(double x, double mean, double stdev, boolean cumulative) {
         NormalDistribution normalDistribution = new NormalDistribution(mean, stdev);
-        return cumulative ? normalDistribution.cumulativeProbability(x) : normalDistribution.probability(x);
+        return cumulative ? normalDistribution.cumulativeProbability(x) : normalDistribution.density(x);
     }
 
     @Override

Modified: poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestNormDist.java
URL: http://svn.apache.org/viewvc/poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestNormDist.java?rev=1897476&r1=1897475&r2=1897476&view=diff
==============================================================================
--- poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestNormDist.java (original)
+++ poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestNormDist.java Tue Jan 25 22:49:03 2022
@@ -46,8 +46,7 @@ final class TestNormDist {
     @Test
     void testBasic() {
         confirmValue("42", "40", "1.5", true, 0.9087888);
-        //TODO needs investigation
-        //confirmValue("42", "40", "1.5", false, 0.10934);
+        confirmValue("42", "40", "1.5", false, 0.10934);
     }
 
     @Test



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