Master data analysis, modeling, and spreadsheet use with DATA ANALYSIS AND DECISION MAKING WITH MICROSOFT EXCEL! With a teach-by-example approach,... student-friendly writing style, and complete Excel integration, this quantitative methods text provides you with the tools you need to succeed. Margin notes, boxed-in definitions and formulas in the text, enhanced explanations in the text itself, and stated objectives for the examples found throughout the text make studying easy. Problem sets and cases provide realistic examples that enable you to see the relevance of the material to your future as a business leader. The CD-ROMs packaged with every new book include the following add-ins: the Palisade Decision Tools Suite (@RISK, StatTools, PrecisionTree, TopRank, and RISKOptimizer); and SolverTable, which allows you to do sensitivity analysis. All of these add-ins have been revised for Excel 2007.

DATA ANALYSIS AND DECISION MAKING is a teach-by-example approach, learner-friendly writing style, and complete Excel integration focusing on data... analysis, modeling, and spreadsheet use in statistics and management science. The Premium Online Content Website (accessed by a unique code with every new book) includes links to the following add-ins: the Palisade Decision Tools Suite (@RISK, StatTools, PrecisionTree, TopRank, RISKOptimizer, NeuralTools, and Evolver); and SolverTable, allowing users to do sensitivity analysis. All of the add-ins is revised for Excel 2007 and notes about Excel 2010 are added where applicable. About This Edition New Features 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 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 they apply. 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 linear programming 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 linear programming 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 allow the students to step back from the details and see the really important ideas. 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. Instructors' Resource CD: PowerPoints, and Solutions, Case, and Example files have been updated to reflect the core text 4th edition. The Test Bank has been updated with new questions and is now offered in ExamView testing software.

Discover what you can do with R! Introducing the R system, covering standard regression methods, then tackling more advanced topics, this book guides... users through the practical, powerful tools that the R system provides. The emphasis is on hands-on analysis, graphical display, and interpretation of data. The many worked examples, from real-world research, are accompanied by commentary on what is done and why. The companion website has code and datasets, allowing readers to reproduce all analyses, along with solutions to selected exercises and updates. Assuming basic statistical knowledge and some experience with data analysis (but not R), the book is ideal for research scientists, final-year undergraduate or graduate-level students of applied statistics, and practicing statisticians. It is both for learning and for reference. This third edition expands upon topics such as Bayesian inference for regression, errors in variables, generalized linear mixed models, and random forests.

Part of a project funded by the National Science Foundation to improve the quality of mathematics and science teaching in grades K-12, this new guide... models the student-centered approach recommended by the National Council of Teachers of Mathematics to teach introductory statistics. Provides future middle grade mathematics teachers with a strong foundation, connecting the mathematics they are learning with the mathematics they will be teaching. Gives enhanced meaning to formulas via a visual or geometric approach. Uses numerous illustrations to assist readers in making explicit connections between a typical college elementary statistics course and the statistical concepts taught by middle school teachers. For anyone interested in introductory statistics.

A comprehensive and up-to-date introduction to the fundamentals of regression analysisThe Fourth Edition of Introduction to Linear Regression Analysis... describes both the conventional and less common uses of linear regression in the practical context of today's mathematical and scientific research. This popular book blends both theory and application to equip the reader with an understanding of the basic principles necessary to apply regression model-building techniques in a wide variety of application environments. It assumes a working knowledge of basic statistics and a familiarity with hypothesis testing and confidence intervals, as well as the normal, t, x2, and F distributions.Illustrating all of the major procedures employed by the contemporary software packages MINITAB(r), SAS(r), and S-PLUS(r), the Fourth Edition begins with a general introduction to regression modeling, including typical applications. A host of technical tools are outlined, such as basic inference procedures, introductory aspects of model adequacy checking, and polynomial regression models and their variations. The book discusses how transformations and weighted least squares can be used to resolve problems of model inadequacy and also how to deal with influential observations. Subsequent chapters discuss:* Indicator variables and the connection between regression and analysis-of-variance models* Variable selection and model-building techniques and strategies* The multicollinearity problem--its sources, effects, diagnostics, and remedial measures* Robust regression techniques such as M-estimators, and properties of robust estimators* The basics of nonlinear regression* Generalized linear models* Using SAS(r) for regression problemsThis book is a robust resource that offers solid methodology for statistical practitioners and professionals in the fields of engineering, physical and chemical sciences, economics, management, life and biological sciences, and the social sciences. Both the accompanying FTP site, which contains data sets, extensive problem solutions, software hints, and PowerPoint(r) slides, as well as the book's revised presentation of topics in increasing order of complexity, facilitate its use in a classroom setting.With its new exercises and structure, this book is highly recommended for upper-undergraduate and beginning graduate students in mathematics, engineering, and natural sciences. Scientists and engineers will find the book to be an excellent choice for reference and self-study.

This accessible introduction to data analysis focuses on the interpretation of statistical results, in particular those which come from nonexperimental... social research. It will provide social science researchers with the tools necessary to select and evaluate statistical tests appropriate for their research question. Using a consistent data-set throughout the book to illustrate the various analytic techniques, Michael Lewis-Beck covers topics such as univariate statistics, measures of association, the statistical significance of the relationship between two variables, simple regression in which the dependent variable is influenced by a single independent variable, and multiple regression.

Data Analysis for Research Designs covers the analytical techniques for the analysis of variance (ANOVA) and multiple regression/correlation (MRC),... emphasizing single-degree-of-freedom comparisons so that students focus on clear research planning. This text is designed for advanced undergraduates and graduate students of the behavioral and social sciences who have an understanding of algebra and statistics.

