This example illustrates the use of Analytic Solver Data Mining's chart wizard in drawing a Scatterplot using the Iris.xlsx data set. On the Data Mining ribbon, from the Applying Your Model tab, select Help - Examples to open Iris.xlsx. Select a cell within the data set, and on the Data Mining ribbon, from the Data Analysis tab, select Explore - Chart Wizard to open the Chart Wizard dialog.

 

Select ScatterPlot, then click Next to open the Chart Wizard - Y Axis Selection dialog.

 

Select Petal_width, and click Next to open the Chart Wizard - X Axis Selection dialog.

 Select Petal_length, and click Finish.

Note that the graph shows that Iris flowers with small, medium or large pedal widths generally have the same (small, medium or large) pedal lengths.  

Click the down arrow next to Color By and select Species_name from the menu.  Now we can see that out of the three varieties of iris flowers, the Setosa variety has the smallest petal widths and lengths, the Verginica has the latest petal widths and lengths and the Versicolor variety is in between the Setosa and Verginica.  

Please see the section Common Chart Options (below) for a complete description of each icon on the chart title bar.

 Common Options for Charts ToolBar

To exit the graph, click the red X in the upper right-hand corner of the Chart Wizard window.

Save Chart Window 

To save the chart for later viewing, click Save. To delete the chart, click Discard. To cancel the save and return to the chart, click Cancel. For this example, type Scatterplot for the chart name, then click Save. To reopen the chart, on the Data Mining ribbon, from the Data Analysis tab, select Explore - Existing Charts - Scatterplot.

Using Analytic Solver Cloud to Create a Histogram

Click Help – Example Models – Forecasting / Data Mining Models in Analytic Solver Cloud to open the Iris dataset.  Then click Explore – Chart Wizard and select Scatterplot.

  • Click Variable to change the variable on the Y axis.
  • Click Verses to change the variable on the X axis
  • Click Size By to enlarge/decrease the plotted points by the selected variable. 
  • Select Color By to add a specific color to the plotted points.