Jump to content

Recommended Posts


So what I am trying to do is have autoit try to see if there is a correlation between two sets of data.

I have refreneced this thread


But am still kindof lost......

Here is the formula I am trying to get it to use

[color=#000000]Correlation(r) =[ NΣXY - (ΣX)(ΣY) / Sqrt([NΣX[/color][sup]2[/sup][color=#000000] - (ΣX)[/color][sup]2[/sup][color=#000000]][NΣY[/color][sup]2[/sup][color=#000000] - (ΣY)[/color][sup]2[/sup][color=#000000]])] [/color]
[color=#000000]where [/color]
[color=#000000]              N = Number of values or elements [/color]
[color=#000000]              X = First Score[/color]
[color=#000000]              Y = Second Score[/color]
[color=#000000]              ΣXY = Sum of the product of first and Second Scores[/color]
[color=#000000]              ΣX = Sum of First Scores[/color]
[color=#000000]              ΣY = Sum of Second Scores[/color]
[color=#000000]              ΣX[/color][sup]2[/sup][color=#000000] = Sum of square First Scores[/color]
[color=#000000]              ΣY[/color][sup]2[/sup][color=#000000] = Sum of square Second Scores[/color]

but I cant seem to get it to work

Can someone please help thank you

Link to post
Share on other sites

I don't think there is enough information here. We only have the first and second scores. To get the sum of the product of first and second scores, I believe you need all the scores. My assumption is based on reading part of the following page: http://easycalculation.com/statistics/learn-regression.php

Edited by czardas
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    No registered users viewing this page.

  • Create New...