XLfit

Last updated
XLfit
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

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:

Contents

A range of statistical calculations can also be applied to the data from within the spreadsheet. Example statistics include:[ further explanation needed ]

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

XLfit 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

XLift is a proprietary software. It offers the following licensing options.

Version history

See also

Related Research Articles

Multivariate statistics is a subdivision of statistics encompassing the simultaneous observation and analysis of more than one outcome variable, i.e., multivariate random variables. Multivariate statistics concerns understanding the different aims and background of each of the different forms of multivariate analysis, and how they relate to each other. The practical application of multivariate statistics to a particular problem may involve several types of univariate and multivariate analyses in order to understand the relationships between variables and their relevance to the problem being studied.

<span class="mw-page-title-main">Time series</span> Sequence of data points over time

In mathematics, a time series is a series of data points indexed in time order. Most commonly, a time series is a sequence taken at successive equally spaced points in time. Thus it is a sequence of discrete-time data. Examples of time series are heights of ocean tides, counts of sunspots, and the daily closing value of the Dow Jones Industrial Average.

Linear trend estimation is a statistical technique used to analyze data patterns. When a series of measurements of a process are treated as a sequence or time series, trend estimation can be used to make and justify statements about tendencies in the data by relating the measurements to the times at which they occurred. This model can then be used to describe the behavior of the observed data.

<span class="mw-page-title-main">Curve fitting</span> Process of constructing a curve that has the best fit to a series of data points

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 required, or smoothing, in which a "smooth" function is constructed that approximately fits the data. A related topic is regression analysis, which focuses more on questions of statistical inference such as how much uncertainty is present in a curve that is fitted to data observed with random errors. Fitted curves can be used as an aid for data visualization, to infer values of a function where no data are available, and to summarize the relationships among two or more variables. Extrapolation refers to the use of a fitted curve beyond the range of the observed data, and is subject to a degree of uncertainty since it may reflect the method used to construct the curve as much as it reflects the observed data.

<span class="mw-page-title-main">Regression analysis</span> Set of statistical processes for estimating the relationships among variables

In statistical modeling, regression analysis is a set of statistical processes for estimating the relationships between a dependent variable and one or more independent variables. The most common form of regression analysis is linear regression, in which one finds the line that most closely fits the data according to a specific mathematical criterion. For example, the method of ordinary least squares computes the unique line that minimizes the sum of squared differences between the true data and that line. For specific mathematical reasons, this allows the researcher to estimate the conditional expectation of the dependent variable when the independent variables take on a given set of values. Less common forms of regression use slightly different procedures to estimate alternative location parameters or estimate the conditional expectation across a broader collection of non-linear models.

In time series analysis, the Box–Jenkins method, named after the statisticians George Box and Gwilym Jenkins, applies autoregressive moving average (ARMA) or autoregressive integrated moving average (ARIMA) models to find the best fit of a time-series model to past values of a time series.

<span class="mw-page-title-main">MedCalc</span>

MedCalc is a statistical software package designed for the biomedical sciences. It has an integrated spreadsheet for data input and can import files in several formats.

The following tables compare general and technical information for a number of statistical analysis packages.

<span class="mw-page-title-main">FlexPro</span>

FlexPro is a proprietary software package for analysis and presentation of scientific and technical data, produced by Weisang GmbH. It runs on Microsoft Windows and is available in English, German, Japanese, Chinese and French. FlexPro has its roots in the test and measurement domain and supports different binary file formats of data acquisition instruments and software. In particular, FlexPro can analyze large amounts of data with high sampling rates.

Verification and validation are independent procedures that are used together for checking that a product, service, or system meets requirements and specifications and that it fulfills its intended purpose. These are critical components of a quality management system such as ISO 9000. The words "verification" and "validation" are sometimes preceded with "independent", indicating that the verification and validation is to be performed by a disinterested third party. "Independent verification and validation" can be abbreviated as "IV&V".

Data Desk is a software program for visual data analysis, visual data exploration, and statistics. It carries out Exploratory Data Analysis (EDA) and standard statistical analyses by means of dynamically linked graphic data displays that update any change simultaneously.

Chronux is an open-source software package developed for the loading, visualization and analysis of a variety of modalities / formats of neurobiological time series data. Usage of this tool enables neuroscientists to perform a variety of analysis on multichannel electrophysiological data such as LFP, EEG, MEG, Neuronal spike times and also on spatiotemporal data such as FMRI and dynamic optical imaging data. The software consists of a set of MATLAB routines interfaced with C libraries that can be used to perform the tasks that constitute a typical study of neurobiological data. These include local regression and smoothing, spike sorting and spectral analysis - including multitaper spectral analysis, a powerful nonparametric method to estimate power spectrum. The package also includes some GUIs for time series visualization and analysis. Chronux is GNU GPL v2 licensed.

Wind resource assessment is the process by which wind power developers estimate the future energy production of a wind farm. Accurate wind resource assessments are crucial to the successful development of wind farms.

Psychometric software is software that is used for psychometric analysis of data from tests, questionnaires, or inventories reflecting latent psychoeducational variables. While some psychometric analyses can be performed with standard statistical software like SPSS, most analyses require specialized tools.

In statistics, model validation is the task of evaluating whether a chosen statistical model is appropriate or not. Oftentimes in statistical inference, inferences from models that appear to fit their data may be flukes, resulting in a misunderstanding by researchers of the actual relevance of their model. To combat this, model validation is used to test whether a statistical model can hold up to permutations in the data. This topic is not to be confused with the closely related task of model selection, the process of discriminating between multiple candidate models: model validation does not concern so much the conceptual design of models as it tests only the consistency between a chosen model and its stated outputs.

QBlade is a public source, cross-platform simulation software for wind turbine blade design and aerodynamic simulation. It comes with a user-friendly graphical user interface (GUI) based on Qt.

<span class="mw-page-title-main">LIMDEP</span>

LIMDEP is an econometric and statistical software package with a variety of estimation tools. In addition to the core econometric tools for analysis of cross sections and time series, LIMDEP supports methods for panel data analysis, frontier and efficiency estimation and discrete choice modeling. The package also provides a programming language to allow the user to specify, estimate and analyze models that are not contained in the built in menus of model forms.

<span class="mw-page-title-main">MLAB</span>

MLAB is a multi-paradigm numerical computing environment and fourth-generation programming language was originally developed at the National Institutes of Health.

References

  1. "XLfit". IDBS. Retrieved 2023-03-20.
  2. "XLfit". Capterra. Retrieved 2023-03-20.
  3. "Home".
  4. "NASA uses XLfit". PC Advisor.
  5. http://www.drugdevelopment-technology.com/downloads/whitepapers/bioinformatics/file225/ Drug Development and Technology - XLfit and John Deere
  6. Scientific Computing & Instrumentation, Monday, March 1, 2004