PERCENTILE.INC in WPS Spreadsheet: Syntax and Worked Examples

These examples come from an official WPS Academy video showing the Chinese-language spreadsheet interface. The video’s exact operating system, build and license tier are unverified. Its demonstrated results are historical evidence, not a current installation test. Independently calculated examples are labeled separately. Check that your installation recognizes the function and reproduce the small control before using it in a report.

=PERCENTILE.INC(array, k)

array is the data range and k is the requested percentile expressed as a proportion, such as 0.9 for the 90th percentile. The actual WPS argument dialog has two fields, and the completed formula has two arguments. A three-argument heading in the instructional worksheet is inconsistent with that dialog and executed formula; do not add a decimal-places argument.

The vendor describes this variant as including 0 and 1 in the percentile range. That description is not a complete tested boundary specification: the demonstration calculates only k=0.9 and does not exercise tiny samples, endpoints or errors.

Enter these values in C24:C33 in order:

96
75
88
71
74
91
92
83
65
60

Select E24 and enter =PERCENTILE.INC(C24:C33,0.9). Confirm the formula and leave the result in an ordinary numeric format. The vendor worksheet displays 92.4 at 61.878 seconds. This result is in the same units as the input scores; it is not a percentage to format as 92.4%.

The sorted data are 60, 65, 71, 74, 75, 83, 88, 91, 92, 96. The displayed result lies between the two highest values: 92 + 0.1 × (96 − 92) = 92.4. This independently verifies the arithmetic relationship of this particular fixture. It does not prove a complete WPS interpolation algorithm for all samples or authorize importing another spreadsheet’s endpoint behavior.

To make this calculation easier to review, place 0.9 in G1 and enter =PERCENTILE.INC($C$24:$C$33,$G$1) in a separate output cell. With the same data and k, the expected value remains 92.4. This is an original reference-based arrangement of the demonstrated calculation, not a newly executed WPS result. The fixed references keep the data and percentile setting stable if you copy the formula into a report template.

On this exact data, WPS’s separate PERCENTILE.EXC and PERCENTILE.INC demonstrations show 95.6 and 92.4 respectively at k=0.9. Record the chosen variant in your report methodology. Changing the suffix can change the cutoff even when the source range and requested percentile are unchanged. A percentile cutoff answers what value marks a position; it does not return the position of a given observed value.

• Use 0.9, not 90, to reproduce the supplied percentile parameter.
• Exclude labels from this numeric control range and check that all ten values were entered correctly.
• Do not round the input scores merely to make the output look simpler; choose display formatting separately.
• Empty arrays, text, logical values, duplicate values, singleton samples, endpoint behavior, out-of-range k and exact errors require additional product evidence or native testing.
• No general interpolation formula is claimed from this single demonstrated percentile.

• PERCENTILE.EXC: Compare the exclusive percentile cutoff.
• RANK.EQ: Assign ordinal ranks to observed values rather than calculating a percentile cutoff.

WPS Academy: PERCENTILE.INC. Reviewed vendor-video moments: 61.878 seconds. The source establishes the demonstrated workflow and outputs within the limits above.