Data Analysis

Dunn’s Test for Multiple Comparisons

Understanding Non-Parametric Hypothesis Testing The Kruskal-Wallis test is a fundamental tool in non-parametric statistics. It is utilized when researchers need to assess whether there are statistically significant differences among the medians of three or more independent groups. This test serves as the non-parametric equivalent of the standard One-Way ANOVA, which typically requires strict assumptions about […]

Dunn’s Test for Multiple Comparisons Read More »

Calculate Point-Biserial Correlation in Excel

Point-biserial correlation is used to measure the relationship between a binary variable, x, and a continuous variable, y. Similar to the Pearson correlation coefficient, the point-biserial correlation coefficient takes on a value between -1 and 1 where: -1 indicates a perfectly negative correlation between two variables 0 indicates no correlation between two variables 1 indicates a perfectly positive

Calculate Point-Biserial Correlation in Excel Read More »

Make a Box Plot in Google Sheets

A box plot, often referred to as a box-and-whisker plot, is a powerful tool in exploratory data analysis. Its primary function is to visually display the distribution of a dataset based on its five number summary. This summary provides a concise statistical snapshot of the data’s spread, skewness, and central location. Understanding these five key

Make a Box Plot in Google Sheets Read More »

Calculate the Coefficient of Variation in Google Sheets

The coefficient of variation (CV), often abbreviated as CV, serves as a standardized measure of dispersion for a probability distribution or dataset. Unlike the standard deviation, which measures absolute variability, the CV expresses the variability relative to the mean. This makes it an invaluable statistical tool when comparing dispersion between datasets that have different units

Calculate the Coefficient of Variation in Google Sheets Read More »

Calculate Skewness & Kurtosis in Google Sheets

In the field of statistics, understanding the inherent shape of data is crucial for accurate analysis. Two fundamental measures used to quantify the form of a probability distribution are skewness and kurtosis. Together, these metrics provide essential insights beyond central tendency (mean, median, mode) and variability. This comprehensive tutorial will explain the theoretical foundations of

Calculate Skewness & Kurtosis in Google Sheets Read More »

Scroll to Top