PEARSON in WPS on Windows: Introduction

WPS PEARSON is a spreadsheet correlation function used to calculate the Pearson product-moment correlation coefficient between two data sets; this guide covers 4 core tasks, with 4 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	4	Matches the number of rows in the How-to Index
Available without membership	4	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

PEARSON is a built-in statistical function in WPS Office for Windows spreadsheets. It is used to calculate the linear correlation between two sets of values. After you enter PEARSON(array1, array2), the result is returned in the selected cell and updates automatically when referenced data changes.

Core capabilities include:

Use the PEARSON function directly for correlation analysis and data validation.
Enter the function in a cell or in the formula bar with syntax guidance while editing.
Reference ranges across worksheets and combine the function with nested formulas.
Keep results updated automatically when source data changes.

This function is useful for data analysis, classroom demonstrations, business reports, and experiment comparisons.

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 calculation; internet access is needed for download, installation, and account services
Other	You need permission to open spreadsheet files and edit cells and formulas

Download & Installation

Before using PEARSON, install WPS Office on your Windows device and open WPS Spreadsheet.

Item	Details
Official download	WPS Office Free Download
Post-install check	Open WPS Office → open a spreadsheet → select any cell and type `=PEARSON(` to confirm that formula entry and calculation are available

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Use `PEARSON(array1, array2)` directly in a spreadsheet cell to calculate the Pearson product-moment correlation coefficient, with syntax guidance, cross-sheet references, and automatic recalculation.	Excel provides the `PEARSON` function and returns the Pearson product moment correlation coefficient for two arrays with matching data points.	Google Sheets provides `PEARSON(data_y, data_x)` to calculate the Pearson product-moment correlation coefficient and notes that `PEARSON` is synonymous with `CORREL`.	Notion formulas support properties, operators, and many functions for database calculations, but the official function list does not show a built-in `PEARSON` function for spreadsheet-style statistics.	Acrobat focuses on calculation fields in PDF forms, such as sums and products in form workflows, rather than spreadsheet-style `PEARSON` statistical functions.
WPS Advantages	Advantage: The function fits spreadsheet cell workflows directly. Distinct: It supports formula references, nested calculations, and automatic recalculation in a familiar worksheet environment.	Compared with WPS: Microsoft offers a closely related spreadsheet function workflow, but it is centered on the Excel ecosystem.	Compared with WPS: Google also offers the same function name, but the workflow is tied to Google Sheets rather than a local Windows spreadsheet environment.	Compared with WPS: Notion is better aligned with database property logic and page organization than traditional cell-based statistical formulas.	Compared with WPS: Adobe is oriented toward PDF form field calculations instead of regular spreadsheet correlation analysis.
Official Source	—	PEARSON function	PEARSON	Formula syntax & functions	Configure form field calculations in Acrobat

Overall Conclusion: If your main task is correlation analysis inside spreadsheet cells, WPS PEARSON aligns well with a standard worksheet workflow on Windows. If your work is more focused on database properties or PDF form interactions, Notion and Adobe serve different use cases.

Use Cases

No.	Scenario	Suitable For	Main Challenge	How PEARSON Helps
1	Sales data correlation analysis	Operations teams and sales analysts	You need to quickly judge whether two metrics have a linear relationship	Enter the PEARSON formula in a cell to calculate the correlation coefficient
2	Teaching and experiment statistics	Teachers, students, and researchers	You need to verify data relationships quickly during class or experiments	Use syntax guidance to complete the formula and review the result immediately
3	Cross-sheet data comparison	Finance teams and project managers	Data is spread across multiple worksheets and manual comparison is slow	Use cross-sheet references to calculate the correlation result
4	Ongoing report maintenance	Users who maintain recurring reports	Results need to stay updated after source data changes	Rely on automatic recalculation to keep results in sync

Membership & Benefits

Free vs WPS Premium

Capability	Free Users	WPS Premium
Basic PEARSON calculation	✅ Available	✅ Available
Core Office features	✅ Available	✅ Available
Advanced PDF and extended tools	Some features are limited	More complete access is available
Cloud storage and template benefits	Basic quota and limited downloads	Higher quota and more benefits

Source: WPS Office pricing page

Recommendations

Usage Scenario	Recommended Plan	Why
Everyday spreadsheet work, learning, and basic statistics	Free plan	The PEARSON function itself is available for regular analysis tasks
Broader office needs including more PDF, cloud, or extended tools	WPS Premium	A better fit for users who need more features across the full office suite

WPS membership center: Subscribe now