Data Analysis, Optimization and Simulation Modeling [with CD]

by S. Christian Albright

Key Features All updated screenshots and accompanying explanations to reflect Excel 2007 and updated add-ins. Tips on Excel 2010 have been added where applicable. This edition now provides access to Excel add-in software via an access code to a Premium Online Content Website for every student purchasing a new book. Chapters 2 and 3 are completely rewritten and reorganized, focusing on the description of one variable at a time, and relationships between variables. Both chapters have more coverage of categorical variables, as well as new and more interesting data sets in the examples. Many of the problems in previous editions were deleted or updated, and a number of brand new problems were added for relevance to current statistical analysis. A problem guide is available to instructors showing the context of each of the "data" problems, and it also shows the correspondence between problems in this edition and problems in the previous edition. The previous edition''s Chapter 4 is renamed as Chapter 17, Importing Data into Excel, and is completely rewritten with its section on Excel tables located in Chapter 2. (Previous edition chapters 5-17 were renumbered 4-16.) The book is still based on Excel 2007, but notes about changes in Excel 2010 have been added where it applies. Specifically, there is a small section on the new slicers for pivot tables, and there are several mentions of the new statistical functions (although the old functions still work). Each chapter now has 10-20 more consistent and relevant "Conceptual Questions" in the end-of-chapter sections. The first two LP examples in Chapter 13 (replacing the former Chapter 14) are replaced by two product mix models, where the second builds on the first. The previous "diet" model was overly complex as a first LP example. Several chapter-opening vignettes are replaced with newer and more interesting ones and there are now many short "fundamental insights" throughout the chapters. These insights are designed to allo

Paperback

Published January 1, 2012