Story

Simplest validated data analyses in Excel with EasyStat

Validated Excel add-in for quick routine data analyses in the lab and in production: The software EasyStat 5.0 reduces the use of statistical methods to a few clicks and relieves you from the need to switch from Excel to another tool.

What is EasyStat?

The software EasyStat is a collection of simple, widely applicable methods for the visualization of data and elementary statistical methods for the analysis of laboratory data.

The software is validated for the pharmaceutical industry. It however also fits the needs of other sectors of the process industry (chemistry, biotechnology, food, cosmetics,...).

Thanks to its exceptional user-friendliness, EasyStat is especially well suited for routine use in the laboratory. EasyStat is an add-in for Microsoft Excel / Windows from Windows 7 / Excel 2007 onwards (incl. Excel 365 / Windows 10).

The statistical methods are now grouped into six modules, which can be individually activated by the user.

Base module

  • Histogram, stratified histogram, stem-and-leaf diagram (for inspection of data)
  • Boxplot (compact presentation of data, comparison of groups)
  • Quantile plot (for judging distribution normality)
  • Summary statistics (mean, median, quartiles, standard deviation, etc.)
  • Confidence interval (e.g. to set specifi­cations)
  • Outlier tests (for identifying extreme values)

Scatter plots

  • Normal or with stratification (i.e. separate colours per subgroup); several variables: scatter plot matrix
  • Correlation (quantification of the strength of a linear relationship)

 Linear Regression

  • Usual or with confidence lines (for quantifying the linear relationship between two variables); prediction and calibration
  • New: complete model diagnostics incl. resi­dual analysis at a single click
  • New: calculation of LOD and LOQ

Control charts for quantitative data

  • Also with calculation of Cp and Cpk values, and Cusum chart (process monitoring, disturbance identification and shift detection)
  • Process capability diagram (for assessing location and stability of a process), incl. calculation of capability indices

Control charts for attributes (count data)

  • Special control charts taking into account the specific data structure

t-test and AN(C)OVA

  • Interlaboratory experiment (for repeatability and reproducibility studies)
  • t-test (most common test for comparing two samples): lucid user guidance for choosing the appropriate test (paired, unpaired, unequal variances)
  • ANOVA (analysis of variance, for comparing several samples), for up to two factors, if desired including their interaction; still possible if some measurement values are missing
  • New: ANCOVA: special version for stability data analyses accor­ding to ICH Q1E (incl. testing the poolability of batches).

More interesting posts

cpt
Saved in your Bookmarks

We use cookies on our website. Some of them are essential, while others help us to improve this website. We are grateful if you accept them. More info