Add Trendline to ASP.Net Chart
By : Moh Som
Date : March 29 2020, 07:55 AM
I hope this helps you . There's a pretty good article on doing that on the 4Guys from Rolla site: "Using Microsoft's Chart Controls In An ASP.NET Application: Adding Statistical Formulas"

Weighted trendline
By : Mr. Glodny
Date : March 29 2020, 07:55 AM
it helps some times With data in A2:C7, based on the standard weighted least squares formula, you can try: code :
=LINEST(B2:B7*C2:C7^0.5,IF({1,0},1,A2:A7)*C2:C7^0.5,0)
=INDEX(LINEST((B2:B7SUM(B2:B7*C2:C7)/SUM(C2:C7))*C2:C7^0.5,IF({1,0},1,A2:A7)*C2:C7^0.5,0,1),3,1)
SSres = 59.76
SSreg(u) = 1461.24
SSTot(u) = 1521
Rsq(u) = 1  59.76/1521 = 0.9607
SSTot(c) =SUMPRODUCT(C2:C7*(B2:B7SUM(B2:B7*C2:C7)/SUM(C2:C7))^2) = 244.93
Rsq(c) = 1  59.76/244.93 = 0.756

How do I get endpoints of a trendline?
By : Fauzan ppnh
Date : March 29 2020, 07:55 AM
To fix the issue you can do Want to change your scale from Amps/Time to MilliAmps/Time? Multiply by 1000 Trouble with Unix timestamp? Because your timescale reaches back to Jan 1, 1970. Pick a timestamp as your 'zero' time and subtract it from all of the others.

How to get trendline equations in R
By : user2136834
Date : March 29 2020, 07:55 AM
like below fixes the issue i have a series of data in form of time and temperature value. I want to generate a trendline and find the subsequent equation. This could be done in excel. but, how could i find equation of the trendline in R. , but where is the underlying equation? code :
> coef(model)
(Intercept) x
1.2093273 0.9786051
paste('y =', coef(model)[[2]], '* x', '+', coef(model)[[1]])

Trendline in GraphView?
By : luo dao
Date : March 29 2020, 07:55 AM
this one helps. Is there a way in GraphView to graph and find the equation of a linear trendline that represents the data points on a line graph? , There is no trendline in GraphView (at least from what I know of).

