Forum Discussion
martyball00
Mar 23, 2021Copper Contributor
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 som...
HansVogelaar
Mar 24, 2021MVP
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)