This book provides readers with an understanding of the important considerations directly related to analyzing various forms of data - both... qualitative and quantitative. While practice problems are included so that readers can self-test their knowledge of major concepts, the book does not drown its readers in page after page of problem sets and tedious calculations. The numerous practice examples of concepts, and the engaging, conversational writing style will be appealing and effective for many types of learners. For anyone with an interest in introductory statistics as it relates to social work.

Data Analysis Methods in Physical Oceanography is a practical referenceguide to established and modern data analysis techniques in earth and... oceansciences. This second and revised edition is even more comprehensive with numerous updates, and an additional appendix on 'Convolution and Fourier transforms'. Intended for both students and established scientists, the fivemajor chapters of the book cover data acquisition and recording, dataprocessing and presentation, statistical methods and error handling,analysis of spatial data fields, and time series analysis methods. Chapter 5on time series analysis is a book in itself, spanning a wide diversity oftopics from stochastic processes and stationarity, coherence functions,Fourier analysis, tidal harmonic analysis, spectral and cross-spectralanalysis, wavelet and other related methods for processing nonstationarydata series, digital filters, and fractals. The seven appendices includeunit conversions, approximation methods and nondimensional numbers used ingeophysical fluid dynamics, presentations on convolution, statisticalterminology, and distribution functions, and a number of importantstatistical tables. Twenty pages are devoted to references.Featuring: • An in-depth presentation of modern techniques for the analysis of temporal and spatial data sets collected in oceanography, geophysics, and other disciplines in earth and ocean sciences. • A detailed overview of oceanographic instrumentation and sensors - old and new - used to collect oceanographic data. • 7 appendices especially applicable to earth and ocean sciences ranging from conversion of units, through statistical tables, to terminology and non-dimensional parameters.In praise of the first edition: "(...)This is a very practical guide to the various statistical analysis methods used for obtaining information from geophysical data, with particular reference to oceanography(...) The book provides both a text for advanced students of the geophysical sciences and a useful reference volume for researchers." Aslib Book Guide Vol 63, No. 9, 1998"(...)This is an excellent book that I recommend highly and will definitely use for my own research and teaching." EOS Transactions, D.A. Jay, 1999"(...)In summary, this book is the most comprehensive and practical source of information on data analysis methods available to the physical oceanographer. The reader gets the benefit of extremely broad coverage and an excellent set of examples drawn from geographical observations." Oceanography, Vol. 12, No. 3, A. Plueddemann, 1999"(...)Data Analysis Methods in Physical Oceanography is highly recommended for a wide range of readers, from the relative novice to the experienced researcher. It would be appropriate for academic and special libraries." E-Streams, Vol. 2, No. 8, P. Mofjelf, August 1999

Spreadsheet skills are important for a first job, and DATA ANALYSIS USING MICROSOFT EXCEL prepares students to enter the world of work with stronger... spreadsheet skills. Designed as a supplement to a main statistics text or as a reference for professionals, this handbook helps students build their proficiency in Microsoft Excel and shows them how to use the built-in capabilities of Excel to analyze data and make decisions. Although many of the examples are business oriented, the step-by-step approach makes this book appropriate for statistical analysis in other courses and academic disciplines.

Data Analysis Using Regression and Multilevel/Hierarchical Models is a comprehensive manual for the applied researcher who wants to perform data... analysis using linear and nonlinear regression and multilevel models. The book introduces a wide variety of models, whilst at the same time instructing the reader in how to fit these models using available software packages. The book illustrates the concepts by working through scores of real data examples that have arisen from the authors' own applied research, with programming codes provided for each one. Topics covered include causal inference, including regression, poststratification, matching, regression discontinuity, and instrumental variables, as well as multilevel logistic regression and missing-data imputation. Practical tips regarding building, fitting, and understanding are provided throughout. Author resource page: http://www.stat.columbia.edu/~gelman/arm/

Data Analysis Using SAS offers a comprehensive core text focused on key concepts and techniques in quantitative data analysis using the most current... SAS commands and programming language. The coverage of the text is more evenly balanced among statistical analysis, SAS programming, and data/file management than any available text on the market. It provides students with a hands-on, exercise-heavy method for learning basic to intermediate SAS commands while understanding how to apply statistics and reasoning to real-world problems. Designed to be used in order of teaching preference by instructor, the book is comprised of two primary sections: the first half of the text instructs students in techniques for data and file managements such as concatenating and merging files, conditional or repetitive processing of variables, and observations. The second half of the text goes into great depth on the most common statistical techniques and concepts - descriptive statistics, correlation, analysis of variance, and regression - used to analyze data in the social, behavioral, and health sciences using SAS commands. A student study at www.sagepub.com/pengstudy comes replete with a multitude of computer programs, their output, specific details on how to check assumptions, as well as all data sets used in the book. Data Analysis Using SAS is a complete resource for Data Analysis I and II, Statistics I and II, Quantitative Reasoning, and SAS Programming courses across the social and behavioral sciences and health - especially those that carry a lab component.

Useful business analysis requires you to effectively transform data into actionable information. This book helps you use SQL and Excel to extract... business information from relational databases and use that data to define business dimensions, store transactions about customers, produce results, and more. Each chapter explains when and why to perform a particular type of business analysis in order to obtain useful results, how to design and perform the analysis using SQL and Excel, and what the results should look like.