This content has been marked as final.
Show 4 replies

1. Re: Calculating R2 and P values
Patrick Van Der Hyde Nov 29, 2017 1:07 PM (in response to Arshad Nawaz) 
2. Re: Calculating R2 and P values
Bora Beran Nov 29, 2017 3:19 PM (in response to Arshad Nawaz)1 of 1 people found this helpfulYou can nest LOD expressions or use table calcs if your data is aggregated.
I need more context before I can help more. Please share the packaged workbook.

3. Re: Calculating R2 and P values
Arshad Nawaz Nov 30, 2017 10:18 AM (in response to Bora Beran)Attaching the workbook. Trying to pull out the p values and R2 of the trend lines plotted on this simple line graph.
Hopefully the method should also update the values when new filters are introduced.

TrackData.twbx 131.3 KB


4. Re: Calculating R2 and P values
Arshad Nawaz Dec 13, 2017 11:10 PM (in response to Bora Beran)Bora Beran I have attached the workbook which needs the calculations of p values and R2. Could you please help with the calculations. Thanks in advance.