R²

Simple regression in Excel without fooling yourself

For managers with an Excel sheet of ad spend and revenue who are about to report what one more million of advertising adds. Which function gives which number, how to read R² and the standard error, and three traps that keep a high R² wrong: a curve, one distant point, a slope that is not a cause.