Statistics & Maths

How To Perform A One-Way ANOVA Test In Microsoft Excel

In this video tutorial, I’m going to show you how to perform a one-way analysis of variance (one-way ANOVA) test by using Microsoft Excel. I'll...

How To Perform A Spearman Correlation Test In R

In this tutorial, I will show you how to perform a Spearman rank correlation test in R. What is a Spearman correlation test? A Spearman's rank...

How To Analyse qPCR Results With Multiple Reference Genes

A question that I often come across for those who are calculating relative gene expression values in qPCR is, how to go about using...

The C1V1 = C2V2 Equation Explained

The simple formula of C1V1 = C2V2 is a lifesaver for bioscience researchers in the lab who are wanting to do dilutions. Here I...

What Is And How To Calculate Cohen’s d?

What is Cohen's d? Cohen's d is a type of effect size between two means. An effect size is a quantitative measure of the magnitude for...

How To Calculate Variance In Microsoft Excel

In this tutorial, I will demonstrate how to calculate the variance in Microsoft Excel. Specifically, I will show you how to calculate the variance...

How To Perform A Pearson Correlation Test In Excel

In this guide, I will show you how to perform a Pearson correlation test in Microsoft Excel. This includes determining the Pearson correlation coefficient...

How To Transform Data In GraphPad Prism

Written guide coming soon. GraphPad Prism version used: 8.1

How To Perform A Paired Samples T-Test In SPSS

What is a paired t-test? A paired t-test, also known as a dependent t-test, is a parametric statistical test used to determine if there are...

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...