XLSTAT: A Charts Recommendation Tool (DataViz)

 

Dataset for Example

The (attached) dataset contains the weight and height of 100 men and 100 women.

 

Setting up

• Open XLSTAT.

• Click on the Visualizing data menu and select the DataViz feature:

In the DataViz interface:

• Check Quantitative data and select the Height and Weight columns.

• Check Subsamples and select the Gender column.

• The RECOMMANDED CHARTS part is updated.

Recommended Charts

A list of recommended charts is displayed:

• Use the scroll bar to navigate through them.

• Select the scattergram to have an idea of the distribution.

• Click on the Play button in the bottom right corner.

Interpreting the Results

Four Scattergrams are displayed. Click on the right and left arrows to navigate through them.

• Click on Options tab.

• Check Group plots .

• Click on Chart tab to update the results.

• Two charts are now displayed:

  • First one for male and female height.

  • Second one for male and female weight.

Chart Colors

• Click on Modify colors in the top right corner of RESULTS part.

• CHART COLORS part appears.

• Click on first eye icon to well detect which scattergram is for female.

• Click on first green rectangle . A color picker pops up.

• Choose Yellow color and click on OK . Displayed scattergram is updated.

• Click on right arrow to go to the second chart.

• Click on first green rectangle . A color picker pops up.

• Choose Yellow color and click on OK . Displayed scattergram is updated.

Export

• Click on Export button to export scattergrams to a new worksheet.