Data Analysis, Optimization, and Simulation Modeling (Data Analysis, Optimization, and Simulation Modeling)

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.