Analyse-it is a statistical analysis add-in for

Microsoft Excel Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for App ...

. Analyse-it is the successor to Astute, developed in 1992 for Excel 4 and the first statistical analysis add-in for Microsoft Excel. Analyse-it provides a range of standard parametric and

non-parametric Nonparametric statistics is the branch of statistics that is not based solely on parametrized families of probability distributions (common examples of parameters are the mean and variance). Nonparametric statistics is based on either being distri ...

procedures, including

Descriptive statistics A descriptive statistic (in the count noun sense) is a summary statistic that quantitatively describes or summarizes features from a collection of information, while descriptive statistics (in the mass noun sense) is the process of using and an ...

ANOVA Analysis of variance (ANOVA) is a collection of statistical models and their associated estimation procedures (such as the "variation" among and between groups) used to analyze the differences among means. ANOVA was developed by the statistician ...

ANCOVA Analysis of covariance (ANCOVA) is a general linear model which blends ANOVA and regression. ANCOVA evaluates whether the means of a dependent variable (DV) are equal across levels of a categorical independent variable (IV) often called a tre ...

, Mann–Whitney, Wilcoxon, chi-square, correlation, linear regression,

logistic regression In statistics, the logistic model (or logit model) is a statistical model that models the probability of an event taking place by having the log-odds for the event be a linear combination of one or more independent variables. In regression a ...

polynomial regression In statistics, polynomial regression is a form of regression analysis in which the relationship between the independent variable ''x'' and the dependent variable ''y'' is modelled as an ''n''th degree polynomial in ''x''. Polynomial regression fi ...

and advanced model fitting, principal component analysis, and

factor analysis Factor analysis is a statistical method used to describe variability among observed, correlated variables in terms of a potentially lower number of unobserved variables called factors. For example, it is possible that variations in six observed ...

. Analyse-it Method Validation edition provides the standard Analyse-it statistical analyses above, plus procedures for method evaluation, validation and demonstration, including Bland–Altman bias plots, Linear regression, Weighted Linear regression,

Deming regression In statistics, Deming regression, named after W. Edwards Deming, is an errors-in-variables model which tries to find the line of best fit for a two-dimensional dataset. It differs from the simple linear regression in that it accounts for erro ...

, Weighted Deming regression and Passing Bablok for method comparison, Precision, Linearity, Detection limits, Reference intervals and

Receiver operating characteristic A receiver operating characteristic curve, or ROC curve, is a graphical plot that illustrates the diagnostic ability of a binary classifier system as its discrimination threshold is varied. The method was originally developed for operators of m ...

analysis supporting Delong, Delong Clarke-Pearson comparisons.(see references below). Version 4.00 added support for CLSI guidelines EP5-A3, EP6-A, EP9-A3, EP10-A3, EP12-A2, EP15-A3, EP17-A2, EP21-A, EP24-A2 (formerly GP10-A), and EP28-A3C (formerly C28-A3C). Analyse-it Quality Control & Improvement edition provides the standard Analyse-it statistical analyses above, plus procedures for

statistical process control Statistical process control (SPC) or statistical quality control (SQC) is the application of statistical methods to monitor and control the quality of a production process. This helps to ensure that the process operates efficiently, producing ...

, including Shewhart, Levey-Jennings, CUSUM, and EWMA

control chart Control charts is a graph used in production control to determine whether quality and manufacturing processes are being controlled under stable conditions. (ISO 7870-1) The hourly status is arranged on the graph, and the occurrence of abnormalit ...

s, process capability analysis, and

pareto analysis Pareto analysis is a formal technique useful where many possible courses of action are competing for attention. In essence, the problem-solver estimates the benefit delivered by each action, then selects a number of the most effective actions tha ...

. Analyse-it is compatible with Microsoft Excel 2007, 2010, 2013 and 2016 (Office 365) (both 32- and 64-bit versions).

Screenshots from Analyse-it

File:AnalyseItHistogram.png, Histogram and dot plot File:AnalyseItPCA.png, PCA biplot File:AnalyseItControlCharts.png, SPC control charts File:AnalyseItCapabilityPlots.png, Capability analysis File:AnalyseItPareto.png, Pareto plots File:AnalyseItScatterMatrix.png, Scatter matrix

References

* Stephan, Carsten; Wesseling, Sebastian; Schink, Tania; and Jung, Klaus (2003); ''Comparison of Eight Computer Programs for Receiver-Operating Characteristic Analysis'', Clinical Chemistry, 49:433–43
(abstract)
http://onlinelibrary.wiley.com/doi/10.1046/j.1365-2869.2001.00262.x/pdf (pdf)] * Smith, Simon; and Trinder, John (2001); ''Detecting insomnia: comparison of four self-report measures of sleep in a young adult population'', Journal of Sleep Research 10 (3), 229–23
(abstract)
http://www.clinchem.org/content/49/3/433.full.pdf+html (pdf)] * Nadershahil, Afshin; Fahrenkrug, Scott C.; and Ellis, Lynda B. M. (2004); ''Comparison of computational methods for identifying translation initiation sites in EST data'', BMC Bioinformatics 5:1
(link)
http://www.biomedcentral.com/content/pdf/1471-2105-5-14.pdf (pdf)] * Hawkins, Tan (1999); ''Comparison of the Diagnostic Utility of CK, CK-MB (Activity and Mass), Troponin T and Troponin I in Patients with Suspected Acute Myocardial Infarction'', Singapore Medical Journal, 40(11
(text)
* Hatherill, Mark; Tibby, Shane M.; Sykes, Kim; Turner, Charles; and Murdoch, Ian A. (1999); ''Diagnostic markers of infection: comparison of procalcitonin with C reactive protein and leucocyte count'', Archives of Disease in Childhood, November; 81: 417–42
(text)
http://adc.bmj.com/content/81/5/417.full.pdf+html (pdf)]

External links

Analyse-it Home page
{{Statistical software Microsoft Office-related statistical software Windows-only software

Screenshots from Analyse-it

See also

References

External links