[dba-Tech] Excel statistical functions

Tina Norris Fields tinanfields at torchlake.com
Sun Aug 16 14:53:42 CDT 2009


I use:
AVERAGE
COUNT (and COUNTA)
MAX
MIN
MEDIAN
STDEV
CORREL
IF
VLOOKUP (and HLOOKUP)

and, of course, SUM, PMT, FV, ROUND, and DATE

The stat functions, MEDIAN, STDEV and CORREL were especially useful in 
my master's thesis data analysis.  Otherwise, I find the COUNT and 
arithmetic stuff - SUM, AVERAGE, MIN, MAX are most useful.  The IF and 
LOOKUP (both V and H) are among my favorite tools.

I hope this helps.
T


Susan Harkins wrote:
> <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
>
>   



More information about the dba-Tech mailing list