Excel |
Collection of functions equivalent to those provided by Microsoft Excel
but backed instead by Math.NET Numerics.
We do not recommend to use them except in an intermediate phase when
porting over solutions previously implemented in Excel.
Inheritance HierarchyNamespace: Altaxo.Calc
Assembly: AltaxoCore (in AltaxoCore.dll) Version: 4.8.3572.0 (4.8.3572.0)
SyntaxC#
public static class ExcelFunctions
The ExcelFunctions type exposes the following members.
Methods| Name | Description | |
|---|---|---|
  | BetaDist | Returns the beta cumulative distribution value. |
| BetaInv | Returns the inverse beta cumulative distribution value. |
| FDist | Returns the upper-tail cumulative distribution value for the Fisher-Snedecor distribution. |
| FInv | Returns the inverse Fisher-Snedecor distribution value. |
| GammaDist | Returns the gamma distribution value for the specified parameters. |
| GammaInv | Returns the inverse gamma cumulative distribution value. |
| NormDist | Returns the normal distribution value for the specified parameters. |
| NormInv | Returns the inverse normal cumulative distribution value for the specified parameters. |
| NormSDist | Returns the standard normal cumulative distribution value. |
| NormSInv | Returns the inverse of the standard normal cumulative distribution. |
| Percentile | Returns the percentile of an array using Excel's quantile definition. |
| PercentRank | Returns the rank of a value within an array as a percentile. |
| Quartile | Returns the specified quartile of an array using Excel's quantile definition. |
| TDist | Returns the Student's t-distribution tail probability. |
| TInv | Returns the inverse Student's t-distribution value. |
See Also