Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle COVAR_SAMP Function      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: COVAR_SAMP

Definition:
The COVAR_SAMP function returns the sample covariance of a set of number pairs, and can be used as an aggregate or analytic function.

COVAR_SAMP(<expression1>, <expression2>)


Sample covariance functions are widely used in statistics as common measures of location and dispersion.

They are easily calculated, however, they suffer from certain drawbacks; notably, they are not 'robust' statistics, meaning that they are thrown off by outliers, i.e something that is numerically distant from the rest of the data.

Related Links:

Related Code Snippets:
  • COVAR_SAMP - COVAR_SAMP returns the sample covariance of a set of number pairs. Both expr1 and exp...
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 301 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?