Agriculture Reference
In-Depth Information
Arrange the above correlation table as given
below:
Step 2: Invert
the Correlation Coefficients
Matrix
B
1. Go to insert menu and click function button.
Y
Ch1
Ch2
Ch3
0.669
1.000
0.773
0.200
0.221
0.740
0.773
1.000
0.374
0.200
0.221
1.000
~
~
Slide 11.4: Step 4, showing the selection of matrix inverse option from function submenu of MS Excel
2. Select MINVERSE option from the list.
3. Select the range of the matrix to be inverted,
that is, B here.
