Calculating Percentile...

[Deepthiv]

hi

Is there any built in API that calculates Percentile given set of records in VB.NET??


Regards,
Deepthi

 

[Deepthiv]

i am using Excel Object API in VB.NET

Dim X1 As Object

X1 = CreateObject("Excel.Application")

Dim res As Double = X1.WorkSheetFunction.Percentile(dblData,p)

here is dblData is array of type double which has recordset column values,

There is an exception saying. "Unable to get the Percentile property of the WorksheetFunction class"

i have added "Microsoft Excel 9.0 Object Library"

am i missing anything? Can some one please help

Regards,
Deepthi

 

[Deepthiv]

any views?????