You are here: Home Users Mike Renfro ME2001 - Elementary Mechanical Engineering Analysis Lec. 14 Addendum: How Excel's R^2 Value Can Lie To You

Lec. 14 Addendum: How Excel's R^2 Value Can Lie To You

Two examples of abusing Excel's least-squares curve fitting features. Just because R^2 is nearly or exactly 1.0 doesn't mean you found the function that drives your data!

trendlines.xls — Excel spreadsheet, 18 kB (18432 bytes)