Statistics

• Rob Hershfield

  SSC-Addicted

  Points: 440

  More actions

  March 21, 2005 at 11:43 pm

  #66597

  I'm looking for a product or source code for calculating statistics in T-SQL (by "statistics" I mean the types of calculations done by SPSS, SAS, etc,).  In particular, I need to compute p-value for hypothesis testing using chi-square and t-test formulas.  Any advice would be greatly appreciated.

  Thanks,

  Rob

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  March 22, 2005 at 1:09 am

  #548134

  Sorry, I suspect you don't want to hear my answer. But SQL Server is no product for such sophisticated statistics like you have in mind. T-SQL is no computational language and has a weaker math library than say C or C++. You are really better off doing this in a specialized product like the ones you've mentioned. However, if you find something, I would be very interested to hear about, too. Just out of curiosity.

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]