Back

ⓘ XLfit is a Microsoft Excel-based plug-in which performs Regression, curve fitting and statistical analysis. XLfit generates 2D and 3D graphs and analyses data s ..




                                     

ⓘ XLfit

XLfit is a Microsoft Excel-based plug-in which performs Regression, curve fitting and statistical analysis. XLfit generates 2D and 3D graphs and analyses data sets produced by any type of research. XLfit’s curve fitting engine allows linear and non-linear curve fits, smoothing, statistics, weighting and error bars.

XLfit includes over seventy linear and non-linear curve fitting models. Predefined categories include:

  • Levenberg-Marquardt fitting algorithm
  • Exponential/Log, Power Series, Sigmoidal, Hyperbolic, Yield Density, Linear, Polynomial, Dose Response, Pharmacology, Equilibrium, Inhibition

A range of statistical calculations can also be applied to the data from within the spreadsheet.

Example statistics include:

  • F test and T test
  • Error values relating to parameter values or any point on the curve.
  • Area under the curve
  • Confidence intervals

Available statistics models include Spearmans Rank Correlations, Students T-Test, Mann Whitney U-Test, least squares, ANOVA, among others. It is possible to add your own models and statistics to the provided ones using a model editor.

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 to analyse the battery life of the Curiosity Mars Lander.

                                     

1. Version History

  • 2011.11 XLfit 5.3.0
  • 2005.6 XLfit 4.2.0
  • 2014.5 XLfit 5.4.0
  • 2009.7 XLfit 5.1.1
  • 2005.6 XLfit 4.1.1
  • 2003.11 XLfit 4.0.1
  • 2008.7 XLfit 4.3.2
  • 2015.5 XLfit 5.5.0
  • 2012.1 XLfit 5.3.1
  • 2002.8 XLfit 2.0.11
  • 2009.4 XLfit 5.1.0
  • 2009.11 XLfit 5.2.0
  • 2010.11 XLfit 5.2.2
  • 2002.5 XLfit 3.0.2
                                     
  • NCSS SHAZAM SigmaStat Statistica StatsDirect StatXact SYSTAT The Unscrambler UNISTAT Excel add - ons Analyse - it SigmaXL UNISTAT for Excel XLfit RExcel
  • NCSS SHAZAM SigmaStat Statistica StatsDirect StatXact SYSTAT The Unscrambler UNISTAT Excel add - ons Analyse - it SigmaXL UNISTAT for Excel XLfit RExcel
  • NCSS SHAZAM SigmaStat Statistica StatsDirect StatXact SYSTAT The Unscrambler UNISTAT Excel add - ons Analyse - it SigmaXL UNISTAT for Excel XLfit RExcel
  • NCSS SHAZAM SigmaStat Statistica StatsDirect StatXact SYSTAT The Unscrambler UNISTAT Excel add - ons Analyse - it SigmaXL UNISTAT for Excel XLfit RExcel
  • NCSS SHAZAM SigmaStat Statistica StatsDirect StatXact SYSTAT The Unscrambler UNISTAT Excel add - ons Analyse - it SigmaXL UNISTAT for Excel XLfit RExcel
  • NCSS SHAZAM SigmaStat Statistica StatsDirect StatXact SYSTAT The Unscrambler UNISTAT Excel add - ons Analyse - it SigmaXL UNISTAT for Excel XLfit RExcel
  • NCSS SHAZAM SigmaStat Statistica StatsDirect StatXact SYSTAT The Unscrambler UNISTAT Excel add - ons Analyse - it SigmaXL UNISTAT for Excel XLfit RExcel
  • NCSS SHAZAM SigmaStat Statistica StatsDirect StatXact SYSTAT The Unscrambler UNISTAT Excel add - ons Analyse - it SigmaXL UNISTAT for Excel XLfit RExcel
  • NCSS SHAZAM SigmaStat Statistica StatsDirect StatXact SYSTAT The Unscrambler UNISTAT Excel add - ons Analyse - it SigmaXL UNISTAT for Excel XLfit RExcel
  • NCSS SHAZAM SigmaStat Statistica StatsDirect StatXact SYSTAT The Unscrambler UNISTAT Excel add - ons Analyse - it SigmaXL UNISTAT for Excel XLfit RExcel

Users also searched:

...
...
...