STATS_SPEARMAN exclude ID via colFilter in Google Sheets

Function used in this video:
STATS_SPEARMAN - Spearman correlation in Google Sheets
STATS_SPEARMAN is a statistical function provided by the ALS Stats add-on for Google Sheets.
Learn how to use a negative rule in STATS_SPEARMAN’s colFilter to quickly exclude an ID column while building a full Spearman correlation matrix in Google Sheets.

Formula:
=STATS_SPEARMAN(columns, colFilter, ciLevel, alternative)
Example core settings: columns = A9:F29, colFilter = "-id", ciLevel = 0.9, alternative = "less".

What changes:
You switch colFilter from a regex to the negative rule "-id", which keeps every column except the identifier.

What to look for:
The output returns to a full Spearman correlation matrix for q1, q2, q3, x, and y, confirming that the id column has been excluded while all numeric analysis columns are still included, along with their pairwise statistics and 90% confidence intervals.

Install add-on:
https://workspace.google.com/marketplace/app/als_stats/558005348178

Docs for this function:
https://als-stats.net/functions/spearman

#googlesheets #statistics #correlation #spearman #alsstats

Видео STATS_SPEARMAN exclude ID via colFilter in Google Sheets канала Als Stats