🎯 Percentile Calculator
Determine percentile values for any dataset with flexible interpolation. Toggle between inclusive (Excel PERCENTILE.INC) and exclusive (nearest-rank) definitions to match your classroom or business requirements.
Dataset Input
Comma, space, newline, or tab separated values
Invalid tokens are ignored. Paste directly from spreadsheets or CSV files.
Method:
Percentile Value
—
Rank (1-based)
—
—
Dataset Count
—
Interpolation
—
Context Summary
No values analysed yet.
Data Quality Insights
- No values analysed yet.
How to Use
- Paste your dataset into the input box using any separator.
- Enter the percentile (0-100) and select the desired method.
- Click Calculate Percentile to view the percentile value, rank, and interpolation details.
- Review the summary and insights to understand data spread and outlier sensitivity.
- Use clean/reset buttons when working with multiple datasets sequentially.
Formula References
- Inclusive: \( P = x_{(k)} + w (x_{(k+1)} - x_{(k)}) \) where \( k = \lfloor (n-1)p \rfloor \).
- Exclusive (nearest rank): \( P = x_{(\lceil np \rceil)} \).
- References: NIST/SEMATECH Engineering Statistics Handbook; Excel documentation.