Spreadsheet Models for Statistics: Over 200 Models

Microsoft Excel is one of the most widely used software applications in business, particularly for data analysis, financial modeling, and statistical calculations. But most statistical textbooks ignore Excel, or include a few token pages, almost as a reluctant afterthought. Graduates then enter the real world and discover they are expected to be proficient with Excel to analyze and present data and to make decisions. Spreadsheet Models for Statistics includes over 200 dynamic models for common statistical operations, complete with formulas and detailed explanations of the logic behind each model. To ensure clarity, the data within this book is intentionally designed to isolate and illustrate key statistical concepts, removing the “noise” often found in real-world data. By using purposefully designed data, we reveal the core relationships between statistical measures, making complex concepts easier to grasp. “What-if” changes in the data, the hypothesis, or the level of significance are instantly apparent in the results. Spreadsheet Models for Statistics is not a replacement for a traditional statistics textbook; it is a supplement. All of the common statistical tests and procedures are included, with step-by-step instructions for performing them in Excel. It was written to bridge the gap between statistics books and Excel books. The chapter sequence is the same as used in popular statistics textbooks. Each chapter concludes with a set of review problems, with detailed explanations of the correct answers at the back of the book. The review data sets may also be downloaded from the companion web site. Common statistical tables are included in the book, but they are also available for download at the companion site. Calculated tables include the Excel formulas behind the calculations, and instructions are provided to automatically retrieve table values using Excel functions.