:RSQ function calculates product moment correlation coefficient squared-Table skills免费ppt模版下载-道格办公

RSQ function calculates product moment correlation coefficient squared

Picture and text skills
Case

Returns the square of the Pearson product-moment correlation coefficient calculated from the data points in known_y's and known_x's.

The R-squared value can be interpreted as the ratio of the variance of y to the variance of x.

Syntax
RSQ(known_y's,known_x's)
Known_y's array or data point range.
Known_x's array or data point area.

Description

￭ Parameters can be numbers, or names, arrays, or references containing numbers.

￭ If the array or reference parameter contains text, logical values, or blank cells, these values will be ignored; however, cells containing zero values will be counted.

￭ If known_y's and known_x's are empty or have different numbers of data points, RSQ returns the error value #N/A.

￭ The calculation formula of Pearson product moment correlation coefficient r is as follows:

￭ Where x and y are the sample averages AVERAGE(known_x's) and AVERAGE(known_y's).
￭ RSQ returns r2, which is the correlation coefficient square.

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/RSQ-han-shu-ji-suan-cheng-ji-ju-xiang-guan-xi-shu-ping-fang.html