LinkBack URL
About LinkBacks
Hi,
R Squared for single variable can be easily apply whereby =RSQ(Known_y's, Known_x's) =RSQ(A1:A10,B1:B10).
However, If I have column C for 2nd variables, =RSQ(A1:A10,B1:C10) is not working.
can anyone help?
Hi,
R Squared for single variable can be easily apply whereby =RSQ(Known_y's, Known_x's) =RSQ(A1:A10,B1:B10).
However, If I have column C for 2nd variables, =RSQ(A1:A10,B1:C10) is not working.
can anyone help?
1. Thank those who have helped you by clicking the Star * below the post.
2. Please mark your post [SOLVED] if it has been answered satisfactorily.
Sincerely,
Farid
You can use the following normally-entered formula (just press Enter, as usual):
=INDEX(LINEST(A1:A10,B1:C10,TRUE,TRUE),3,1)
Hi joeu,
Thanks a lot. Just curious, in case I have 3 independent variables or more than 3, which part need to be changed?
According to the documentation the R square value will always be in the first column of the third row, so that changing the number of vectors (columns in this case) of x values is all that is needed.
Examples: for 3 independent variables use: =INDEX(LINEST(A1:A10,B1:D10,TRUE,TRUE),3,1)
and for 4 independent variables use: =INDEX(LINEST(A1:A10,B1:E10,TRUE,TRUE),3,1)
Let us know if you have any questions (hopefully one of the mathematicians will pick up).
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Hi JeteMC,
Thank you very much.
You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks