Mar 23 2021 04:26 PM
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
Mar 24 2021 01:19 AM
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)