Data Size: Different versions of XLMiner™ have varying limits on size of data. The size of data depicted in the example below may not be supported by your version. Refer to Data Handling Specifications for details.
Let us see how Matrix plots can be effectively used on BostonHousing.xls.
Open BostonHousing.xls.
For illustration, we will choose four variables - INDUS, AGE, DIS and RAD. We will select a few cases , say, 50 to view a good Matrix Plot .
-
Take the cursor in the box for data range and click. XLMiner™ will allow you to make changes in the range. Choose first 50 rows.
-
Go to variables. Keeping the "Ctrl" key pressed, select INDUS, AGE, DIS, RAD.
-
Keep the title as it is. Select "OK" to see the output.
The Matrix Plot appears as follows.
Consider the plot in second row and third column. This plot shows a pairwise relationship between the variables AGE and DIS. The scale to be used for AGE is present in the beginning of second row. Every value in it should be multiplied by 102 ie. 100 to get the actual value. The scale for DIS appears at the bottom of third column. Here the multiplication factor is 100 ie. 1. So the scale should be read as it is.
Note : On invoking the Charts menu, you will see an option "Delete hidden sheets". When XLMiner™ creats charts, some hidden sheets are created for internal calculations. When you delete the charts the hidden sheets are not deleted automatically. So when you delete the charts, select "Delete hidden sheets" once to delete the hidden sheets.
See also: