Forum Discussion
Excel LINEST
I have a dot-plot graph with 9 dots and two trendlines. Each trendline has an equation and r^2. I was wanting to find the LINEST for each of the trendlines. The picture below is an example of how someone else did it
1 Reply
The first result is obtained by the formula =LINEST(y-values,x-values,TRUE,TRUE)
The second result is obtained by the formula =LINEST(y-values,x-values,FALSE,TRUE)
