用于Google电子表格的学生在JavaScript中的分发 [英] Student's t distribution in JavaScript for Google Spreadsheet

问题描述

Google Spreadsheets目前不支持标准功能 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).

谢谢！

推荐答案

< a href =http://www.math.ucla.edu/~tom/distributions/tDist.html =nofollow noreferrer>在这里你走了。

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