[dba-Tech] Excel statistical functions

Stephen stephen at bondsoftware.co.nz
Fri Aug 14 15:51:08 CDT 2009


Just looked through my usage:

SUM 
IF
LEFT and MID
VLOOKUP (and its complement HLOOKUP)
SUMIF
COUNTIF
ROUND (and its derivatives ROUNDUP, ROUNDDOWN, CEILING...)
DATE and DATEDIF  
Financial functions PMT, FV, PV and IRR
ISBLANK 


Stephen Bond


-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of
Susan Harkins
Sent: Saturday, 15 August 2009 4:31 a.m.
To: Stephen
Subject: Re: [dba-Tech] Excel statistical functions

Anybody else? I don't use 10, period -- hard for me to
guess. :) 

Susan H. 


> I'll try:
> FTEST
> TTEST
> PEARSON
> MEDIAN
> FREQUENCY
> CORREL
> CHITEST
> AVERAGE
> COUNT
> COUNTIF
> 
> Of course, if you really want to do statistical analyses
you dump the 
> file from Excel into SPSS.
> 
> 
> Ed Tesiny
> EdTesiny at oasas.state.ny.us
> 
> -----Original Message-----
> From: dba-tech-bounces at databaseadvisors.com
> [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf
Of Susan 
> Harkins
> Sent: Thursday, August 13, 2009 8:58 AM
> To: DBA Tech List
> Subject: [dba-Tech] Excel statistical functions
> 
>
<http://office.microsoft.com/en-us/excel/HP052030661033.aspx
>
> 
> I need to narrow this down to 10 -- anyone want to vote? I
need the 10 
> top in terms of usage/need.
> 
> Susan H. 
> 
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
> 
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com






More information about the dba-Tech mailing list