Circulation: Use Regression Analysis to Optimize Catalog Circ and Sales Data

But, if on the West Coast chart you find it would be more difficult to force a line through the points while being close to any of them, your discount offer may not be boosting sales as you suspected.

Next, highlight the appropriate columns in the number charts and run the linear regression program according to the routine used by your spreadsheet program. (Using my favorite spreadsheet, this process takes only four or so mouseclicks.) Analyze the data that’s generated.