ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   What is Multiple R, it is the first solution obtained in Regressi. (https://www.excelbanter.com/excel-worksheet-functions/7164-what-multiple-r-first-solution-obtained-regressi.html)

Souvik

What is Multiple R, it is the first solution obtained in Regressi.
 
The "Multiple R" is the first solution returned by Microsoft Excel for
Regression Analysis (Data Analysis). What is this Multiple R?

Michael R Middleton

Souvik -

The "Multiple R" is the first solution returned by Microsoft Excel for
Regression Analysis (Data Analysis). What is this Multiple R? <


"Multiple R" is the square root of "R Square."

"R Square" is, in words, the proportion of variation in Y that is explained
by the X variables in your model. "R Square" is sometimes called
"coefficient of determination."

Using results shown in the Regression tool ANOVA output, "R Square" is SS
Regression (explained variation) divided by SS Total (total variation).

- Mike

www.mikemiddleton.com




All times are GMT +1. The time now is 01:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com