Example: parcel mass by zone
90 orders: 30 from each of three packing zones; three numerical measurements per order.
Download the example data (CSV)This is the same example used in Help. Import the CSV to follow the steps, or use Open example in a practice copy in Help to prefill the inputs.
1. Create the workspace
In the sidebar, open Basic Statistics and choose Display Descriptive Statistics. Create an analysis, name it, select New blank worksheet, then choose Create analysis.
2. Import the example data
Download the CSV above and import it into the worksheet. Choose Comma as the delimiter, Dot as the decimal separator and First row contains column names.
3. Assign the input columns
On Inputs, open Variable and select parcel_mass_kg. Enter parcel_mass_kg in Display name (optional). Check Summarize by groups, then assign packing_zone to Grouping variable (optional).
4. Set the summaries and plots
Enter 0.05 in Trimming proportion per tail. This requests 5% trimming from each end. Open Plot options and check Include histogram, Include boxplot and Include individual value plot.
5. Run analysis
Choose Run analysis, then open Results.
6. Interpret results
Check what was summarized
The data contain 90 orders: 30 from each of three packing zones, with no missing measurements. The group table separates the zones. All three charts combine the 90 orders.
Read the center
The overall mean is 1.857 kg and median 1.88 kg. The mean is the average; the median splits the ordered values in half.
Read the spread
The standard deviation is 0.825 kg. It describes variation between orders, not uncertainty in the average. Read the range and quartiles alongside it before comparing zones.
Compare the zones
The zone means are Mixed_orders 1.645 kg, Accessories 2.054 kg and Small_parts 1.872 kg. Each has 30 orders. The pooled average combines these different order mixes.
Read the histogram
Each bar counts orders in a value interval. Read the horizontal axis in the measurement unit and look at the overall shape and spread. These are observed counts; they do not give the probability for a future order.
Parcel mass (kg) across all 90 orders; the three packing zones are pooled. View full-size chart (opens in a new tab) Read the boxplot
The box contains the middle half of the measurements, with a line at the median. The observed values range from 0.40–3.41 kg; no values cross the 1.5 × IQR fences. The fences describe this sample, not customer acceptance limits. The lower mathematical fence is negative even though parcel mass cannot be. It is an outlier-screening calculation, not a possible mass or an acceptance limit.
Parcel mass (kg) across all 90 orders; the three packing zones are pooled. View full-size chart (opens in a new tab) See the individual values
Each point represents one order. Values are sorted along the measurement axis; vertical spacing separates them. This plot shows neither collection order nor separate zone distributions.
Parcel mass (kg) across all 90 orders; the three packing zones are pooled. View full-size chart (opens in a new tab) Choose the next comparison
Use the zone summaries to plan handling needs; these masses do not establish parcel or worker performance.
More details: read each result section
Complete result tables use six significant digits, as in Help.
parcel_mass_kg — Descriptive statistics
Counts and center: Non-missing, Missing and Total describe available values. Mean is the average; Median is the middle ordered value. Trimmed mean excludes 5% from each tail using the app’s convention.
Spread and uncertainty: SD describes spread in the measurement unit; Variance is SD squared. Min, Max and Range describe extremes. Q1 and Q3 bound the middle half; IQR is their difference. Standard error describes uncertainty in the mean, not spread between orders. See Additional descriptive measures for the remaining definitions.
| Statistic | Value |
|---|---|
| Non-missing count | 90 |
| Missing count | 0 |
| Total count | 90 |
| Mean | 1.857 |
| Median | 1.88 |
| Trimmed mean | 1.85659 |
| Standard deviation | 0.824969 |
| Variance | 0.680574 |
| Standard error | 0.0869594 |
| Coefficient of variation (%) | 44.4248 |
| Minimum | 0.4 |
| Q1 | 1.1525 |
| Q3 | 2.5725 |
| Interquartile range | 1.42 |
| Maximum | 3.41 |
| Range | 3.01 |
| Sum | 167.13 |
| Sum of squares | 370.931 |
| Skewness | -0.00479624 |
| Kurtosis | -1.05256 |
| Mean square successive difference | 0.685965 |
parcel_mass_kg — Group summaries
Group is the packing-zone label; n and Missing count usable and missing measurements. Mean and SD describe each zone separately. Percent and Cumulative % describe shares of the included observations in the displayed group order; they are not performance rates.
Percents are relative to non-missing measurements; group order follows first appearance.
| Group | n | Missing | Mean | SD | Percent | Cumulative % |
|---|---|---|---|---|---|---|
| Mixed_orders | 30 | 0 | 1.64533 | 0.807562 | 33.3333 | 33.3333 |
| Accessories | 30 | 0 | 2.054 | 0.764756 | 33.3333 | 66.6667 |
| Small_parts | 30 | 0 | 1.87167 | 0.874604 | 33.3333 | 100 |
Descriptive calculation methods
These rows name the quartile, skewness and excess-kurtosis conventions. Keep them with the report when comparing summaries from different software. Quartiles use interpolation at (n + 1)p with endpoint clamping.
| Statistic | Value |
|---|---|
| Quartiles | Interpolation at (n + 1)p with endpoint clamping |
| Skewness | Adjusted Fisher–Pearson |
| Kurtosis | Bias-corrected excess kurtosis |
parcel_mass_kg — Modes
Each row lists a value tied for the greatest recorded frequency. Rounding can create repeated values; a mode is not a target setting.
| Mode |
|---|
| 2.18 |
parcel_mass_kg — Histogram summary
Bins is the interval count; Bin width is in the measurement unit. Scale is frequency, so bar heights count orders. Keep these settings with the chart because changing bins changes its appearance.
| Statistic | Value |
|---|---|
| Bins | 8 |
| Bin width | 0.5 |
| Scale | frequency |
parcel_mass_kg — Boxplot summary
Q1, Median and Q3 describe the ordered values. IQR is Q3 minus Q1. Fences are Q1 minus 1.5 × IQR and Q3 plus 1.5 × IQR; whiskers end at the most extreme observations inside them. Fence values can fall outside the physical data range. They are not acceptance limits. For these data, the lower fence is negative; parcel masses cannot be negative.
| Statistic | Value |
|---|---|
| Lower whisker | 0.4 |
| Q1 | 1.1525 |
| Median | 1.88 |
| Q3 | 2.5725 |
| Upper whisker | 3.41 |
| IQR | 1.42 |
| Lower fence | -0.9775 |
| Upper fence | 4.7025 |
Additional descriptive measures
Coefficient of variation is SD as a percentage of the mean. Sum and Sum of squares are arithmetic totals. Skewness describes asymmetry and excess Kurtosis describes tail shape. Mean square successive difference uses neighboring worksheet values, so it depends on row order. The app’s quartile and trimming conventions remain in Descriptive calculation methods.
7. Create a report
Keep the overall Descriptive statistics, Group summaries, Modes, calculation methods, histogram settings, boxplot summary and all three charts. Include the units and explain that the charts pool the zones.
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.