Differences

This shows you the differences between two versions of the page.

--- tutorials:regression_excel [2022/06/21 12:00] – created chkuo
+++ tutorials:regression_excel [2022/06/21 12:00] (current) – chkuo
@@ Line 1: / Line 1: @@
 ====== Regression analysis in Excel ======
-Excel is not a program designed for statistical analysis, although it comes in handy when all you want to do is some quick and dirty analyses (I'm guilty of this as well). However, you should be cautious about the results, as some can be simply wrong. Here is one problem from my experience with Office 2008 for Mac.
+Excel is not a program designed for statistical analysis, although it comes in handy when all you want to do is some quick and dirty analyses. However, you should be cautious about the results, as some can be simply wrong. Here is one problem from my experience with Office 2008 for Mac.
 When doing exponential regression, Excel calculates the R-squared value based on transformed data. For example, for a exponential curve ''y = a * e<sup>bx</sup>'', Excel computes R<sup>2</sup> using ''ln(y) = ln(a) + bx''. Needless to say, this can cause some unwanted surprises. With some quick google searches, you can easily find more problems.