Stepwise Regression for Excel

Click here to download the free stepwise regression software that can be used with the business statistics textbook below. You are also free to use it with any other textbook if you let me know by writing to me at pekoz at bu dot edu. The file is an ordinary Excel workbook that can be opened and the data pasted into it, and it can run stepwise regression. Nothing needs to be installed and it works on any version of Windows or the Mac. It does not use macros so virus security settings will not impact the worksheet. In the folder above you will find a file titled “stepwise regression demo” that contains instructions and a video demonstrating how it works. I hope you like it.

The Manager's Guide to Statistics (2014 Edition) is an introduction to statistics for aspiring managers, leaders and decision makers who do not need to know all the details of statistical theory and just want real applications and commonsense explanations using words and diagrams -- without a jumble of Greek letters and mathematical formulas. The focus is on teaching and testing intuitive understanding of statistical concepts with applications. This textbook is for an undergraduate or MBA introductory statistics course and covers summary statistics, probability, hypothesis testing, correlation, multiple regression, and includes custom Excel tools for histograms and stepwise regression. You may download the data sets mentioned in the book or the free stepwise regression software. You may also download an excerpt or read a book review from the American Statistician. If you are an instructor you can request an evaluation copy and detailed problem solutions by sending an email with your address to pekoz at bu dot edu.