Example: packing zones
The example records 90 orders, with 30 from each of three packing zones. Packing time is in seconds; item count and parcel mass describe each order.
Download the example data (CSV)This is the same example used in Help. The CSV contains the observations to import.
1. Create the analysis
In the sidebar, open Plots and create an analysis. Name it, select New blank worksheet, then choose Create analysis.
2. Import the data
On Worksheet, choose Import. Select the downloaded CSV or paste its contents. Set the delimiter to Comma, use Decimal dot, and check First row contains column names. Preview the import, then choose Import into worksheet.
3. Assign the input columns
On Inputs, choose Box plot in Chart type. In Data arrangement, choose One variable by group.
Open the column picker for Measurement and select packing_time_s. For Grouping column, select packing_zone. Each box will summarize the orders from one zone.
4. Set the chart options
In Statistics, check Show outlier symbols. Leave Show individual observations and Show mean unchecked.
In Layout, choose First appearance for Order and Side by side for Comparison layout. Keep Blank categories or groups at Exclude and disclose.
Open Labels and enter Compare packing-time distributions in Chart title. Leave Horizontal axis label and Vertical axis label blank so the source labels are used.
5. Create chart
Choose Create chart, then open Results. Check Data used before comparing the chart with this guide. All stored worksheet rows participate; sorting or filtering the worksheet does not change the analytical sample.
6. Interpret results
Read one box
The line inside a box is the median: half the orders are below it and half above. The box contains the middle 50% of times. Whiskers extend to observed values within the 1.5-IQR fences, where IQR is the width of that middle half.
Thirty packing times per zone, with median lines, quartile boxes and 1.5-IQR whiskers. View full-size chart (opens in a new tab) Compare the typical times
Each zone has 30 orders. Accessories has the highest median, 161.85 seconds. Mixed_orders has 143.35 seconds and Small_parts has 135.05 seconds. Also compare box and whisker lengths to see how widely times vary.
Check the flags
No order is flagged by the 1.5-IQR rule, so Boxplot flags has no rows. This does not prove that every reading is correct. The whiskers and fences are not customer acceptance limits.
Investigate the difference
Check item counts and order mix before ranking zones or changing staffing. The chart describes these orders; it does not show that the zone itself caused the difference.
More details: read each result section
Complete result tables use six significant digits, as in Help.
Data used
Worksheet rows is 90; Eligible observations across series is 90; Excluded observations is 0. All source rows are used. Check these counts and keep the example’s column assignments when comparing runs. Worksheet sorting and filters do not change the analytical sample.
All stored rows are considered in original order. Worksheet sorting and filters do not change the analytical sample.
| Worksheet rows | Eligible observations across series | Excluded observations |
|---|---|---|
| 90 | 90 | 0 |
Data summary
Series names the measurement or group. Valid and Missing give counts; Mean and Median describe the center. Sample SD describes spread. Minimum and Maximum are the observed ends; Q1 and Q3 enclose the middle half. These summaries describe the captured observations, not acceptance limits. IQR is Q3 minus Q1. Lower fence and Upper fence are 1.5 IQR below Q1 and above Q3. Lower whisker and Upper whisker are the most extreme observed values within those fences; the app uses (n + 1)p quartiles.
| Series | Valid | Missing | Mean | Sample SD | Minimum | Q1 | Median | Q3 | Maximum | IQR | Lower fence | Upper fence | Lower whisker | Upper whisker |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Mixed_orders | 30 | 0 | 147.403 | 46.8407 | 78.5 | 107.375 | 143.35 | 185.475 | 229.8 | 78.1 | -9.775 | 302.625 | 78.5 | 229.8 |
| Accessories | 30 | 0 | 163.897 | 40.4056 | 95.5 | 137.775 | 161.85 | 201 | 226 | 63.225 | 42.9375 | 295.837 | 95.5 | 226 |
| Small_parts | 30 | 0 | 140.417 | 46.4157 | 59.9 | 109.65 | 135.05 | 178.4 | 252.5 | 68.75 | 6.525 | 281.525 | 59.9 | 252.5 |
Boxplot flags
This table has no rows: none of the 90 orders is beyond its group’s 1.5-IQR fences. When a row is present, Series names its group, Worksheet row locates the source record and Value gives the flagged measurement. A flag calls for investigation, not automatic deletion.
| Series | Worksheet row | Value |
|---|
No rows were returned for this section.
Full chart observations
Series identifies the group; Worksheet row locates the source record. X retains source-row position and Y is the original measurement. X is not horizontal placement within a displayed group. Check the original record before treating a point as an error.
| Series | Worksheet row | X | Y |
|---|---|---|---|
| Mixed_orders | 1 | 1 | 81.2 |
| Mixed_orders | 3 | 3 | 212.5 |
| Mixed_orders | 5 | 5 | 229.8 |
| Mixed_orders | 6 | 6 | 160.4 |
| Mixed_orders | 7 | 7 | 178.8 |
| Mixed_orders | 10 | 10 | 96.6 |
| Mixed_orders | 23 | 23 | 93.9 |
| Mixed_orders | 28 | 28 | 101 |
| Mixed_orders | 29 | 29 | 174.1 |
| Mixed_orders | 30 | 30 | 122.4 |
| Mixed_orders | 34 | 34 | 104.9 |
| Mixed_orders | 43 | 43 | 78.5 |
| Mixed_orders | 46 | 46 | 110.7 |
| Mixed_orders | 48 | 48 | 121.9 |
| Mixed_orders | 51 | 51 | 201.1 |
| Mixed_orders | 52 | 52 | 114.8 |
| Mixed_orders | 57 | 57 | 181.1 |
| Mixed_orders | 61 | 61 | 81.7 |
| Mixed_orders | 63 | 63 | 155.2 |
| Mixed_orders | 65 | 65 | 127.1 |
| Mixed_orders | 66 | 66 | 184.7 |
| Mixed_orders | 68 | 68 | 222.8 |
| Mixed_orders | 69 | 69 | 196 |
| Mixed_orders | 71 | 71 | 227.9 |
| Mixed_orders | 72 | 72 | 108.2 |
| Mixed_orders | 76 | 76 | 155.6 |
| Mixed_orders | 79 | 79 | 142 |
| Mixed_orders | 81 | 81 | 187.8 |
| Mixed_orders | 82 | 82 | 124.7 |
| Mixed_orders | 88 | 88 | 144.7 |
| Accessories | 2 | 2 | 102.1 |
| Accessories | 4 | 4 | 209.6 |
| Accessories | 8 | 8 | 96.7 |
| Accessories | 9 | 9 | 147.2 |
| Accessories | 11 | 11 | 219.9 |
| Accessories | 12 | 12 | 144.7 |
| Accessories | 18 | 18 | 198.9 |
| Accessories | 22 | 22 | 159.5 |
| Accessories | 24 | 24 | 164.6 |
| Accessories | 26 | 26 | 164.2 |
| Accessories | 27 | 27 | 105.4 |
| Accessories | 32 | 32 | 203.1 |
| Accessories | 37 | 37 | 191.7 |
| Accessories | 38 | 38 | 226 |
| Accessories | 41 | 41 | 181.3 |
| Accessories | 45 | 45 | 215.8 |
| Accessories | 49 | 49 | 141 |
| Accessories | 53 | 53 | 214.9 |
| Accessories | 56 | 56 | 119 |
| Accessories | 59 | 59 | 169.5 |
| Accessories | 60 | 60 | 128.1 |
| Accessories | 62 | 62 | 207.7 |
| Accessories | 64 | 64 | 191 |
| Accessories | 74 | 74 | 157.8 |
| Accessories | 75 | 75 | 152.4 |
| Accessories | 80 | 80 | 95.5 |
| Accessories | 84 | 84 | 148.6 |
| Accessories | 85 | 85 | 157.8 |
| Accessories | 89 | 89 | 200.3 |
| Accessories | 90 | 90 | 102.6 |
| Small_parts | 13 | 13 | 153.4 |
| Small_parts | 14 | 14 | 187 |
| Small_parts | 15 | 15 | 179.6 |
| Small_parts | 16 | 16 | 184 |
| Small_parts | 17 | 17 | 116.8 |
| Small_parts | 19 | 19 | 92.3 |
| Small_parts | 20 | 20 | 168.1 |
| Small_parts | 21 | 21 | 59.9 |
| Small_parts | 25 | 25 | 132.5 |
| Small_parts | 31 | 31 | 121.5 |
| Small_parts | 33 | 33 | 191.2 |
| Small_parts | 35 | 35 | 108.9 |
| Small_parts | 36 | 36 | 73.7 |
| Small_parts | 39 | 39 | 178 |
| Small_parts | 40 | 40 | 137.6 |
| Small_parts | 42 | 42 | 116.1 |
| Small_parts | 44 | 44 | 252.5 |
| Small_parts | 47 | 47 | 174.8 |
| Small_parts | 50 | 50 | 67.1 |
| Small_parts | 54 | 54 | 109.9 |
| Small_parts | 55 | 55 | 184.6 |
| Small_parts | 58 | 58 | 158.8 |
| Small_parts | 67 | 67 | 122.8 |
| Small_parts | 70 | 70 | 118.3 |
| Small_parts | 73 | 73 | 148 |
| Small_parts | 77 | 77 | 89.2 |
| Small_parts | 78 | 78 | 79.9 |
| Small_parts | 83 | 83 | 174.1 |
| Small_parts | 86 | 86 | 211.8 |
| Small_parts | 87 | 87 | 120.1 |
7. Create a report
Keep the native chart and Data used, together with Data summary, Boxplot flags, Full chart observations. Record the column assignments and chart options. Include the study context and any checks of unusual observations. Keep the chart’s units and the limitations described in the walkthrough.
Choose Add to report from the completed run. Open Choose individual items and advanced options to select tables and charts, then choose Add to draft. Hidden items stay in the saved analysis.
Name the report and add the purpose of the study and your interpretation. Choose Save, review Preview, then use Export → Download HTML. The example below contains the full selected content, including results beyond one screen.