What is Access Equivalent of RSQ Function in Excel?
Posted on 2006-10-19
Hi All --
My niece called me (her Auntie Access Developer) asking me how to do a RSQ in Access... I found a bit of info on Pearson's Correlation, but it was a bit dated.
Can anyone tell me how to do this? She says, " We have the known X and Y values but cannot figure out how to use the RSQ function in Access that Excel has. It would also be helpful if we could calculate both the linear and logarithmic r-squared value. "
Kids are so smart these days...
Thanks in advance!