Returns the square of the Pearson product-moment correlation coefficient for data points in two arrays.
Hàm này hoạt động trong Google Sheets giống như trong Excel — cùng cú pháp và đối số.
RSQ(known_ys, known_xs)The RSQ function calculates the coefficient of determination, often denoted as r-squared, which represents the proportion of the variance in the dependent variable that is predictable from the independent variable. It is commonly used in regression analysis to determine how well a regression line fits the observed data. If the arrays contain text, logical values, or empty cells, those values are ignored.
=RSQ({2,3,5,7,11}, {1,2,3,4,5})Kết quả: 0.986
Calculates the r-squared value for the given sets of y and x values.
An RSQ value of 1 indicates that the independent variable perfectly predicts the dependent variable, meaning all data points lie exactly on the regression line.