How to Use the PEARSON Function in WPS on Windows

Last updated:July 17, 2026

This how-to guide includes 4 topics, all available without membership; use the How-to Index to jump to the task you need and follow the entry path and steps.

How-to Index

No.TopicMembership Requirement
11. Enter the PEARSON functionFree
22. Fill in the function argumentsFree
33. Use cross-sheet references or nested calculationsFree
44. Update and review the resultFree

How-to Guide

1. Enter the PEARSON function

Entry path: Formulas tab → formula bar

  1. Open WPS Spreadsheet and select the cell where you want to show the result.
  2. Type = to start the formula.
  3. Type PEARSON(.
  4. Review the syntax prompt that appears and confirm the function name and argument format.

Success Criteria

  • Interface result: =PEARSON( appears in the cell or formula bar.
  • Next action available: You can continue entering arguments or selecting data ranges.

Tips While Using

  • Common mistake: If you do not type = first, the content may be treated as plain text.
  • Environment note: You need to be in an editable spreadsheet cell.

2. Fill in the function arguments

Entry path: Formula bar → argument input area

  1. After PEARSON(, enter one data argument.
  2. Add the separator and then enter the other data argument.
  3. Use the syntax prompt to check whether the number and format of arguments are correct.
  4. Press Enter to confirm the formula.

Success Criteria

  • Interface result: The cell shows a calculated result, and the formula bar keeps the full formula.
  • Next action available: You can select the cell again to review or edit the formula.

Tips While Using

  • Common mistake: Unclosed parentheses or a missing separator can cause a formula error.
  • Environment note: The two data sets should meet the function requirements and avoid invalid references.

3. Use cross-sheet references or nested calculations

Entry path: Formula bar → sheet references and function editing

  1. Switch to another worksheet while editing the formula and select the data range you want to reference.
  2. Return to the current cell and confirm that the reference has been added to the formula.
  3. Add other functions if needed to build a nested calculation.
  4. Check the parentheses structure and reference ranges, then confirm the formula.

Success Criteria

  • Interface result: The formula includes a worksheet reference or a combination of functions.
  • Next action available: You can change referenced data and observe the result update.

Tips While Using

  • Common mistake: Inconsistent reference ranges can affect the result.
  • Environment note: The referenced worksheet should be in the current file and accessible.

4. Update and review the result

Entry path: Result cell → review after data changes

  1. Edit the source data used in the calculation.
  2. Check whether the result cell updates.
  3. If you want to verify the output, recalculate again and review the result.
  4. Confirm that the result matches the current data, then save the file.

Success Criteria

  • Interface result: The result cell shows the updated value.
  • Next action available: You can keep editing data, copy the formula, or save the file.

Tips While Using

  • Common mistake: Numbers stored as text in referenced cells can affect the result.
  • Environment note: If the result does not change as expected, check the references and data format first.