PERCENTILE.EXC in WPS Spreadsheet returns the value at a specified percentile in a dataset, excluding 0 and 1; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 3 | Matches the number of rows in the How-to Index |
| Available without membership | 3 | Matches the number of Free rows in the index |
| Membership-related items | 0 | Matches the number of membership-related rows in the index |
About This Feature
Overview
PERCENTILE.EXC is a statistical function in WPS Spreadsheet that returns the value at a specified percentile in a data range by excluding the 0 and 1 endpoints. It is useful for score analysis, tiered reporting, threshold setting, and distribution-based data review.
Core tasks include:
- Insert PERCENTILE.EXC from the Insert Function dialog box.
- Type
=PERCENTILE.EXC(array,k)directly in a cell or in the formula bar. - Review function syntax and parameter details before or after entering the formula.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Windows device that can run WPS Office |
| App version | It is recommended to use the latest version of WPS Office |
| Network | No mandatory internet connection is required for local formula entry; internet access is needed for online help or updates |
| Other | WPS Spreadsheet should be installed, and you need permission to edit the worksheet |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Open WPS Spreadsheet and any workbook, then confirm that formula tools such as Insert Function are available on the Formula tab |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Supports percentile calculation in a spreadsheet cell with direct formula entry and an Insert Function dialog for guided input. | Excel provides PERCENTILE.EXC(array,k) and returns the k-th percentile where 0 < k < 1. | Google Sheets provides PERCENTILE.EXC(data, percentile) and calculates percentile values exclusive of 0 and 1. | Notion supports formula properties and many math functions for database calculations, but it does not document a spreadsheet-style PERCENTILE.EXC function. | Adobe Analytics documents advanced statistical and mathematical functions for calculated metrics, but the referenced page does not describe a spreadsheet-style PERCENTILE.EXC function. |
| WPS Advantages | Advantage: You can enter the function directly in worksheet cells or use a guided dialog to fill in arguments, which supports both quick entry and syntax checking in one spreadsheet workflow. | Compared with WPS: It offers the same named function and similar syntax, with usage centered on the Excel workflow. | Compared with WPS: It offers the same function category, but the experience is centered on an online spreadsheet environment. | Compared with WPS: It is more focused on database property formulas and page-based organization than cell-by-cell spreadsheet formulas. | Compared with WPS: Its statistical functions are designed for analytics metrics and reporting workflows rather than worksheet cell formulas. |
| Official Source | — | PERCENTILE.EXC function | PERCENTILE.EXC function | Formula syntax & functions | Advanced functions |
Overall Conclusion
If your main task is percentile analysis in spreadsheets, WPS, Microsoft Excel, and Google Sheets all provide closely related function support. WPS is well suited to users who want both direct formula entry and a guided function dialog in a Windows spreadsheet workflow.
Use Cases
| No. | Scenario | Suitable for | Main need | How it helps |
|---|---|---|---|---|
| 1 | Score percentile analysis | Teachers and trainers | Find the score at a specific percentile quickly | Use PERCENTILE.EXC to calculate the target percentile value |
| 2 | Sales data tiering | Operations and sales analysts | Split performance bands by percentile thresholds | Enter the function on a sales data range to get a cutoff value |
| 3 | Risk threshold review | Finance and data analysts | Set a reference boundary from historical data | Combine a data range and percentile argument to produce a threshold |
| 4 | Sample distribution review | Students and researchers | Understand how values are distributed across positions | Compare results from different percentile inputs |
| 5 | Reusable reporting templates | Office users | Repeating percentile calculations takes time | Save the function in a worksheet template and reuse it |
Membership & Benefits
Free vs WPS Premium
| Capability | Free | WPS Premium |
|---|---|---|
| Enter and calculate with PERCENTILE.EXC | ✅ | ✅ |
| Basic spreadsheet editing | ✅ | ✅ |
| More PDF, template, and extended office benefits | Some features are limited | More advanced benefits are available |
| Cloud storage | 1 GB | 20 GB, as shown on the pricing page |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended plan | Why |
|---|---|---|
| Learning formulas and handling routine statistics | Free | It already supports entering, editing, and calculating PERCENTILE.EXC |
| Needing more cloud storage or broader office benefits | WPS Premium | Suitable if you also use additional office features beyond basic spreadsheet work |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page