RSQ in WPS on Windows: Introduction

WPS RSQ is a spreadsheet statistical function for calculating the square of 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

RSQ is a statistical function in WPS Spreadsheet that returns the square of the Pearson product-moment correlation coefficient for two data sets. It is useful for correlation analysis, regression review, and checking how closely two numeric series are related. While entering the formula, WPS can show syntax guidance to help confirm the parameter structure and input order.

In everyday spreadsheet work, RSQ is useful for:

evaluating how closely two columns of numeric data fit each other;
completing statistical calculations directly in a worksheet;
working with references across worksheets in the same workbook;
updating results automatically after source data changes.

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	Local function calculation does not require a constant internet connection; download, installation, and account-related actions require internet access
Other	You need access to WPS Spreadsheet and permission to edit the worksheet

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation notes	Download and install WPS Office for Windows, then open WPS Spreadsheet
Post-install check	Launch WPS, create or open a spreadsheet, select a cell, and type `=RSQ(` to confirm the formula input environment

Source: WPS download center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Enter `RSQ(known_y's, known_x's)` in WPS Spreadsheet to calculate the square of the Pearson product-moment correlation coefficient, with formula input guidance, cross-worksheet references, and automatic recalculation after data changes.	Excel provides the RSQ function and documents its syntax, arguments, remarks, errors, and examples for spreadsheet analysis.	Google Sheets provides `RSQ(data_y, data_x)` and notes that text in the arguments is ignored.	Notion formulas can perform calculations with database properties, built-ins, and functions, but the official formula help does not present a spreadsheet-style RSQ function as a direct equivalent.	Adobe Acrobat supports calculated form fields and totals in PDF forms, which fits form workflows rather than worksheet-based statistical functions.
WPS Advantages	Advantage: RSQ can be entered directly in worksheet cells for spreadsheet-based correlation analysis. Distinct: formula guidance, workbook references, and recalculation fit desktop spreadsheet workflows.	Compared with WPS: Excel also offers a dedicated RSQ function and more detailed official remarks; both are suitable for spreadsheet statistics.	Compared with WPS: Google Sheets also supports RSQ, with a stronger browser-based collaboration focus; WPS fits local desktop spreadsheet editing well.	Compared with WPS: Notion focuses more on database property formulas and workspace organization than cell-based statistical functions.	Compared with WPS: Adobe focuses on PDF form calculations instead of worksheet cell functions such as RSQ.
Official Source	—	RSQ function	RSQ	Intro to formulas	Advanced form fields

Overall Conclusion
If your main task is spreadsheet-based correlation analysis, WPS RSQ belongs to the same function category as Microsoft Excel and Google Sheets. Compared with Notion formulas and Adobe PDF form calculations, WPS stays closer to a traditional worksheet workflow for ongoing data review and recalculation.

Use Cases

No.	Scenario	Suitable for	Main challenge	How RSQ helps
1	Sales and campaign correlation analysis	Operations teams and sales analysts	You need to quickly judge the relationship between two business data series	Enter RSQ in a cell to return the squared correlation coefficient directly
2	Teaching and research data review	Teachers, students, and researchers	You need basic statistical analysis inside a worksheet	Use RSQ with selected data ranges for direct calculation
3	Multi-sheet data analysis	Finance teams and project analysts	Data is spread across worksheets and manual calculation is inefficient	Use cross-worksheet references and let the result update automatically
4	Dynamic report checking	Staff who maintain recurring reports	Results need to be recalculated after source data changes	Keep RSQ in the worksheet so recalculation happens automatically

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Use RSQ and other basic spreadsheet functions	✅ Available	✅ Available
Basic spreadsheet editing and calculation	✅ Available	✅ Available
More advanced PDF, template, and extended office benefits	Some features are limited	More benefits are available
Cloud storage	1 GB	20 GB

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
Everyday study and basic statistical calculation	Free plan	The RSQ function itself can be used for regular spreadsheet analysis
More cloud storage and broader office benefits	WPS Premium	Suitable when you also need more document, PDF, template, and cloud-related benefits

WPS membership center: Subscribe now