|
|
|
|
Stored Procedure used to determine the Linear Correlation between 2 variabes in a table of your database.
This can also be used to determine the goodness of fit (Linear Regression) or best straight line between two columns of data in your database.
The equation created will be of the form Y = A + BX, and finds the best straight line which describes your data.
For use in data analysis, data mining, data warehousing and statistical analysis.
|
| |
Can't Copy and Paste this?
Click here for a copy-and-paste
friendly version of this code!
--**************************************
-- for :Data Correlation
--**************************************
The use or distribution of this
algorithm is free provided that
it is used / distributed along
with the HEADER NOTICE in the
Stored Procedure always and
withhout any changes to the
HEADER NOTICE.
No claim is made as to the
accuracy or fitness of this
algorithm. The use of this
algorithm is at your own
risk and choice and the
author is not liable in
any way for its use or
damages that may occur
as a result of its use.
Pareto Analysts
(http://www.visual-basic-data-mining.net)
retains ALL and FULL COPYRIGHTS
of this Algorithm, Stored Procedure
and Code and grants you the right
to use it for commercial or non
commercial purposes.
| |
 Download code
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.Virus note:All files are scanned once-a-day by Planet Source Code for viruses, but new viruses come
out every day, so no prevention program can catch 100% of them. For your own safety, please:
- Re-scan downloaded files using your personal virus checker before using it.
- NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
If you don't have a virus scanner, you can get one at many places on the net
including:McAfee.com
|
Terms of Agreement:
By using this code, you agree to the following terms...
- You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
- You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
- You may link to this code from another website, but ONLY if it is not wrapped in a frame.
- You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.
|
Other 4 submission(s) by this author
|
|
Report Bad Submission
|
Your Vote
|
| |
Other User Comments
|
 4/3/2007 12:24:00 AM: Berli
thanks man ,.,g coba dulu yeee
(If this comment was disrespectful, please report it.)
|
Add Your Feedback
Your feedback will be posted below and an email sent to
the author. Please remember that the author was kind enough to
share this with you, so any criticisms must be stated politely, or they
will be deleted. (For feedback not related to this particular code, please
click here instead.)
To post feedback, first please login.
|
