RSQ Excel Formula

Author Zaheer    Category Formulas     Tags ,

What would be life without MS excel? You will have to make manual computations and formulas, which are really time-consuming. Excel let you analyze and create graphs, and even calculate through formulas and functions that are pre-installed. In addition to that, it has different statistical functions that allow the user to calculate statistical computations from simple to complex. You can find the mean, median, and mode to the most complex such as the probability tests.

Some functions are not present in the earlier series of the Microsoft Excel. The functions are also divided into small groups for the functions to easily find the specific function you need.

One specific Statistical Function is known as RSQ function computes the squares of two given sets of value in terms of Pearson Product-Moments Correlation Coefficients. The syntax of RSQ function includes:

=RSQ (known_y’s,known_x’s)

…wherein the known_y’s are values of the data points same with the known_x’s argument.

The arguments in the syntax can be names, numbers, arrays, or sources cells which contain the numbers or values. The values that are directly part of the lists of argument is still counted. Moreover, the cells that contains the value 0 (zero) are still included while the source cells that has logical value or empty will be ignored. If an error occurs, it can be because the given arguments can’t be translated or read as numerical values.

The common errors while using RSQ function are #N/A errors and # DIV/ 0! error. #N/A errors value occurs when the argument known_y’s along with known_x’s are blank or does not have the same data points. While #DIV/0! errors occurs when the known_y’s along with known_x’s contains only one data point.

As an example, open blank Excel spreadsheet or worksheet. For the known y values, input in cell A1 the value 2, in cell A2 the value 3, in cell A3 the value 9, in cell A4 the value 1, in cell A5 the value 8, in cell A6 the value 7, and in cell A7 the value 5. For the known X values input cell B1 the value 6, in cell B2 the value 5, in cell B3 the value 11, in cell B4 the value 4, in cell B5 the value 5, in cell B6 the value 4, and in cell B7 the value 4. Input the formula =RSQ (A1:A7, B1:B7) and the result will be 0.05795.

Post comment