O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

RSQ()

Syntax. RSQ(known_y’s;known_x’s)

Definition. This function returns the square of the Pearson correlation coefficient based on a set of data points known_y’s and known_x’s. The r2 value can be interpreted as the proportion of the variance in y attributable to the variance in x.

See Also

The Pearson correlation coefficient is explained in more detail in the section discussing the PEARSON() function.

Arguments

  • known_y’s (required). An array or a range of data points

  • known_x’s (required). An array or a range of data points

Note

Arguments can be numbers or names, arrays, or references containing numbers. If an array or a reference argument contains text, logical values, or empty cells, those values are ignored. However, cells with the value 0 are included. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required