How to Use the PEARSON Function in WPS on Windows

Last updated:July 20, 2026

This section includes 4 how-to topics, all available in WPS Spreadsheet on Windows; choose a topic from the index and follow the steps to enter, calculate, and review PEARSON results.

How-to Index

No.TopicMembership Requirement
11. Enter the PEARSON functionFree
22. Fill in arguments with syntax guidanceFree
33. Calculate correlation with cross-sheet referencesFree
44. Check the result and recalculateFree

How-to Guide

1. Enter the PEARSON function

Entry point: Formulas tab → formula bar

  1. Open WPS Spreadsheet and select the cell where you want to show the result.
  2. Type = in the formula bar or directly in the cell.
  3. Continue by typing PEARSON(.
  4. Get ready to enter the two data ranges used in the calculation.

Success Criteria

  • Interface result: The cell enters formula editing mode.
  • Next action available: You can continue entering the arguments and complete the formula.

Tips While Using

  • Common mistake: If you do not type = first, the content may be treated as plain text.

2. Fill in arguments with syntax guidance

Entry point: Formula editing mode after entering =PEARSON(

  1. Enter the first data range as the first argument.
  2. Type a comma to separate the arguments.
  3. Enter the second data range as the second argument.
  4. Type the closing parenthesis ) and press Enter.

Success Criteria

  • Interface result: A numeric result appears in the current cell.
  • Next action available: You can select the result cell and review the full formula in the formula bar.

Tips While Using

  • Common mistake: Missing arguments, an unclosed parenthesis, or a missing separator can cause a formula error.

3. Calculate correlation with cross-sheet references

Entry point: Formula bar

  1. Select the result cell and type =PEARSON(.
  2. Switch to the first worksheet and select the first data range.
  3. Enter the argument separator, then switch to another worksheet and select the second data range.
  4. Type the closing parenthesis and press Enter to finish the calculation.

Success Criteria

  • Interface result: The formula includes worksheet references.
  • Next action available: When source data changes in either worksheet, the result updates accordingly.

Tips While Using

  • Common mistake: If the two data ranges do not contain the same number of data points, the result may return an error.

4. Check the result and recalculate

Entry point: Result cell / keyboard shortcut

  1. Review the correlation coefficient shown in the result cell.
  2. Check whether the referenced ranges contain unexpected text or blank distribution issues.
  3. Modify the source data and see whether the result updates automatically.
  4. If you need to trigger recalculation manually, press F9.

Success Criteria

  • Interface result: The result refreshes after data changes or after manual recalculation.
  • Next action available: You can copy the formula to other cells for additional spreadsheet analysis.

Tips While Using

  • Common mistake: Numbers entered as text can affect data review and result interpretation.