Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server Statistical Functions Expand / Collapse
Author
Message
Posted Sunday, January 11, 2004 2:28 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 1:07 AM
Points: 2,901, Visits: 1,805
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/dpoole/sqlserverstatisticalfunctions.asp

LinkedIn Profile
Newbie on www.simple-talk.com
Post #94590
Posted Monday, January 12, 2004 7:33 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, July 31, 2007 8:20 AM
Points: 885, Visits: 1

Great article David, I know zero about stats functions, great intro.

Cheers

Ck




Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Post #94742
Posted Tuesday, January 13, 2004 2:11 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 1:07 AM
Points: 2,901, Visits: 1,805

Glad you liked it Chris,

The more I look at stats the more sceptical I am about government statistics.  Lies, damn lies and statistics and all that.

My favourite quote was that a statistician is someone who draws a mathematically precise line between an unwarranted assumption and a foregone conclusion!

I spent 6 years with McCann-Erickson (part of the world's largest Advertising group) so I have a lot of notes on using databases to measure advertising response rates and geodemographic profiling etc.

I've also got a fair bit on using trigonometry to work out positional geography i.e. where your stores are in relation to each other and your customers.

Depending on how the this article is received I may write these up from the database angle.

Remember, marketing guys have expense accounts and know where the good pubs are, so this stuff can be useful



LinkedIn Profile
Newbie on www.simple-talk.com
Post #94777
Posted Wednesday, January 14, 2004 8:05 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 8, 2004 10:31 AM
Points: 181, Visits: 1

Interesting article -- I've done quite a lot of d.p. and analysis in my time but I think you've introduced the topic very well.

>>I've also got a fair bit on using trigonometry to work out positional

>> geography i.e. where your stores are in relation to each other and your

>> customers.

>>Depending on how the this article is received I may write these up from

>>the database angle.

I'ld certainly be interested to read that.




Post #95136
Posted Wednesday, January 12, 2005 3:04 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, December 1, 2008 8:26 AM
Points: 14, Visits: 7

I found this article very useful-thanks. I work as a researcher for a national UK charity and due to budget restrictions I don't have a copy of SPSS and didn't realise that SQL Server had some of these functions.

David-you seem to have experience with SPSS, how does its 'functionality/ease of use' with these functions compare with that of SQL Server bearing in mind that it is a dedicated analysis suite,

 

Thanks again

 

Mark

Post #154985
Posted Tuesday, September 16, 2008 9:28 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 9, 2012 10:26 AM
Points: 891, Visits: 1,958
Good and interesting article, David. Any chance of an update for new functionality in 2005/2008, assuming that there is new functionality?
Post #570361
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse