What is the function for R-SQuare in Excel?

Hi Experts,

What is the function for R-square in Excel? I have a function for slope and intercept but I am missing R-square to test a set of data for trend.

Thanks
LVL 1
indyngAsked:
Who is Participating?
 
rivusglobalConnect With a Mentor Commented:
RSQ(known_y's, known_x's)
0
 
Jeroen RosinkCommented:
You also might take a look at this article:
You will receive an incorrect R-squared value in the chart tool in Excel 2003
http://support.microsoft.com/kb/829249
0
All Courses

From novice to tech pro — start learning today.