How to Find R-Squared(RSQ) Function in Excel office 365?
Tags: tofindrsquared, excel, excelfunctions
Published: 2021-08-30 02:22:05

---
title: How to Find R-Squared(RSQ) Function in Excel office 365?
published: true
date: 2021-08-26 16:33:59 UTC
tags: ToFindRSquared,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-find-r-squaredrsq-function-in-excel-office-365/
---

In this post, we will explain to you how to **use the R-Squared(RSQ) Function In Excel Office 365.** Let’s see them below!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

## R-Squared(RSQ) Function

- The **R-Squared of a data set** tells how well a **data** fits the **regression line**.
- It is the squared value of  **correlation coefficient** and also called **coefficient of determination**.
- This is often used in **regression analysis, ANOVA** etc.
- The squared formula in Excel is  **RSQ function**.

## RSQ Function Syntax

```
=RSQ(Known_ys, Known_xs)
```

**Syntax Explanation:**

- **Known\_ys:** The dependent variables.
- **Known\_xs:** The independent variables.

**NOTES:**

- The **number of variables of x and y** should be the **same**.
- Otherwise, Excel will through **#NA error**.

## Example1

- Firstly, you need to **create a sample data** set with **known\_xs** and **known\_ys**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Sample-data-39.png)<figcaption>Sample data</figcaption>

- Then, you have to use the **RSQ function** to find **R2** in Excel.
- Now, you need to write this **formula** in cell **A12**.

```
=RSQ(B2:B9,A2:A9)
```

![](https://geekexcel.com/wp-content/uploads/2021/08/RSQ-formula.png)<figcaption>RSQ Function</figcaption>

- Finally, after hitting **Enter** button, you will get the value **0.725103502** , which is **72%** approx.

## Example2

- Firstly, you need to **create a sample data** set with **known\_xs** and **known\_ys**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Ex-2-Sample-data-1.png)<figcaption>Sample data</figcaption>

- Then, you have to use the **RSQ function** to find **R2** in Excel.
- Now, you need to write this **formula** in cell **A12**.

```
=RSQ(B2:B9,A2:A9)
```

![](https://geekexcel.com/wp-content/uploads/2021/08/Ex-2-RSQ-function.png)<figcaption>RSQ Function</figcaption>

## Another method to Calculate R-Squared Function

- You have to calculate the **R-squared valu** e using **squared value of correlation coefficient**.
- For that, you need to use the following formula given below.

```
=POWER(CORREL(A2:A9,B2:B9),2)
```

- Now, the **CORREL function**  is used to calculate **correlation coefficient** and then **encapsulated** it with  **POWER function**  to get the **square of the correlation coefficient**.

**Check this too:** [How to use the RECEIVED Function in Excel office 365?](https://geekexcel.com/how-to-use-the-received-function-in-excel-office-365/)

## Wrap-Up

Hope you understood how to **use the R-Squared(RSQ) Function In Excel Office 365**. Please feel free to state your query or feedback for the above article. Thank you for Reading!! To learn more, check out **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Ahead:**

- **[Excel Office 365 VBA Variables & Data Types – A Complete Guide!!](https://geekexcel.com/excel-office-365-vba-variables-data-types-a-complete-guide/)**
- **[How to use the T.INV function in Excel office 365? – Easy Tricks!!](https://geekexcel.com/how-to-use-the-t-inv-function-in-excel-office-365-easy-tricks/)**
- **[How to use the ASINH Function in Excel office 365?](https://geekexcel.com/how-to-use-the-asinh-function-in-excel-office-365/)**