Correlation coefficient in Trendline

%3CLINGO-SUB%20id%3D%22lingo-sub-2506044%22%20slang%3D%22de-DE%22%3ECorrelation%20coefficient%20in%20Trendline%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2506044%22%20slang%3D%22de-DE%22%3E%3CP%3EHello%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20question%20regarding%20the%20coefficient%20of%20determination%20that%20can%20be%20displayed%20with%20the%20trend%20lines.%20I%20think%20I%20found%20the%20equation%20to%20calculate%20this%20coefficient%20(see%20picture).%20This%20equation%20is%20called%20general%20empirical%20correlation%20coefficient%20and%20can%20be%20found%20like%20this%20on%20the%20English%20Wikipedia%20page%20about%20correlation%20coefficient.%20I%20compared%20the%20coefficient%20of%20determination%20by%20hand%20with%20some%20test%20data%20sets.%20The%20equation%20seems%20to%20be%20correct.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20my%20two%20questions%3A%20%3CBR%20%2F%3E%201)%20Is%20the%20equation%20really%20the%20correct%20one%20(which%20is%20used%20by%20Excel)%3F%20%3CBR%20%2F%3E%202)%20Is%20there%20a%20scientific%20book%20where%20I%20can%20find%20this%20equation%20as%20well%20(Wikipedia%20is%20not%20a%20source%20for%20scientific%20papers)%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20kind%20regards%3C%2FP%3E%3CP%3EMarcel%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESystem%3A%20Windows%2010%3B%20Excel%202013%20(but%20not%20relevant)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWiki%20link%3A%20%3CA%20href%3D%22https%3A%2F%2Fde.wikipedia.org%2Fwiki%2FKorrelationskoeffizient%23Allgemeiner_empirischer_Korrelationskoeffizient%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fde.wikipedia.org%2Fwiki%2FKorrelationskoeffizient%23Allgemeiner_empirischer_Korrelationskoeffizient%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEquation%20(from%20Wiki)%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22motorsportmarcel_0-1625129061097.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F292846i09FAB986AFF26E40%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22motorsportmarcel_0-1625129061097.png%22%20alt%3D%22motorsportmarcel_0-1625129061097.png%22%20%2F%3E%3C%2FSPAN%3E%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-2506044%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2515945%22%20slang%3D%22en-US%22%3ERe%3A%20Correlation%20coefficient%20in%20Trendline%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2515945%22%20slang%3D%22en-US%22%3EI%20would%20say%20any%20proper%20textbook%20on%20statistics%20would%20contain%20this%20formula.%20Visit%20your%20library.%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello all,

 

I have a question regarding the coefficient of determination that can be displayed with the trend lines. I think I found the equation to calculate this coefficient (see picture). This equation is called general empirical correlation coefficient and can be found like this on the German Wikipedia page about correlation coefficient. I compared the coefficient of determination by hand with some test data sets. The equation seems to be correct.

 

Now my two questions:
1) Is the equation really the correct one (which is used by Excel)?
2) Is there a scientific book where I can find this equation as well (Wikipedia is not a source for scientific papers)?

 

With kind regards

Marcel

 

System: Windows 10; Excel 2013 (but not relevant)

 

Wiki-Link: https://de.wikipedia.org/wiki/Korrelationskoeffizient#Allgemeiner_empirischer_Korrelationskoeffizien...

 

 

Equation (from Wiki):

motorsportmarcel_0-1625129061097.png

 

 

1 Reply
I would say any proper textbook on statistics would contain this formula. Visit your library.