r squared

  1. G

    R SQUARED Formula Based on Conditions

    Hello I am trying to insert the R squared formula as follows: =RSQ(Known_ys, Known_xs) ONLY if row(i)= "YES" and ignore the rest of the data. For instance, the below should calculate RSQ excluding the rows where values in column C ="NO". I tried the following formula, but it didnt work: =...
  2. P

    LINEST returning wrong R^2

    I have a data set with only 2 variables (x and y) and I am using LINEST to set the intercept to zero and return additional statistics. The r^2 value that LINEST returns is completely wrong though. LINEST Returns a r^2 value of 0.999239357 where the actual r^2 value is 0.6544 that I get from a...
  3. P

    non linear r squared through VBA

    Hello. I would like to know if there a way or a build in function to calculate the non linear r squared value through VBA. For the linear r squared value you just have to square the Correl build in function, but what about the non linear? To make things clear, I uploaded a photo where for the...
    • prinzip
    • Thread
    • coefficient determination non linear function non linear r squared r squared
    • Replies: 1
    • Forum: Excel Questions
  4. T

    Extracting R Sqaured value from a graph using CODE

    Hi all, I'm a bit stuck at the moment. I must graph a series of data points in an X-Y scatter point chart multiple times, then fit every type of trendline to that a seperate graph. Using VBA, I must then extract the R Sqaured value from each trendline, and find the best trendline suitable for...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top