excel function in access

[Guest]

i am able to call an excel function whereby i just one parameter, but when i
pass an array i am running into problems? for example, i want to calculate
the skewness of a time series, how can i do this? can i do this in a query by
form or does it have to be in vba. also, does anyone know how to perform
matrix function such as covariance by passing data to excel functions? many
thks

 

[fredg]

i am able to call an excel function whereby i just one parameter, but when i
pass an array i am running into problems? for example, i want to calculate
the skewness of a time series, how can i do this? can i do this in a query by
form or does it have to be in vba. also, does anyone know how to perform
matrix function such as covariance by passing data to excel functions? many
thks

You have posted this message to the wrong newsgroup.
The access in this groups name refers to Microsoft Access, a database
program.
Please repost to the correct Excel newsgroup. I would suggest you
include your Windows and Excel version number in the message.

 

[Guest]

sorry. i should have specified that i am in access and in access seek to call
on excel funtions. once again, in access, i am able to call an excel
function whereby i just one parameter, but when i

 

[Guest]

Are we doing homework? I'm not sure about the covariance or the skewness,
but you can use an Excel function in VBA by adding the Excel Object library
to your references and use the following format:

WorksheetFunction.Skew(arrSeries())

Or

WorksheetFunction.Covar(arrSeriesOne(),arrSeriesTwo)

To use these, you need to create an array of the time series to calculate
the skew and two arrays to calculate the covariance.

 

[Guest]

thks. is it possible to create the array to pass to the excel function in
query by design or does this need to be performed in vba? in the query by
design, i have a field for risk: stdeva([Value]), whereby value represents
the monthly returns, however, it appears i am not passing the array. any
suggestions would be appreciated.

thks