Analyse-it Tutorials: Worked Statistical Examples in ExcelTutorials show you how to use Analyse-it to perform common statistical analysis tasks.

Tutorials v6.20.0

• Distribution tutorial

  • Plotting the distribution of the data
  • Estimating the population mean
  • Excluding outliers
  • Changing the histogram classes
• Correlation / PCA tutorial

  • Understanding the relationship between variables
  • Reducing the dimensionality of the data
  • Understanding the relationship between variables (revisited)
  • Understanding the similarities between observations
  • Grouping the observations
  • Adding additional variables
  • Adding additional observations
  • Publishing the plot
• Compare groups means tutorial

  • Testing for a difference of means
  • Testing assumptions of the t-test
  • Trying a different statistical test
• Association in 2-way contingency tables tutorial

  • Cross tabulation of the data
  • Displaying patterns of association
  • Reordering data
• Simple linear regression tutorial

  • Plotting bivariate data
  • Fitting a simple regression model
  • Checking the assumptions of the regression model
  • Changing the regression fit
  • Making predictions
• Bland-Altman method comparison tutorial

  • Plotting the relationship between methods
  • Estimating the average bias and the limits of agreement
  • Understanding the importance of repeatability
  • Using repeated measurements
  • Dealing with a relationship between difference and magnitude of measurement
  • Transforming the measurements to remove a relationship between differences and magnitude
  • Estimating regression based limits of agreement when transformation is not enough
  • Estimating nonparametric limits of agreement in non-normally distributed data
• Estimating the precision of a measurement procedure (CLSI EP05-A3)

  • Estimating precision
  • Estimating precision for a multi-site study
  • Fitting a precision profile
• Evaluating the linearity of a measurement procedure (CLSI EP06-A)

  • Estimating linearity
  • Reducing the measuring interval
• Verifying the precision of a measurement procedure against a performance claim and estimating the bias (CLSI EP15-A3)

  • Estimating precision
  • Testing precision against a performance claim
  • Identifying and excluding outliers
  • Estimating bias
• Pareto charts tutorial

  • Identifying frequent problems
  • Investigating stratification
  • Highlighting the vital few and hiding the trivial many
  • Monitoring improvements
  • Sharing knowledge
• Process control charts tutorial

  • Bringing a process under control
  • Identifying stratification
  • Identifying special-causes of variation
  • Identifying shifts (and other patterns)
  • Revising control limits
  • Monitoring future production
• Process capability tutorial

  • Determining process capability
  • What's the difference between Pp and Cp?