Tuesday, January 6, 2009

SPSS for Intermediate Statistics or Advanced Excel for Scientific Data Analysis

SPSS for Intermediate Statistics: Use and Interpretation

Author: Nancy L Leech

This book demonstrates how to analyze and interpret research data with SPSS 15.0 through a variety of statistics reviewed in intermediate statistics courses. The new edition features SPSS 15.0 but it can also be used with earlier versions. Each chapter introduces several statistics and explains how to run them and interpret the outputs. Featuring user-friendly descriptions, the book reviews how to assess the reliability and validity of data. The authors demonstrate how to: choose the appropriate statistic based on the research design; use SPSS to answer research questions; and interpret and write about SPSS outputs. The examples use real data and are contained on the book's CD. Outputs, screen shots, and lab assignments complete the package. This inexpensive paperback is an ideal supplement for courses on intermediate/advanced statistics and/or research methods.

Go to: Boots on the Ground or The SWAT Workout

Advanced Excel for Scientific Data Analysis

Author: Robert De Levi

Combining an easy-going style with an emphasis on practical applications, this greatly expanded second edition is remarkable in scope and coverage. As reviews of the first edition noted, the term "advanced" in the title is not used lightly. Less than a third of its 700+ pages are devoted to least squares analysis, yet the reader will learn about many aspects of this ubiquitous method that are seldom found together in one volume: multivariate and polynomial centering, the statistical uncertainty in uncertainty estimates, how to use the covariance, singular value decomposition, the pros and cons of weighted least squares, moving equidistant least squares, nonlinear least squares, and imprecision contours.
There are lucid chapters on Fourier transformation, convolution and deconvolution, and digital simulation of ordinary differential equations. A new chapter is devoted to some common but often only crudely used mathematical methods, such as numerical differentiation, Romberg integration, and cubic spline interpolation. Another new chapter shows how to use linear algebra on the spreadsheet with Volpi's extensive matrix toolbox of custom functions and macros. A third, newly added chapter describes how to set up the spreadsheet to make it less error-prone, and how to get superaccurate answers in Excel. The substantially enlarged chapter on writing functions and macros now has a set of MacroMorsels to illustrate specific points that otherwise might trip up novice programmers, and a detailed description of Excel's extensive debugging tools. All this is presented in an easily digestible format, illustrated with many examples from the literature, and supported by a large collection ofopen-access (i.e., fully transparent and user-modifiable) custom functions and macros.

Table of Contents:

1 Survey of Excel 3

2 Simple linear least squares 70

3 Further linear least squares 116

4 Nonlinear least squares 177

5 Fourier transformation 257

6 Convolution, deconvolution & time-frequency analysis 307

7 Numerical integration of ordinary differential equations 365

8 Write your own macros 403

9 Some mathematical operations 482

10 Matrix operations 551

11 Spreadsheet reliability 605

A Some aspects of Excel 648

B Some details of Matrix.xla 656

C MacroBundles & MacroMorsels 672

D Transitioning to Excel 2007 681

Author Index 695

Subject Index 698

No comments:

Post a Comment