Box Plot

Version

Application Scenarios

To analyze multiple indicators, like purchase prices, you can use a box plot to analyze diverse price calculation indicators, such as the highest and lowest prices.

You can use box plots to better comprehend data distribution characteristics or to identify outliers in your data. Box plots are particularly useful for statistical analysis tasks, including quality management, personnel evaluation, and exploratory data analysis.

Basic Requirements

Characteristics

Advantages: display statistical graphs of continuous data distribution.

Disadvantages: not ideal for large datasets, trend or percentage data representation.

Introduction

Box-plot, also known as box-and-whisker plot, is a statistical graph used to showcase data dispersion. It is widely used in quality management and other fields to display distribution characteristics of raw data and compare multiple datasets. Box-plots provide information on bias, symmetry, outliers, and data density.

Structure

The median (Q2) is represented by a line through the middle of the box. The upper and lower edges of the box represent the upper quartile (Q3) and lower quartile (Q1) of the data, encompassing 50% of the data. The height of the box indicates data fluctuation, while any points beyond the maximum or minimum values are considered outliers. To learn more about the three indicators Q1, Q2, and Q3 in box plot, refer to statistical concept quartiles, see Quartile.

Maximum and minimum values are calculated using the following formula:

Maximum value: Q3 + 1.5*IQR (IQR = Q3 - Q1)

Minimum value: Q1 - 1.5*IQR

Preparing Data

1. Log in to FineBI and click New Subject.

2. In the Select Data interface, click Local Excel > Upload to upload local excel files.

Example data: Sales.xlsx

3. Once uploaded, click OK.

Creating Components

1. Click Component.

2. Select Box Chart as Chart Type, and drag State to the horizontal axis, Sales to the vertical axis, and City to Fine-grained.

Customizing Components

Drag City to Color to add color differentiation.

Demonstration

Preparing Data

Example data: Contract Information.xlsx

Procedure of data preparation is the same as example one.

Creating Components

1. Click Component at the lower left corner.

2. Select Custom Chart as Chart Type and drag Contract Type to the horizontal axis, and Product to the vertical axis twice. In Graphic Properties, set the two Product indicators to display as box plot and point respectively.

3. Drag Customer ID to Fine-grained in All under Graphic Properties.

Customizing Components

1. Adjusting Point Size

Under Chart Properties, click open the indicator field which you set to display as points and adjust Radius (the size of the point in this case) in Size.

2. Adjusting the Maximum Value

Hover your cursor over the field dragged to the vertical axis, click  > Set Value Axis(Left-value Axis). In Display Range, select Custom and set the maximum value as 60.

Demonstration

You can clearly identify outliers in this chart.