PERCENTILE.INC in WPS on Windows: Introduction

PERCENTILE.INC in WPS on Windows is a percentile calculation function for spreadsheets; it includes 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 built-in statistical function in WPS Spreadsheet that returns the value at a specified percentile in a data range when the percentile argument is between 0 and 1, inclusive. You can enter it directly in a cell, follow the syntax prompt while typing, and combine it with cross-sheet references and nested formulas for data analysis.

Core capabilities include:

Using PERCENTILE.INC directly for percentile calculations in score analysis, sales analysis, and sample distribution review.
Adjusting arguments flexibly for different data ranges and percentile targets.
Combining cross-sheet references and nested formulas, with results recalculated automatically when source data changes.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	The latest version of WPS Office is recommended
Network	No mandatory network connection is required for local formula calculation; downloading, installing, and account-related services require internet access
Other	You need to open WPS Spreadsheet and edit worksheet cells

Download & Installation

Item	Details
Official download	WPS Office Free Download
Verification after installation	Open WPS Spreadsheet, open any workbook, and type `=PERCENTILE.INC(` in a cell to check whether the function prompt appears

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In WPS Spreadsheet, you can enter `PERCENTILE.INC(array,k)` directly, use syntax prompts, combine cross-sheet references, and nest formulas with automatic recalculation when data changes.	Excel provides `PERCENTILE.INC(array,k)` to return the k-th percentile of values in a range when k is between 0 and 1, inclusive.	Google Docs product information focuses on online document collaboration and content creation rather than spreadsheet percentile functions as a core Docs capability.	Notion formulas are designed for database property calculations and logic expressions rather than traditional spreadsheet percentile functions in cells.	Adobe Acrobat supports calculated PDF form fields for sums, averages, minimums, and maximums, which fits PDF form workflows rather than worksheet percentile analysis.
WPS Advantages	Advantage: direct percentile analysis in worksheet cells with syntax prompts, cross-sheet references, and nested formula workflows.	Compared with WPS: Excel offers the same function name and a similar syntax model, so formula habits transfer easily.	Compared with WPS: Google Docs emphasizes collaborative document editing instead of worksheet-based percentile calculation.	Compared with WPS: Notion formulas apply to database properties across records, which suits information management more than cell-based percentile analysis.	Compared with WPS: Acrobat calculations are built for PDF form fields, not spreadsheet-style statistical entry and analysis.
Official Source	—	PERCENTILE.INC function	Google Docs product page	Intro to formulas	Configure form field calculations in Acrobat

Overall Conclusion: If you need percentile analysis directly inside a spreadsheet with familiar formula entry, cross-sheet references, and nested calculations, WPS fits that workflow well on Windows. The other products listed here support calculation in different contexts, but their primary focus is spreadsheet ecosystems, collaborative documents, database properties, or PDF forms.

Use Cases

No.	Scenario	Suitable for	Main challenge	How this feature helps
1	Score distribution analysis	Teachers and trainers	Quickly identifying percentile thresholds in score data	Use PERCENTILE.INC to calculate target percentile values
2	Sales data tiering	Operations and sales analysts	Grouping records by performance bands	Calculate key percentile points such as 25%, 50%, and 90%
3	Sample statistics modeling	Data coordinators	Reusing statistical formulas across multiple sheets	Combine cross-sheet references and nested formulas
4	Routine report review	Office users	Manual recalculation after data updates takes time	Let automatic recalculation keep results in sync
5	Reusable analysis templates	Team collaborators	Repeating the same statistical logic in recurring files	Reuse PERCENTILE.INC formulas in a fixed template

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
PERCENTILE.INC calculation	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
Some advanced value-added features	Available within the scope shown on the pricing page	Access to more advanced features and value-added services

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
Routine formula work and basic statistics	Free	PERCENTILE.INC itself has no membership restriction and can be used for regular spreadsheet analysis
Long-term work that also needs more advanced office features	WPS Premium	Suitable when you also need more value-added features, cloud space, or extended services

WPS membership center: Subscribe to WPS Premium