You can buy this plugin on Repo plugin formulas statistics Demo is available on demo formula

add formulas based on jStat(javascript) :

• ARITHMETICMEAN
• CUBICMEAN
• GASTWIRTHCOHENMEAN
• GEOMETRICMEAN
• HARMONICMEAN
• MEDIAN
• MIDRANGE
• MODE
• ROOTMEANSQUARE
• WINSORISEDMEAN
• BARNARDSTEST (WALD, NUISANCE, PONTAILED, PTWOTAILED)
• BINOMIALTEST (PEXACTLY, PFEWER, PATMOST, PMORE, PATLEAST)
• CHISQUAREDTEST (PEARSONCHISQUARED, DEGREESOFFREEDOM, SIGNIFICANCE)
• FISHERSEXACTTEST
• MANNWHITNEYU (ZSCORE, PONETAILED, PTWOTAILED)
• SIGNTEST (PMORE, PATLEAST)
• STUDENTSTTESTONESAMPLE (TSTATISTIC, DEGREESOFFREEDOM, PONESIDED, PTWOSIDED)
• STUDENTSTTESTTWOSAMPLES (TSTATISTIC, DEGREESOFFREEDOM, PONESIDED, PTWOSIDED)
• ANOVA (FSCORE, FTEST)

• JSpreadsheet Pro v8 of JSpreadsheet Pro v9 and Formula-Pro
• Compatible with plugin tooltip

none

none

You can overwrite documentation of formulas, by default, this documentation is the same of documentation JStat. For write your documentation, set documentation on the var jspreadsheet.formulasDoc

1 item of jspreadsheet.formulasDoc is construct like :

jspreadsheet.formulasDoc['MYFUNCTION()'] = {
       syntax:"MYFUNCTION(value, value)",
       about:"My custom function description ",
       examples:"MYFUNCTION(2008, 7) equals 25",
       params:[
           {type:"Float", comment:"First value"},
           {type:"Float", comment:"Second value"}
        ],
       link:"https://mydocs.domain.ext/doc/123456"
};

Important on jspreadsheet.formulasDoc object, define key property formula with () to end else it considers it as a variable.

<script src="https://jsuites.net/v4/jsuites.js"></script>
<link rel="stylesheet" href="https://jsuites.net/v4/jsuites.css" type="text/css" />

<script src="https://jspreadsheet.com/v8/jspreadsheet.js"></script>
<link rel="stylesheet" href="https://jspreadsheet.com/v8/jspreadsheet.css" type="text/css" />

<script src="http://www.jspreadsheet.com/v8/plugins/formula.js"></script>
<!-- Optional -->
<script src="plugins/premiums/jss.tooltip.js"></script>
<link rel="stylesheet" href="plugins/premiums/jss.tooltip.css" type="text/css" />

<!-- init plugins statistics -->
<script>
    // Initialisation
    //Precision
    formula.adjustPrecision = true;
    // Extensions
    jspreadsheet.setExtensions({ formula, statistics });
</script>

Initialize plugin on JSpreadsheet

jspreadsheet(document.getElementById('spreadsheet'), {
	...
	plugins: [
      ...
      { name:'tooltip', plugin:jss_tooltip }, // Optional
      ...  
    ],
    ...
});

Copyright GBonnaire.fr and Code released under the commercial License. This plugin required license of Repo.gbonnaire.fr