Forum Discussion
Difference in calculated (logarithmic) R^2 (Excel)
Hi, When I plot a scatter diagram and add a logarithmic trend line, I get a R^2-value of 0,9596. I was told to convert all data by using log10 and to run linear regression on these values as well...
Max_B00 wrote: ``Can somebody tell me what went wrong (or what I did wrong)?``
Probably not without details. To paraphrase Uncle Ben's advice to Spider-Man: "With great details comes great answers". (wink)
Attach an Excel file that duplicates the problem, or provide a download link to the Excel file. If the forum does not permit you to post a bona fide URL, spell out part of it. For example, the link to this discussion is techcommunity dot microsoft dot com /t5/excel/difference-in-calculated-logarithmic-r-2-excel/m-p/3789518#M187659 .