Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Get the T-Student with SQL

Author  Topic 

merlin23
Starting Member

1 Post

Posted - 2010-01-15 : 18:00:33
Hi, I need to get the T-Student distribution, in Excel the function is TINV(Probability,Deg_Freedom), buy I can not find a sentence in SQL, Thanks a lot for your help.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-01-15 : 19:06:29
What is T-Student?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2010-01-15 : 23:03:07
You could write you own, or buy a third party add on:
http://westclintech.com/Products/XLeratorDBstatistics/tabid/154/Default.aspx

CODO ERGO SUM
Go to Top of Page

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2010-01-18 : 13:16:33
quote:
Originally posted by tkizer

What is T-Student?


It's a statistical measure.
http://en.wikipedia.org/wiki/Student%27s_t-test

SQL Server does not have extensive built-in support for statistical functions. You will have to find a 3rd-party vendor to supply you with some, or write your own functions/CLRs.

________________________________________________
If it is not practically useful, then it is practically useless.
________________________________________________
Go to Top of Page

jstampf
Starting Member

1 Post

Posted - 2010-05-13 : 18:43:14
quote:
Originally posted by merlin23

Hi, I need to get the T-Student distribution, in Excel the function is TINV(Probability,Deg_Freedom), buy I can not find a sentence in SQL, Thanks a lot for your help.



here you go - it's free on sql server express

http://westclintech.com/Products/XLeratorDBstatistics/XLeratorDBstatisticsDocumentation/tabid/159/topic/STUDENTST/Default.aspx
Go to Top of Page
   

- Advertisement -