Using Excel Standard Deviation for Visual Studio 2005

See more:

VB

MS-Excel

Hello everyone : )

I was searching online on how to do coding to calculate standard deviation and came across the idea of using Excel in Visual Studio to calculate StDev for a dataset.

I apply the coding as followed to try using Excel StDev to do the math.

Private Function Compute(ByVal data As ArrayList) As Double

        Dim result As Double = 0.0
        Dim sum As Double = 0.0
        Dim i As Integer = 0
        Dim count As Integer = 0


        'CALCULATE AVERAGE
        If ComputationType.Equals("Average") Then

            For i = 0 To data.Count - 1
                If data(i) Is DBNull.Value Then 'IMPORTANT! SOME RECORD HAS NULL VALUE SO MUST ADD A ZERO
                    sum += 0
                Else
                    sum += data(i)
                End If

                count += 1
            Next i

            result = sum / data.Count

            'CALCULATE STANDARD DEVIATION
        ElseIf ComputationType.Equals("STDev") Then

            result = Application.WorksheetFunction.StDev(data(i))

           Return result

    End Function

However, Visual Studio says that Application.WorksheetFunction is not a member of System.Windows.Forms.Application.

I will greatly appreciate if some pros can explain to me what went wrong and how to solve this problem? Thank you very much :)