4) Ranking Correlation by Absolute Strength.

This Blog entry is from the Linear Regression section in Learn R.

In the previous Blog entry a correlation matrix was created and the first column was transposed into a matrix by the name PearsonCorrelation.  The PearsonCorrelation matrix has the strength of relationship between each of the independent variables and the dependent variables.

The first task is to order the variables by their strength of their ABSOLUTE correlation, as both -1 and +1 are equally interesting extremes.  The abs() function in R makes this transformation effortless:

PearsonDependentAbs <- abs(PearsonDependent)
1.png

Run the line of script to console:

2.png

It can be seen from the environment pane window that a new matrix has been created:

3.png

In this instance, any negative number has been turned into a positive number, as observed by a single click in the environment pane:

4.png

The task remains to order the matrix by highest value to the lowest value.  This can be achieved with a simple click on the column in the matrix viewer (click once for ascending, again for descending):

5.png

While there are methods to order a matrix in R, they are extremely convoluted and the arrange() function as presented in dplyr does not work as the matrix is not a data frame (although it could be converted to a data frame by just passing the matrix to the data.frame() function). 

In view of this process being exploratory and not necessarily needing to be recreated, the manual ordering in the view pane is adequate.