Excel LINEST

Occasional Visitor

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

@martyball00 

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)