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.
Open BostonHousing.xls. We will draw a Histogram of the variable INDUS.
-
Select XLMiner --> Charts --> Histogram.
The data range will be indicated in the box. Keep it as it is. Point on INDUS from the list of variables. Click on ">" to select it. The X-axis title is automatically changed to INDUS.
The chart title, X-Axis title and Y-Axis title can be modified.
Select "OK" and see the output.
The data is distributed between the values 0.46 to 27.4. The values on X-axis are divided in 11 intervals of 3 each. This way the data is appropriately spaced out to get a proper picture of its shape.
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: