XLfit is a
Microsoft Excel
Microsoft Excel is a spreadsheet developed by Microsoft for Microsoft Windows, Windows, macOS, Android (operating system), Android and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro (comp ...
add-in that can perform
regression analysis,
curve fitting, 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/
Log,
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, 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 exampl ...
,
Dose Response
Dose or Dosage may refer to:
Music
* ''Dose'' (Gov't Mule album), 1998
* ''Dose'' (Latin Playboys album)
* ''Dosage'' (album), by the band Collective Soul
* "Dose" (song), a 2018 song by Ciara
* "Dose", song by Filter from the album '' Short ...
,
Pharmacology, Equilibrium and
Inhibition.
*
Levenberg-Marquardt fitting algorithm.
A range of
statistical
Statistics (from German: '' Statistik'', "description of a state, a country") is the discipline that concerns the collection, organization, analysis, interpretation, and presentation of data. In applying statistics to a scientific, industr ...
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 ...
. Example statistics include:
*
''F''-test and
''t''-test
*
Area under the curve /
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, and
ANOVA, 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 agency of the US federal government responsible for the civil space program, aeronautics research, and space research.
NASA was established in 1958, succeedin ...
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
See also
*
List of numerical analysis software
*
List of statistical packages
Statistical software are specialized computer programs for analysis in statistics and econometrics.
Open-source
* ADaMSoft – a generalized statistical software with data mining algorithms and methods for data management
* ADMB – a softwar ...
*
Comparison of statistical packages
The following tables compare general and technical information for a number of statistical analysis packages.
General information
Operating system support
ANOVA
Support for various ANOVA methods
Regression
Support for various regression m ...
References
External links
XLfit Website
{{DEFAULTSORT:Xlfit (Software)
Plotting software
Data analysis software
Windows-only proprietary software