- 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
支付宝扫一扫 
评论列表（196条）
测试