Excel LINEST

%3CLINGO-SUB%20id%3D%22lingo-sub-2231268%22%20slang%3D%22en-US%22%3EExcel%20LINEST%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2231268%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20dot-plot%20graph%20with%209%20dots%20and%20two%20trendlines.%20Each%20trendline%20has%20an%20equation%20and%20r%5E2.%20I%20was%20wanting%20to%20find%20the%20LINEST%20for%20each%20of%20the%20trendlines.%20The%20picture%20below%20is%20an%20example%20of%20how%20someone%20else%20did%20it%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2231268%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2231844%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20LINEST%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2231844%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1006594%22%20target%3D%22_blank%22%3E%40martyball00%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20first%20result%20is%20obtained%20by%20the%20formula%20%3DLINEST(y-values%2Cx-values%2CTRUE%2CTRUE)%3C%2FP%3E%0A%3CP%3EThe%20second%20result%20is%20obtained%20by%20the%20formula%20%3DLINEST(y-values%2Cx-values%2CFALSE%2CTRUE)%3C%2FP%3E%3C%2FLINGO-BODY%3E
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)