Description
Return age margins and membership in a supplied cohort bin.
Business timing and cohort summaries depend on event origins, bucket boundaries and the treatment of incomplete records. A time difference or bucket label is a supplied record convention rather than proof of customer behavior, completed service or future retention.
Return age margins and membership in a supplied cohort bin.
When to use this tool
Use Cohort Age Boundary Gap when checking the stated business timing or cohort convention.
How to use the tool and how it works
- Enter age, binLower, binUpper, includeLower, includeUpper. Use the units and conventions below.
- Run the tool. Correct any format, range, or cross-field input error before interpreting the output.
- Read lowerGap, upperGap, inBin. Inspect inBin before interpreting the associated values.
Return age margins and membership in a supplied cohort bin. Require binUpper >= binLower; lowerGap = age-lower, upperGap = upper-age, inBin applies both endpoint-inclusion flags.1
| Input field | Meaning and units | Accepted input |
|---|---|---|
| age | Age | Required. Finite number. |
| binLower | Bin Lower | Required. Finite number. |
| binUpper | Bin Upper | Required. Finite number. |
| includeLower | Include Lower | Required. Boolean. |
| includeUpper | Include Upper | Required. Boolean. |
| Output field | Interpretation | Returned shape |
|---|---|---|
| lowerGap | Lower Gap | Required. Finite number. |
| upperGap | Upper Gap | Required. Finite number. |
| inBin | In Bin | Required. Boolean. |
{
"input": {
"age": 5,
"binLower": 0,
"binUpper": 5,
"includeLower": true,
"includeUpper": false
},
"output": {
"lowerGap": 5,
"upperGap": 0,
"inBin": false
}
}Limitations and assumptions
- The age unit and policy are supplied; a coincident bin includes its point only when both ends are closed.
- Inputs must satisfy both the field types and the cross-field conditions above. Invalid input causes an error; a successful false flag or documented placeholder is a different result.
- Numeric calculations use binary floating point unless exact decimal-integer arithmetic is explicitly stated. No hidden measurement tolerance or decimal rounding is added; nonfinite or out-of-contract results are rejected. Numeric signed-zero results are exported as zero.
Alternative or Complementary methods
Use complete event records and a defined cohort/period policy; evaluate commercial performance and uncertainty with appropriate complete analyses.
References
Similar or alternative tools
- Active User Period Boundary Pair
Check an active-user event against a supplied interval.
- Customer Age Period Index
Return customer age and period index relative to acquisition.