How to use statistics calculation in sql server 2000?

• muntasiriub

  SSCommitted

  Points: 1810

  More actions

  October 4, 2005 at 7:55 am

  #165511

  Hi,

  Can you please help me; I would like to do some statistics calculation like Correlation, standard deviation in SQL server 2000.

  How to do this….

   

  Thanks in advance

  Muntasir

  
  
  ..Better Than Before...

• Farrell Keough

  SSCoach

  Points: 17414

  More actions

  October 4, 2005 at 8:08 am

  #594840

  A quick search on google got this link: http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=84&rl=1 

  I wasn't born stupid - I had to study.

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  October 4, 2005 at 8:11 am

  #594843

  look up BOL "aggregate functions"...there're a couple of functions dealing with standard deviation...stddev() etc...

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**

• muntasiriub

  SSCommitted

  Points: 1810

  More actions

  October 4, 2005 at 9:04 pm

  #595045

  Dear All,

  THX,

  I have found stddev().... but not 'Correlation'.

   

   

  
  
  ..Better Than Before...