XLfit is a Microsoft Excel 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[1] 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.[2] Predefined categories include:
- Exponential/Log, Power Series, Sigmoidal, Hyperbolic, Yield Density, Linear, Polynomial, Dose Response, Pharmacology, Equilibrium and Inhibition.
- Levenberg-Marquardt fitting algorithm.
| Developer(s) | IDBS |
|---|---|
| Stable release | 5.5.0.5
/ 2017 |
| Operating system | Windows |
| Type | Curve fitting, Data Analysis |
| License | Proprietary software |
| Website | XLfit Product Page |
A range of statistical calculations can also be applied to the data from within the spreadsheet. Example statistics include:[further explanation needed]
- 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.[citation needed] A model editor also allows users to add their own models and statistics to the ones provided.
Usage
editXLfit was validated by The UK National Physical Laboratory[3] 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 to analyze the battery life of the Curiosity Mars Lander.[4]
Licenses
editXLift is a proprietary software. It offers the following licensing options.
- XLfit 5 Commercial License
- XLfit 5 Academic License
- E-learning
Version history
editSee also
editReferences
edit- ^ "XLfit". IDBS. Retrieved 2023-03-20.
- ^ "XLfit". Capterra. Retrieved 2023-03-20.
- ^ "Home".
- ^ "NASA uses XLfit". PC Advisor.
- ^ http://www.drugdevelopment-technology.com/downloads/whitepapers/bioinformatics/file225/ Drug Development and Technology - XLfit and John Deere
- ^ Scientific Computing & Instrumentation, Monday, March 1, 2004
External links
edit