XLfit is a

Microsoft Excel Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for App ...

add-in that can perform

regression analysis In statistical modeling, regression analysis is a set of statistical processes for estimating the relationships between a dependent variable (often called the 'outcome' or 'response' variable, or a 'label' in machine learning parlance) and one ...

curve fitting Curve fitting is the process of constructing a curve, or mathematical function, that has the best fit to a series of data points, possibly subject to constraints. Curve fitting can involve either interpolation, where an exact fit to the data i ...

, and statistical analysis. It is approved by the UK National Physical Laboratory and the US National Institute of Standards and Technology XLfit can generate 2D and 3D graphs and analyze data sets. XLfit can also analyse the statistical data. It includes over seventy linear and non-linear curve fitting models. Predefined categories include: *

Exponential Exponential may refer to any of several mathematical topics related to exponentiation, including: *Exponential function, also: **Matrix exponential, the matrix analogue to the above *Exponential decay, decrease at a rate proportional to value *Expo ...

Log Log most often refers to: * Trunk (botany), the stem and main wooden axis of a tree, called logs when cut ** Logging, cutting down trees for logs ** Firewood, logs used for fuel ** Lumber or timber, converted from wood logs * Logarithm, in mathe ...

Power Series In mathematics, a power series (in one variable) is an infinite series of the form \sum_^\infty a_n \left(x - c\right)^n = a_0 + a_1 (x - c) + a_2 (x - c)^2 + \dots where ''an'' represents the coefficient of the ''n''th term and ''c'' is a con ...

, Sigmoidal,

Hyperbolic Hyperbolic is an adjective describing something that resembles or pertains to a hyperbola (a curve), to hyperbole (an overstatement or exaggeration), or to hyperbolic geometry. The following phenomena are described as ''hyperbolic'' because they ...

, Yield Density,

Linear Linearity is the property of a mathematical relationship ('' function'') that can be graphically represented as a straight line. Linearity is closely related to '' proportionality''. Examples in physics include rectilinear motion, the linear ...

Polynomial In mathematics, a polynomial is an expression consisting of indeterminates (also called variables) and coefficients, that involves only the operations of addition, subtraction, multiplication, and positive-integer powers of variables. An example ...

, Dose Response, Pharmacology, Equilibrium and

Inhibition Inhibitor or inhibition may refer to: In biology * Enzyme inhibitor, a substance that binds to an enzyme and decreases the enzyme's activity * Reuptake inhibitor, a substance that increases neurotransmission by blocking the reuptake of a neurotra ...

. * Levenberg-Marquardt fitting algorithm. A range of statistical calculations can also be applied to the data from within the

spreadsheet A spreadsheet is a computer application for computation, organization, analysis and storage of data in tabular form. Spreadsheets were developed as computerized analogs of paper accounting worksheets. The program operates on data entered in c ...

. Example statistics include: * ''F''-test and ''t''-test *

Area under the curve In mathematics, an integral assigns numbers to functions in a way that describes displacement, area, volume, and other concepts that arise by combining infinitesimal data. The process of finding integrals is called integration. Along with ...

/ ROC * Confidence intervals * Error values relating to parameter values or any point on the curve. Available statistical models include

Spearman's rank correlation In statistics, Spearman's rank correlation coefficient or Spearman's ''ρ'', named after Charles Spearman and often denoted by the Greek letter \rho (rho) or as r_s, is a nonparametric measure of rank correlation ( statistical dependence betwe ...

s, Student's ''t''-test, Mann–Whitney ''U'' test, least squares, and

ANOVA Analysis of variance (ANOVA) is a collection of statistical models and their associated estimation procedures (such as the "variation" among and between groups) used to analyze the differences among means. ANOVA was developed by the statistician ...

, among others. A model editor also allows users to add their own models and statistics to the ones provided.

Usage

XLfit was validated by The UK National Physical Laboratory in 2004; the unit tests for this are provided in the model editor from version 5.4 onwards to allow each version to be easily validated. XLfit was used by

NASA The National Aeronautics and Space Administration (NASA ) is an independent agencies of the United States government, independent agency of the US federal government responsible for the civil List of government space agencies, space program ...

to analyze the battery life of the Curiosity Mars Lander.

Licenses

XLift is a

proprietary software Proprietary software is software that is deemed within the free and open-source software to be non-free because its creator, publisher, or other rightsholder or rightsholder partner exercises a legal monopoly afforded by modern copyright and i ...

. It offers the following licensing options. * XLfit 5 Commercial License * XLfit 5 Academic License * E-learning

Version history

* 2002.8 XLfit 2.0.11 * 2002.5 XLfit 3.0.2 * 2003.11 XLfit 4.0.1 Scientific Computing & Instrumentation, Monday, March 1, 2004 * 2005.6 XLfit 4.1.1 * 2005.6 XLfit 4.2.0 * 2008.7 XLfit 4.3.2 * 2009.4 XLfit 5.1.0 * 2009.7 XLfit 5.1.1 * 2009.11 XLfit 5.2.0 * 2010.11 XLfit 5.2.2 * 2011.11 XLfit 5.3.0 * 2012.1 XLfit 5.3.1 * 2014.5 XLfit 5.4.0 * 2015.5 XLfit 5.5.0

References

External links

XLfit Website
{{DEFAULTSORT:Xlfit (Software) Plotting software Data analysis software Windows-only proprietary software

Usage

Licenses

Version history

See also

References

External links