statistics functions

[Guest]

Hello

in excel i use 2 statistics functions
kurt() for kurtosy
skew() for skewnes

i'd like to use them in access but i can't find them..

-- i use access 9

can someone help me

thanks

 

[Arvin Meyer]

You might try something like this.

Set a reference to Excel, then (aircode):

Function XLSkew(Arg1, Arg2) as Double
Dim objXL As New Excel.Application
XLSkew = objXL.WorksheetFunction.Skew(Arg1,Arg2)
Set objXL = Nothing
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

ok

It's what i wanted to do but i didn't know how

thinks a lot

 

[Guest]

your viry wilcome