Print Page | Close Window

Is there a way to calculate R Squared in Crystal

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15007
Printed Date: 31 Mar 2025 at 12:35am


Topic: Is there a way to calculate R Squared in Crystal
Posted By: TC Tran
Subject: Is there a way to calculate R Squared in Crystal
Date Posted: 22 Nov 2011 at 11:29am
Hello,
 
I am needing to calculate the value of R Square in a trend line chart and wondering if there is a way to calculate this value in Crystal Reports?  I have Crystal Reports 2008 by the way.
 
Thank you so much for any help in advance!
 
Thanks,
TC


Replies:
Posted By: lockwelle
Date Posted: 23 Nov 2011 at 4:43am
I am guessing that there is.  I don't remember the formula, but using formulas and shared variables you should be able to create a solution to display the R Squared value.

Posted By: TC Tran
Date Posted: 23 Nov 2011 at 5:13am

Thank you for your response!  I am not familiar with share variables.  In MS Excel there is a R-squared built in function and I was hoping CR has this built in function as well but I've had no luck in finding.  I couldn't find anything on Google relating R-squared and Crystal Reports.

 
Thank you!

Posted By: lockwelle
Date Posted: 23 Nov 2011 at 5:21am
google r squared and then apply the formula.  if it is too complex or can't be done, well that's that.
 
it would seem that it is not part of CR toolbox, as they only have only the basic statistical calculations.
 


Print Page | Close Window