© Hong Zhou 2020
H. ZhouLearn Data Mining Through Excelhttps://doi.org/10.1007/978-1-4842-5982-5_10

10. Association Analysis

Hong Zhou1 
(1)
University of Saint Joseph, West Hartford, CT, USA
 
Correlation measures the linear association strength between two numerical variables. The strength is expressed by the correlation coefficient which must be in the range of -1 to 1 inclusively. Given two variables X and Y, if they are positively correlated, then X and Y go in the same direction. For example, X is the daily temperature and Y is the ice cream sale. The higher the X, the larger the Y; or the lower the X, the smaller the Y. If X and Y are negatively correlated, then they go in the opposite directions. For example, the car mileage and car weight. ...

Get Learn Data Mining Through Excel: A Step-by-Step Approach for Understanding Machine Learning Methods now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.