This article describes the formula syntax and usage of the RSQ function in Microsoft Excel. Description. Returns the square of the Pearson product moment correlation coefficient through data points in known_y's and known_x's. For more information, see the PEARSON function. The r-squared value can be interpreted as the proportion of the variance ...

Open files from the File menu. Excel for Microsoft 365 Word for Microsoft 365 More... The Open tab on the File menu shows a list of files you’ve recently opened, and it includes links to places where you commonly store files. Windows macOS.

Worksheet functions are categorized by their functionality. Click a category to browse its functions. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the first column.

This article describes the formula syntax and usage of the RSQ function in Microsoft Excel. Description. Returns the square of the Pearson product moment correlation coefficient through data points in known_y's and known_x's. For more information, see the PEARSON function. The r-squared value can be interpreted as the proportion of the variance ...

This article describes the formula syntax and usage of the PEARSON function which returns the Pearson product moment correlation coefficient, r, a dimensionless index that ranges from -1.0 to 1.0 inclusive and reflects the extent of a linear relationship between two data sets.

Type and description. ABS function. Math and trigonometry: Returns the absolute value of a number. ACCRINT function. Financial: Returns the accrued interest for a security that pays periodic interest. ACCRINTM function. Financial: Returns the accrued interest for a security that pays interest at maturity. ACOS function.

Bài viết này mô tả cú pháp công thức và cách dùng hàm RSQ, trả về bình phương của hệ số tương quan mô-men tích Pearson thông qua các điểm dữ liệu của known_y và của known_x.

本文介绍 RSQ 函数的公式语法和用法，该函数通过 known_y 和 known_x 中的数据点返回 Pearson 积时刻相关系数的平方。

In diesem Artikel werden die Formelsyntax und die Verwendung der RSQ-Funktion beschrieben, die das Quadrat des Korrelationskoeffizienten für Pearson-Produktmomente über Datenpunkte in known_y und known_x zurückgibt.

本文將說明 RSQ 函數的公式語法及使用方式，此函數會透過 known_y 和 known_x 中的數據點傳回皮耳森積差相關係數的平方。