Statistics & Maths

How To Easily And Quickly Calculate Z Scores In Excel

In this tutorial, I will show you how to calculate Z scores by using Microsoft Excel. What is a Z score? A Z score is the...

How To Perform A Spearman’s Rank Correlation Test In Excel

In this guide, I will show you how to perform a Spearman's Rank correlation test in Microsoft Excel. This includes determining the Spearman correlation...

How To Calculate Confidence Intervals In Excel

In this guide, I will show you how to calculate the lower and upper confidence intervals (CIs) of the mean in Microsoft Excel. Unfortunately, there...

Calculating Mean, Standard Deviation And Error In Excel

In this guide, I will show you how to calculate the mean (average), standard deviation (SD) and standard error of the mean (SEM) by...

How To Identify And Remove Outliers In GraphPad Prism

In this guide, I will explain how to identify and remove outliers by using GraphPad Prism. To remove or not remove outliers? Outliers are data points...

How To Perform The Delta-Delta Ct Method

What is the delta-delta Ct method? The delta-delta Ct method, also known as the 2-∆∆Ct method, is a simple formula used in order to calculate...

How To Transform Data In GraphPad Prism

Written guide coming soon. GraphPad Prism version used: 8.1

How To Calculate Descriptive Statistics In GraphPad Prism

Written guide coming soon. GraphPad Prism version used: 8.1

How To Log Transform Data In GraphPad Prism

In this guide, I will show you how to log transform data in GraphPad Prism. Why bother log transforming data? There are two main principles as...

How To Compute A Mean Variable In SPSS

In this guide, I will demonstrate how to compute a mean (average) variable from a set of variables in SPSS. The example data In this example,...