Question

Difficulty: HardDescriptive Statistics Interpretation

The table lists performance and cost metrics for 10 municipal water treatment facilities during the 2025 fiscal year:

Facility IDRegionDaily Capacity (MGD)Average Turbidity (NTU)Operating Cost ($/thousand gallons)
W-01North24.00.121.42
W-02South18.00.251.85
W-03North32.00.081.28
W-04Central12.00.191.65
W-05South28.00.151.56
W-06Central40.00.101.18
W-07North15.00.221.70
W-08South22.00.141.50
W-09Central35.00.111.34
W-10North10.00.281.92

Based on the data provided, what is the median operating cost, in dollars per thousand gallons, for the facilities that have a daily capacity greater than 20.0 MGD?

Answer: 1.38 $/thousand gallons

Answer

The median operating cost for facilities with a daily capacity greater than 20.0 MGD is $1.38 per thousand gallons.
Filtering the table for facilities with Daily Capacity > 20.0 MGD yields 6 facilities (W-01, W-03, W-05, W-06, W-08, W-09). Sorting their operating costs in ascending order produces: 1.18,1.18, 1.28, 1.34,1.34, 1.42, 1.50,1.50, 1.56. Because the count of elements is even (6), the median is the average of the 3rd element (1.34)andthe4thelement(1.34) and the 4th element ( 1.42), which equals $1.38.

Step-by-Step Solution

1
Filter the dataset by the given capacity constraint.
Identified 6 facilities with Daily Capacity > 20.0 MGD: W-01 (24.0 MGD), W-03 (32.0 MGD), W-05 (28.0 MGD), W-06 (40.0 MGD), W-08 (22.0 MGD), and W-09 (35.0 MGD).
Only facilities meeting the criterion 'Daily Capacity > 20.0 MGD' must be evaluated.
2
Extract and order the operating costs for the filtered subset.
Operating costs in ascending order: 1.18,1.18, 1.28, 1.34,1.34, 1.42, 1.50,1.50, 1.56.
Determining the median of a dataset requires arranging values sequentially.
3
Calculate the median for an even-numbered dataset.
Average of the 3rd and 4th values: \(\frac{1.34 + 1.42}{2} = 1.38\).
When a dataset contains an even number of elements \(N = 6\), the median is the arithmetic mean of the two central numbers at positions \(N/2 = 3\) and \(N/2 + 1 = 4\).

Key Concept

Calculating the median of a filtered even-count subset from tabular data.

Alternative Method

As a verification step, sum all operating costs in the filtered set: 1.18+1.28+1.34+1.42+1.50+1.56=8.281.18 + 1.28 + 1.34 + 1.42 + 1.50 + 1.56 = 8.28. The mean is 8.28/6=1.388.28 / 6 = 1.38. In this symmetric subset, the mean and median coincide at 1.381.38.
Estimated Time:2m 0s
Rate this question