谷歌电子表格的 JavaScript 学生 t 分布 [英] Student's t distribution in JavaScript for Google Spreadsheet

问题描述

Google 电子表格目前不支持标准函数 TDIST - 即学生的 t 分布.此函数对于计算 p 值至关重要.

Google Spreadsheets currently does not support the standard function TDIST - i.e. the Student's t-distribution. This function is critical for calculating p-values.

这似乎与没有实现积分使用函数 (AFAICT) 的事实有关.

It seems that this is related to the fact that no integral-using functions (AFAICT) are implemented either.

但是，Google Docs 允许人们在 JavaScript 中添加和发布自己的脚本.

However, Google Docs allows people to add and publish their own scripts, in JavaScript.

所以理想情况下，我们应该有类似的东西:

So ideally we should have something like:

function tdist(t_value, degrees_of_freedom, two_tailed [defaults true]) {...}

有谁知道这个的现存实现(我的 google-fu 还没有出现，但可能比你的弱)或者如何做的好主意?

Anyone know of either an extant implementation of this (my google-fu has not turned up one, but may be weaker than yours) or a good idea for how to do it?

我想将它与其他一些目前可计算但有点麻烦的有用函数(如学生的 t 检验本身)一起发布.

I'd like to publish this together with some other useful functions that are currently calculable but a bit of a pain (like Student's t-test itself).

谢谢！

推荐答案

给你.

这篇关于谷歌电子表格的 JavaScript 学生 t 分布的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！