Exhibit Dwell Time Average Minutes Aggregator
Aggregate complete dwell measurements separately from censored observed lower bounds under represented visitor weights; not survival-corrected mean dwell or ignoring unfinished visits.
Description
A completed visit supplies a full dwell time; an unfinished observation supplies only a lower bound.
A completed visit supplies a full dwell time; an unfinished observation supplies only a lower bound. They should not be silently averaged as equivalent data.
Aggregate complete dwell measurements separately from censored observed lower bounds under represented visitor weights; not survival-corrected mean dwell or ignoring unfinished visits.
When to use Exhibit Dwell Time Average Minutes Aggregator
Use this tool to aggregate complete dwell measurements separately from censored observed lower bounds under represented visitor weights; not survival-corrected mean dwell or ignoring unfinished visits.
Prepare the collection, exposure, scheduling or financial records required for this calculation. Keep row order and the declared units consistent.
How to use Exhibit Dwell Time Average Minutes Aggregator and understand its results
- Prepare the collection, exposure, scheduling or financial records required for this calculation. Keep row order and the declared units consistent.
- Enter observedDwellMinutes, completeObservationFlags, representedVisitorWeights using the field table and calculation rules, then run the tool.
- Read weightedCompletedDwellMinutes, completedObservationCount, censoredObservationCount, weightedAllObservedMinimumDwellMinutes. The explanation below defines the units, signs, ordering and any flags or placeholder values.
- If the tool reports an input issue, correct the values and run it again. Apply the stated assumptions when interpreting a successfully returned result.
| Input field | Meaning | Value type; see rules below | Requirement |
|---|---|---|---|
| observedDwellMinutes | Observed dwell minutes | list of number | Required |
| completeObservationFlags | Complete observation flags | list of number | Required |
| representedVisitorWeights | Represented visitor weights | list of number | Required |
Align nonnegative minutes, positive represented weights and binary completion. Require at least one completed observation. Return weighted complete dwell, both status counts and weighted observed minimum across all records.1
Paired lists must be nonempty and have equal lengths.
completed mean = Σ dwell × weight × complete flag/Σ weight × complete flag Units, indexing, boundary conditions and exceptional cases are defined in the calculation rules above.
| Output field | Meaning | Value type |
|---|---|---|
| weightedCompletedDwellMinutes | Weighted completed dwell minutes | number |
| completedObservationCount | Completed observation count | number |
| censoredObservationCount | Censored observation count | number |
| weightedAllObservedMinimumDwellMinutes | Weighted all observed minimum dwell minutes | number |
{
"input": {
"observedDwellMinutes": [
2,
10,
20
],
"completeObservationFlags": [
1,
1,
0
],
"representedVisitorWeights": [
1,
3,
1
]
},
"output": {
"weightedCompletedDwellMinutes": 8,
"completedObservationCount": 2,
"censoredObservationCount": 1,
"weightedAllObservedMinimumDwellMinutes": 10.4
}
}Limitations and assumptions
This is not a survival-corrected mean for the full visit population.
Numbers and computed results must be finite; overflow produces an error. Numeric lists are limited to 100,000 entries; the rules above may require smaller limits. Missing required fields, extra fields, wrong value types and violations of the calculation rules are input errors.
Alternative or Complementary methods
Use Gallery Route Loop Length Walking Time Calculator: Budget segment-specific walking exposure plus independent stop/queue ledger, rather than one average-speed geometric route; no accessibility, evacuation or visitor timing guarantee. For a complementary task, use Peak Hour Visitor Flow Congestion Index Calculator: Reconstruct observed interval-boundary visitor inventory from separate arrivals/departures and compare caller comfort occupancy; no hidden Little’s-law steady state, within-interval peak, fire-code approval or crowd safety.
References
Similar or alternative tools
- Gallery Route Loop Length Walking Time Calculator
Budget segment-specific walking exposure plus independent stop/queue ledger, rather than one average-speed geometric route; no accessibility, evacuation or visitor timing guarantee.
- Peak Hour Visitor Flow Congestion Index Calculator
Reconstruct observed interval-boundary visitor inventory from separate arrivals/departures and compare caller comfort occupancy; no hidden Little’s-law steady state, within-interval peak, fire-code approval or crowd safety.