High-Performance Statistical Queries: Dependencies Between Discrete Variables

sql statistical queries, data mining and statistical analysis using sql, sql statistics functions, dbcc show statistics, create statistics in sql server, sql server table statistics, how to check statistics in sql server, dbcc update statistics, how to check database statistics, last updated datetime in sql server

In my previous article, we looked at how you can calculate linear dependencies between two continuous variables with covariance and correlation. Both methods use the means of the two variables in their calculations. However, mean values and other population moments make no sense for categorical (nominal) variables. For instance, if you denote “Clerical” as 1 and “Professional” as 2 for an occupation variable, what does the average of 1.5 signify? You have to find another test for dependencies—a test that

Continue Reading

GET ACCESS TO EXPERT SQL CONTENT!