- Популярные видео
- Авто
- Видео-блоги
- ДТП, аварии
- Для маленьких
- Еда, напитки
- Животные
- Закон и право
- Знаменитости
- Игры
- Искусство
- Комедии
- Красота, мода
- Кулинария, рецепты
- Люди
- Мото
- Музыка
- Мультфильмы
- Наука, технологии
- Новости
- Образование
- Политика
- Праздники
- Приколы
- Природа
- Происшествия
- Путешествия
- Развлечения
- Ржач
- Семья
- Сериалы
- Спорт
- Стиль жизни
- ТВ передачи
- Танцы
- Технологии
- Товары
- Ужасы
- Фильмы
- Шоу-бизнес
- Юмор
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
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
Комментарии отсутствуют
Информация о видео
17 февраля 2026 г. 11:56:00
00:00:29
Другие видео канала
