csharpfftfsharpintegrationinterpolationlinear-algebramathdifferentiationmatrixnumericsrandomregressionstatisticsmathnet
You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
410 lines
15 KiB
410 lines
15 KiB
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Frameset//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-frameset.dtd">
|
|
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
|
|
<head>
|
|
<title>ExcelFunctions - Math.NET Numerics Documentation</title>
|
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
|
|
<link type="text/css" rel="stylesheet" href="../main.css"/>
|
|
<script type="text/javascript" src="../js/jquery-1.3.2.min.js"></script>
|
|
<script type="text/javascript" src="../js/jquery.scrollTo-min.js"></script>
|
|
<script type="text/javascript" src="../js/navigation.js"></script>
|
|
<script type="text/javascript" src="../js/example.js"></script>
|
|
</head>
|
|
<body><div id="namespaces">
|
|
<h2 class="fixed">Namespaces</h2>
|
|
<div class="scroll">
|
|
<ul>
|
|
<li>
|
|
<a href="../MathNet.Numerics/index.htm" class="current">MathNet.Numerics</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.Differentiation/index.htm">MathNet.Numerics.Differentiation</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.Distributions/index.htm">MathNet.Numerics.Distributions</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.Financial/index.htm">MathNet.Numerics.Financial</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.IntegralTransforms/index.htm">MathNet.Numerics.IntegralTransforms</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.Integration/index.htm">MathNet.Numerics.Integration</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.Interpolation/index.htm">MathNet.Numerics.Interpolation</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.LinearAlgebra/index.htm">MathNet.Numerics.LinearAlgebra</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.LinearAlgebra.Complex/index.htm">MathNet.Numerics.LinearAlgebra.Complex</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.LinearAlgebra.Complex.Solvers/index.htm">MathNet.Numerics.LinearAlgebra.Complex.Solvers</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.LinearAlgebra.Complex32/index.htm">MathNet.Numerics.LinearAlgebra.Complex32</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.LinearAlgebra.Complex32.Solvers/index.htm">MathNet.Numerics.LinearAlgebra.Complex32.Solvers</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.LinearAlgebra.Double/index.htm">MathNet.Numerics.LinearAlgebra.Double</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.LinearAlgebra.Double.Solvers/index.htm">MathNet.Numerics.LinearAlgebra.Double.Solvers</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.LinearAlgebra.Factorization/index.htm">MathNet.Numerics.LinearAlgebra.Factorization</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.LinearAlgebra.Single/index.htm">MathNet.Numerics.LinearAlgebra.Single</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.LinearAlgebra.Single.Solvers/index.htm">MathNet.Numerics.LinearAlgebra.Single.Solvers</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.LinearAlgebra.Solvers/index.htm">MathNet.Numerics.LinearAlgebra.Solvers</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.LinearAlgebra.Storage/index.htm">MathNet.Numerics.LinearAlgebra.Storage</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.LinearRegression/index.htm">MathNet.Numerics.LinearRegression</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.OdeSolvers/index.htm">MathNet.Numerics.OdeSolvers</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.Optimization/index.htm">MathNet.Numerics.Optimization</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.Optimization.LineSearch/index.htm">MathNet.Numerics.Optimization.LineSearch</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.Optimization.ObjectiveFunctions/index.htm">MathNet.Numerics.Optimization.ObjectiveFunctions</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.Optimization.TrustRegion/index.htm">MathNet.Numerics.Optimization.TrustRegion</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.Providers/index.htm">MathNet.Numerics.Providers</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.Providers.FourierTransform/index.htm">MathNet.Numerics.Providers.FourierTransform</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.Providers.LinearAlgebra/index.htm">MathNet.Numerics.Providers.LinearAlgebra</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.Providers.SparseSolver/index.htm">MathNet.Numerics.Providers.SparseSolver</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.Random/index.htm">MathNet.Numerics.Random</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.RootFinding/index.htm">MathNet.Numerics.RootFinding</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.Statistics/index.htm">MathNet.Numerics.Statistics</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics.Statistics.Mcmc/index.htm">MathNet.Numerics.Statistics.Mcmc</a>
|
|
</li>
|
|
</ul>
|
|
</div>
|
|
</div><div id="types">
|
|
<h2 class="fixed">Types in MathNet.Numerics</h2>
|
|
<div class="scroll">
|
|
<ul>
|
|
<li>
|
|
<a href="../MathNet.Numerics/AppSwitches.htm">AppSwitches</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/Combinatorics.htm">Combinatorics</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/Complex32.htm">Complex32</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/ComplexExtensions.htm">ComplexExtensions</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/Constants.htm">Constants</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/ContourIntegrate.htm">ContourIntegrate</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/Control.htm">Control</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/Differentiate.htm">Differentiate</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/DifferIntegrate.htm">DifferIntegrate</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/Distance.htm">Distance</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/Euclid.htm">Euclid</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/ExcelFunctions.htm" class="current">ExcelFunctions</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/FindMinimum.htm">FindMinimum</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/FindRoots.htm">FindRoots</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/Fit.htm">Fit</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/Generate.htm">Generate</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/GoodnessOfFit.htm">GoodnessOfFit</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/Integrate.htm">Integrate</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/Interpolate.htm">Interpolate</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/InvalidParameterException.htm">InvalidParameterException</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/IPrecisionSupport`1.htm">IPrecisionSupport<T></a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/MemoryAllocationException.htm">MemoryAllocationException</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/NativeInterfaceException.htm">NativeInterfaceException</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/NonConvergenceException.htm">NonConvergenceException</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/NumericalBreakdownException.htm">NumericalBreakdownException</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/Permutation.htm">Permutation</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/Polynomial.htm">Polynomial</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/Precision.htm">Precision</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/Series.htm">Series</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/SingularUMatrixException.htm">SingularUMatrixException</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/Sorting.htm">Sorting</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/SpecialFunctions.htm">SpecialFunctions</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/TestFunctions.htm">TestFunctions</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/Trig.htm">Trig</a>
|
|
</li>
|
|
<li>
|
|
<a href="../MathNet.Numerics/Window.htm">Window</a>
|
|
</li>
|
|
</ul>
|
|
</div>
|
|
</div>
|
|
<div class="header">
|
|
<p class="class"><strong>Type</strong> ExcelFunctions</p>
|
|
<p><strong>Namespace</strong> MathNet.Numerics</p>
|
|
</div>
|
|
<div class="sub-header">
|
|
<div id="summary">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.
|
|
</div>
|
|
|
|
|
|
<h3 class="section">Static Functions</h3>
|
|
<ul>
|
|
<li><a href="../MathNet.Numerics/ExcelFunctions.htm#BetaDist">BetaDist</a></li>
|
|
<li><a href="../MathNet.Numerics/ExcelFunctions.htm#BetaInv">BetaInv</a></li>
|
|
<li><a href="../MathNet.Numerics/ExcelFunctions.htm#FDist">FDist</a></li>
|
|
<li><a href="../MathNet.Numerics/ExcelFunctions.htm#FInv">FInv</a></li>
|
|
<li><a href="../MathNet.Numerics/ExcelFunctions.htm#GammaDist">GammaDist</a></li>
|
|
<li><a href="../MathNet.Numerics/ExcelFunctions.htm#GammaInv">GammaInv</a></li>
|
|
<li><a href="../MathNet.Numerics/ExcelFunctions.htm#NormDist">NormDist</a></li>
|
|
<li><a href="../MathNet.Numerics/ExcelFunctions.htm#NormInv">NormInv</a></li>
|
|
<li><a href="../MathNet.Numerics/ExcelFunctions.htm#NormSDist">NormSDist</a></li>
|
|
<li><a href="../MathNet.Numerics/ExcelFunctions.htm#NormSInv">NormSInv</a></li>
|
|
<li><a href="../MathNet.Numerics/ExcelFunctions.htm#Percentile">Percentile</a></li>
|
|
<li><a href="../MathNet.Numerics/ExcelFunctions.htm#PercentRank">PercentRank</a></li>
|
|
<li><a href="../MathNet.Numerics/ExcelFunctions.htm#Quartile">Quartile</a></li>
|
|
<li><a href="../MathNet.Numerics/ExcelFunctions.htm#TDist">TDist</a></li>
|
|
<li><a href="../MathNet.Numerics/ExcelFunctions.htm#TInv">TInv</a></li>
|
|
</ul>
|
|
|
|
|
|
|
|
</div>
|
|
|
|
|
|
|
|
<h3 class="section">Public Static Functions</h3>
|
|
|
|
<div id="BetaDist" class="method">
|
|
<h4><span title="System.double">double</span> <strong>BetaDist</strong>(<span title="System.double">double</span> x, <span title="System.double">double</span> alpha, <span title="System.double">double</span> beta)</h4>
|
|
<div class="content">
|
|
|
|
|
|
|
|
|
|
</div>
|
|
</div>
|
|
<div id="BetaInv" class="method">
|
|
<h4><span title="System.double">double</span> <strong>BetaInv</strong>(<span title="System.double">double</span> probability, <span title="System.double">double</span> alpha, <span title="System.double">double</span> beta)</h4>
|
|
<div class="content">
|
|
|
|
|
|
|
|
|
|
</div>
|
|
</div>
|
|
<div id="FDist" class="method">
|
|
<h4><span title="System.double">double</span> <strong>FDist</strong>(<span title="System.double">double</span> x, <span title="System.int">int</span> degreesFreedom1, <span title="System.int">int</span> degreesFreedom2)</h4>
|
|
<div class="content">
|
|
|
|
|
|
|
|
|
|
</div>
|
|
</div>
|
|
<div id="FInv" class="method">
|
|
<h4><span title="System.double">double</span> <strong>FInv</strong>(<span title="System.double">double</span> probability, <span title="System.int">int</span> degreesFreedom1, <span title="System.int">int</span> degreesFreedom2)</h4>
|
|
<div class="content">
|
|
|
|
|
|
|
|
|
|
</div>
|
|
</div>
|
|
<div id="GammaDist" class="method">
|
|
<h4><span title="System.double">double</span> <strong>GammaDist</strong>(<span title="System.double">double</span> x, <span title="System.double">double</span> alpha, <span title="System.double">double</span> beta, <span title="System.bool">bool</span> cumulative)</h4>
|
|
<div class="content">
|
|
|
|
|
|
|
|
|
|
</div>
|
|
</div>
|
|
<div id="GammaInv" class="method">
|
|
<h4><span title="System.double">double</span> <strong>GammaInv</strong>(<span title="System.double">double</span> probability, <span title="System.double">double</span> alpha, <span title="System.double">double</span> beta)</h4>
|
|
<div class="content">
|
|
|
|
|
|
|
|
|
|
</div>
|
|
</div>
|
|
<div id="NormDist" class="method">
|
|
<h4><span title="System.double">double</span> <strong>NormDist</strong>(<span title="System.double">double</span> x, <span title="System.double">double</span> mean, <span title="System.double">double</span> standardDev, <span title="System.bool">bool</span> cumulative)</h4>
|
|
<div class="content">
|
|
|
|
|
|
|
|
|
|
</div>
|
|
</div>
|
|
<div id="NormInv" class="method">
|
|
<h4><span title="System.double">double</span> <strong>NormInv</strong>(<span title="System.double">double</span> probability, <span title="System.double">double</span> mean, <span title="System.double">double</span> standardDev)</h4>
|
|
<div class="content">
|
|
|
|
|
|
|
|
|
|
</div>
|
|
</div>
|
|
<div id="NormSDist" class="method">
|
|
<h4><span title="System.double">double</span> <strong>NormSDist</strong>(<span title="System.double">double</span> z)</h4>
|
|
<div class="content">
|
|
|
|
|
|
|
|
|
|
</div>
|
|
</div>
|
|
<div id="NormSInv" class="method">
|
|
<h4><span title="System.double">double</span> <strong>NormSInv</strong>(<span title="System.double">double</span> probability)</h4>
|
|
<div class="content">
|
|
|
|
|
|
|
|
|
|
</div>
|
|
</div>
|
|
<div id="Percentile" class="method">
|
|
<h4><span title="System.double">double</span> <strong>Percentile</strong>(<span title="System.Double[]">Double[]</span> array, <span title="System.double">double</span> k)</h4>
|
|
<div class="content">
|
|
|
|
|
|
|
|
|
|
</div>
|
|
</div>
|
|
<div id="PercentRank" class="method">
|
|
<h4><span title="System.double">double</span> <strong>PercentRank</strong>(<span title="System.Double[]">Double[]</span> array, <span title="System.double">double</span> x)</h4>
|
|
<div class="content">
|
|
|
|
|
|
|
|
|
|
</div>
|
|
</div>
|
|
<div id="Quartile" class="method">
|
|
<h4><span title="System.double">double</span> <strong>Quartile</strong>(<span title="System.Double[]">Double[]</span> array, <span title="System.int">int</span> quant)</h4>
|
|
<div class="content">
|
|
|
|
|
|
|
|
|
|
</div>
|
|
</div>
|
|
<div id="TDist" class="method">
|
|
<h4><span title="System.double">double</span> <strong>TDist</strong>(<span title="System.double">double</span> x, <span title="System.int">int</span> degreesFreedom, <span title="System.int">int</span> tails)</h4>
|
|
<div class="content">
|
|
|
|
|
|
|
|
|
|
</div>
|
|
</div>
|
|
<div id="TInv" class="method">
|
|
<h4><span title="System.double">double</span> <strong>TInv</strong>(<span title="System.double">double</span> probability, <span title="System.int">int</span> degreesFreedom)</h4>
|
|
<div class="content">
|
|
|
|
|
|
|
|
|
|
</div>
|
|
</div>
|
|
|
|
|
|
<div id="footer">
|
|
<p>Based on v5.0.0.0 of MathNet.Numerics (Math.NET Numerics)</p>
|
|
<p>Generated by <a href="http://docu.jagregory.com">docu</a></p>
|
|
</div>
|
|
</body>
|
|
</html>
|