XLfit is a

Microsoft Excel Microsoft Excel is a spreadsheet editor developed by Microsoft for Microsoft Windows, Windows, macOS, Android (operating system), Android, iOS and iPadOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a ...

add-in that can perform regression analysis,

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 is ...

, and

statistical analysis Statistical inference is the process of using data analysis to infer properties of an underlying probability distribution.Upton, G., Cook, I. (2008) ''Oxford Dictionary of Statistics'', OUP. . Inferential statistical analysis infers properties of ...

. It is approved by the UK National Physical Laboratory and the

US National Institute of Standards and Technology The National Institute of Standards and Technology (NIST) is an agency of the United States Department of Commerce whose mission is to promote American innovation and industrial competitiveness. NIST's activities are organized into physical sci ...

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 * Ex ...

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 ''a_n'' represents the coefficient of the ''n''th term and ''c'' is a co ...

, Sigmoidal,

Hyperbolic Hyperbolic may refer to: * of or pertaining to a hyperbola, a type of smooth curve lying in a plane in mathematics ** Hyperbolic geometry, a non-Euclidean geometry ** Hyperbolic functions, analogues of ordinary trigonometric functions, defined u ...

, Yield Density,

Linear In mathematics, the term ''linear'' is used in two distinct senses for two different properties: * linearity of a '' function'' (or '' mapping''); * linearity of a '' polynomial''. An example of a linear function is the function defined by f(x) ...

Polynomial In mathematics, a polynomial is a Expression (mathematics), mathematical expression consisting of indeterminate (variable), indeterminates (also called variable (mathematics), variables) and coefficients, that involves only the operations of addit ...

, Dose Response,

Pharmacology Pharmacology is the science of drugs and medications, including a substance's origin, composition, pharmacokinetics, pharmacodynamics, therapeutic use, and toxicology. More specifically, it is the study of the interactions that occur betwee ...

, Equilibrium and

Inhibition Inhibitor or inhibition may refer to: 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 neurotransm ...

. * Levenberg-Marquardt fitting algorithm. A range of

statistical Statistics (from German language, German: ', "description of a State (polity), state, a country") is the discipline that concerns the collection, organization, analysis, interpretation, and presentation of data. In applying statistics to a s ...

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 is the continuous analog of a sum, which is used to calculate areas, volumes, and their generalizations. Integration, the process of computing an integral, is one of the two fundamental operations of calculus,Inte ...

/ ROC * Confidence intervals * Error values relating to parameter values or any point on the curve. Available statistical models include Spearman's rank correlations, Student's ''t''-test, Mann–Whitney ''U'' test,

least squares The method of least squares is a mathematical optimization technique that aims to determine the best fit function by minimizing the sum of the squares of the differences between the observed values and the predicted values of the model. The me ...

, and

ANOVA Analysis of variance (ANOVA) is a family of statistical methods used to compare the means of two or more groups by analyzing variance. Specifically, ANOVA compares the amount of variation ''between'' the group means to the amount of variation ''w ...

, 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 federal government of the United States, US federal government responsible for the United States ...

to analyze the battery life of the Curiosity Mars Lander.

Licenses

XLift is a

proprietary software Proprietary software is computer software, software that grants its creator, publisher, or other rightsholder or rightsholder partner a legal monopoly by modern copyright and intellectual property law to exclude the recipient from freely sharing t ...

. 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