Загрузка...

STATS_KENDALL: one-sided greater test in Sheets

Function used in this video:
STATS_KENDALL - Kendall correlation in Google Sheets
STATS_KENDALL is a statistical function provided by the ALS Stats add-on for Google Sheets.
Learn how to run a one-sided Kendall rank correlation test in Google Sheets by setting the alternative="greater" option in STATS_KENDALL.

Formula:
=STATS_KENDALL(columns, colFilter:"x,/^x/,-x3", ciLevel:0.9, alternative:"greater")

What changes:
You change the alternative hypothesis from the default two-sided test to a one-sided "greater" test focused on positive association.

What to look for:
The tau estimates for x, x1, and x2 stay the same, but the reported p-values and the interpretation of the confidence intervals now correspond to a one-sided greater test, reflecting evidence only for positive correlations.

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

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

Full Kendall correlation tutorial:
https://www.youtube.com/watch?v=QT8qSogAtd8

#googleSheets #statistics #correlation #hypothesisTesting #alsStats

Видео STATS_KENDALL: one-sided greater test in Sheets канала Als Stats
Яндекс.Метрика
Все заметки Новая заметка Страницу в заметки
Страницу в закладки Мои закладки
На информационно-развлекательном портале SALDA.WS применяются cookie-файлы. Нажимая кнопку Принять, вы подтверждаете свое согласие на их использование.
О CookiesНапомнить позжеПринять