This example describes the use of the Box Plot in Analytic Solver to illustrate the details of the Sports TV Ratings dataset.  Steps for creating a box plot chart in Analytic Solver Cloud may be found below.

Using Analytic Solver Desktop to Create a Box Chart

This example describes the use of the Boxplot chart to illustrate the characteristics of the data set.

On the Data Mining ribbon select Help - Examples to open the BoxPlot.xlsx example data set.

Select a cell within the data, then select Explore - Chart Wizard to bring up the first Chart Wizard dialog. Select BoxPlot, and click Next.

Charts Wizard

On the Chart Wizard - Y Axis Selection dialog, select Y1, and click Next.

 Chart Wizard: Y Axis Selection

On the Chart Wizard - X Axis Selection dialog, select X-Var, then click Next to set Panel and Color options. These options can always be set later in the upper right-hand corner of the plot.

Chart Wizard: X Axis Selection

  Box Whisker Chart

Under the X-Var filter, uncheck class 4 to remove this class from the plot.

Box Whisker Chart

Hover next to the plot to display the following Intellisense window.

Box Whisker Chart

The dotted line denotes the Mean of 22.49, the solid line denotes the Median of 23.22. The box reaches from the 25th Percentile of 9.07 to the 75th Percentile of 37.87. The lower whisker (or lower bound) reaches to -47.343, and the upper whisker (or upper bound) reaches to 61.454.

To select a different variable on the y-axis, click the right-pointing arrow and select the desired variable from the menu.

Box Whisker Chart

To change the variable on the X-axis, select the down arrow next to X-Var, and select the desired variable.

X Axis Menu

To add a second boxplot, click the BoxPlot icon on the top of the Chart Wizard dialog.

Chart Wizard Tool Bar

A second chart is added to the Chart Wizard dialog. Click the X in the upper-right corner of each plot to remove it from the window. Color by and Panel by options are available in the upper right-hand corner of each plot.

Chart Wizard Tool Bar

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

See the Common Chart Options section for a complete description of each icon on the chart title bar.

Common Options for Charts ToolBar

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, enter BoxPlot for the chart name, then click Save. The chart will close. To reopen the chart, select Explore - Existing Charts - BoxChart. To delete the chart, click Delete.

Save Chart Window 

Using Analytic Solver Cloud to Create a Box Plot

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

    

  • Change the plotted variable(s) by clicking the down arrow beneath Variable.
  • Use Filter to filter the results according to specific criterion.