PERCENTILE.INC in WPS helps you return an inclusive percentile value from a data set; 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.INC is a statistical function in WPS Spreadsheet that returns a percentile value from a data range by using the inclusive method. It is useful for score analysis, sales distribution reviews, sample statistics, and range-based evaluation.
Core tasks include:
- Insert PERCENTILE.INC from the Insert Function dialog box.
- Type
=PERCENTILE.INC(...)directly in a cell or in the formula bar. - Review syntax and parameter details before finalizing the formula.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Windows device that can run WPS Office normally |
| 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 downloading the app |
| Other | You need access to WPS Spreadsheet and permission to edit the worksheet |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Open WPS Spreadsheet and confirm that the Formulas tab and formula bar are available in a workbook |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | In WPS Spreadsheet, you can enter statistical functions such as PERCENTILE.INC directly in cells and also use the Insert Function dialog box to review parameters while building the formula. | Microsoft Word officially supports table formulas through the Formula command, including functions such as SUM, AVERAGE, and PRODUCT, but this is a document-table workflow rather than a spreadsheet function library workflow. | Google officially documents formula and function entry in Google Sheets, where users can type an equal sign in a cell, use a function help box, and access a function list for spreadsheet calculations. | Notion officially supports formulas based on properties, built-ins, and functions for database calculations, which is different from a traditional spreadsheet cell formula workflow. | Adobe Acrobat officially supports calculations for PDF form fields, which is designed for form logic rather than worksheet cell calculations. |
| WPS Advantages | Advantage: WPS fits spreadsheet-based percentile analysis directly in worksheet cells and also provides a function dialog workflow for parameter entry. | Compared with WPS: Word formulas are centered on calculations inside document tables, so the calculation environment is less aligned with spreadsheet analysis. | Compared with WPS: Google Sheets also supports spreadsheet formulas, but the official guidance here focuses on a web spreadsheet workflow rather than the Windows desktop WPS worksheet experience. | Compared with WPS: Notion formulas are oriented toward database properties and structured records instead of direct cell-by-cell spreadsheet formulas. | Compared with WPS: Acrobat calculations are intended for PDF form fields, so the usage scenario differs from spreadsheet statistics. |
| Official Source | — | Use a formula in a Word table | Add formulas & functions | Formula syntax & functions | Configure form field calculations |
Overall Conclusion
If you want to calculate inclusive percentiles in a spreadsheet, WPS provides a direct worksheet-based formula workflow on Windows. Other products also support calculations, but their official workflows are aimed at document tables, web spreadsheets, database properties, or PDF forms.
Use Cases
| No. | Scenario | Suitable for | Main challenge | How WPS helps |
|---|---|---|---|---|
| 1 | Score distribution analysis | Teachers and trainers | Need to find a target percentile quickly | Enter PERCENTILE.INC in a cell to calculate the required percentile |
| 2 | Sales data review | Operations and sales analysts | Need to understand where values fall in a distribution | Use the Insert Function dialog box to fill in the data range and percentile argument |
| 3 | Sample statistics review | Researchers and students | Need to confirm syntax and parameter meaning | Check the function description before entering the formula |
| 4 | Reusable report templates | Office users | Need to reuse the same statistical formula in recurring reports | Type the formula in the formula bar and copy it to other cells |
| 5 | Data checking and verification | Finance and administrative staff | Need to identify whether an issue comes from the range or the arguments | Review the function details and then check the referenced range and argument format |
Membership & Benefits
Free vs WPS Premium
| Capability | Free users | WPS Premium |
|---|---|---|
| Enter and calculate with PERCENTILE.INC | Available | Available |
| Basic spreadsheet editing | Available | Available |
| Additional office value-added features | Depends on the current account benefits | Includes more membership-related benefits |
Source: WPS Office pricing page
Recommendations
| Usage scenario | Recommended plan | Why |
|---|---|---|
| Learning formulas and handling basic statistics | Free | This function itself can be used without membership |
| Needing extra office benefits beyond formula work | WPS Premium | Suitable if you also need more membership-related services |
How to Subscribe
- WPS membership page: Subscribe now
Source: WPS Office pricing page