1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
|
Public Function CoeffCorr2(sChampX As String, sChampY As String, sTable As String) As Single
Dim oDb As DAO.Database
Dim oRs As DAO.Recordset
Dim dSV As Double
Dim sSql As String
sSql = "SELECT Sum(" & sChampX & ") AS SX, Sum(" & sChampY & ") AS SY, " & _
"Sum((" & sChampX & ")*(" & sChampY & ")) AS SXY, Sum((" & sChampX & ")^2) AS SXX, " & _
"Sum((" & sChampY & ")^2) AS SYY, Count(" & sChampX & ") AS N FROM " & sTable
Set oDb = CurrentDb
Set oRs = oDb.OpenRecordset(sSql, dbOpenDynaset)
If Not oRs.EOF Then
dSV = (oRs("N") * oRs("SXX") - oRs("SX") ^ 2) * (oRs("N") * oRs("SYY") - oRs("SY") ^ 2)
If dSV > 0 Then
CoeffCorr2 = (oRs("N") * oRs("SXY") - oRs("SX") * oRs("SY")) / dSV ^ 0.5
End If
End If
Set oRs = Nothing
Set oDb = Nothing
End Function |
Partager