Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Is there a way to calculate R Squared in Crystal Post Reply Post New Topic
Author Message
TC Tran
Newbie
Newbie


Joined: 24 Oct 2011
Online Status: Offline
Posts: 19
Quote TC Tran Replybullet Topic: Is there a way to calculate R Squared in Crystal
    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
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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.
IP IP Logged
TC Tran
Newbie
Newbie


Joined: 24 Oct 2011
Online Status: Offline
Posts: 19
Quote TC Tran Replybullet 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!
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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.
 
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.