The Art of Data Analysis. How to Answer Almost Any Question Using Basic Statistics

A practical guide to data mining using SQL and Excel Data Analysis Using SQL and Excel, 2nd Edition shows you how to leverage the two most popular tools for data query and analysis—SQL and Excel—to perform sophisticated data analysis without the need for complex and expensive data mining tools. Written by a leading expert on business data mining, this book shows you how to extract useful business information from relational databases. You'll learn the fundamental techniques before moving into the «where» and «why» of each analysis, and then learn how to design and perform these analyses using SQL and Excel. Examples include SQL and Excel code, and the appendix shows how non-standard constructs are implemented in other major databases, including Oracle and IBM DB2/UDB. The companion website includes datasets and Excel spreadsheets, and the book provides hints, warnings, and technical asides to help you every step of the way. Data Analysis Using SQL and Excel, 2nd Edition shows you how to perform a wide range of sophisticated analyses using these simple tools, sparing you the significant expense of proprietary data mining tools like SAS. Understand core analytic techniques that work with SQL and Excel Ensure your analytic approach gets you the results you need Design and perform your analysis using SQL and Excel Data Analysis Using SQL and Excel, 2nd Edition shows you how to best use the tools you already know to achieve expert results.

Written for biologists and medical researchers who don't have any special training in data analysis and statistics, Guide to Analysis of DNA Microarray Data, Second Edition begins where DNA array equipment leaves off: the image produced by the microarray. The text deals with the questions that arise starting at this point, providing an introduction to microarray technology, then moving on to image analysis, data analysis, cluster analysis, and beyond. With all chapters rewritten, updated, and expanded to include the latest generation of technology and methods, Guide to Analysis of DNA Microarray Data, Second Edition offers practitioners reliable information using concrete examples and a clear, comprehensible style. This Second Edition features entirely new chapters on: * Image analysis * Experiment design * Automated analysis, integrated analysis, and systems biology * Interpretation of results Intended for readers seeking practical applications, this text covers a broad spectrum of proven approaches in this rapidly growing technology. Additional features include further reading suggestions for each chapter, as well as a thorough review of available analysis software.

Dive deeper into SPSS Statistics for more efficient, accurate, and sophisticated data analysis and visualization SPSS Statistics for Data Analysis and Visualization goes beyond the basics of SPSS Statistics to show you advanced techniques that exploit the full capabilities of SPSS. The authors explain when and why to use each technique, and then walk you through the execution with a pragmatic, nuts and bolts example. Coverage includes extensive, in-depth discussion of advanced statistical techniques, data visualization, predictive analytics, and SPSS programming, including automation and integration with other languages like R and Python. You'll learn the best methods to power through an analysis, with more efficient, elegant, and accurate code. IBM SPSS Statistics is complex: true mastery requires a deep understanding of statistical theory, the user interface, and programming. Most users don't encounter all of the methods SPSS offers, leaving many little-known modules undiscovered. This book walks you through tools you may have never noticed, and shows you how they can be used to streamline your workflow and enable you to produce more accurate results. Conduct a more efficient and accurate analysis Display complex relationships and create better visualizations Model complex interactions and master predictive analytics Integrate R and Python with SPSS Statistics for more efficient, more powerful code These «hidden tools» can help you produce charts that simply wouldn't be possible any other way, and the support for other programming languages gives you better options for solving complex problems. If you're ready to take advantage of everything this powerful software package has to offer, SPSS Statistics for Data Analysis and Visualization is the expert-led training you need.

A thorough treatment of the statistical methods used to analyze doubly truncated data In The Statistical Analysis of Doubly Truncated Data, an expert team of statisticians delivers an up-to-date review of existing methods used to deal with randomly truncated data, with a focus on the challenging problem of random double truncation. The authors comprehensively introduce doubly truncated data before moving on to discussions of the latest developments in the field. The book offers readers examples with R code along with real data from astronomy, engineering, and the biomedical sciences to illustrate and highlight the methods described within. Linear regression models for doubly truncated responses are provided and the influence of the bandwidth in the performance of kernel-type estimators, as well as guidelines for the selection of the smoothing parameter, are explored. Fully nonparametric and semiparametric estimators are explored and illustrated with real data. R code for reproducing the data examples is also provided. The book also offers: A thorough introduction to the existing methods that deal with randomly truncated data Comprehensive explorations of linear regression models for doubly truncated responses Practical discussions of the influence of bandwidth in the performance of kernel-type estimators and guidelines for the selection of the smoothing parameter In-depth examinations of nonparametric and semiparametric estimators Perfect for statistical professionals with some background in mathematical statistics, biostatisticians, and mathematicians with an interest in survival analysis and epidemiology, The Statistical Analysis of Doubly Truncated Data is also an invaluable addition to the libraries of biomedical scientists and practitioners, as well as postgraduate students studying survival analysis.

A great introductory book that details reliable approaches to problems met in standard microarray data analyses. It provides examples of established approaches such as cluster analysis, function prediction, and principle component analysis. Discover real examples to illustrate the key concepts of data analysis. Written for those without any advanced background in math, statistics, or computer sciences, this book is essential for anyone interested in harnessing the immense potential of microarrays in biology and medicine.

Statistics Analysis of Geographical Data: An Introduction provides a comprehensive and accessible introduction to the theory and practice of statistical analysis in geography. It covers a wide range of topics including graphical and numerical description of datasets, probability, calculation of confidence intervals, hypothesis testing, collection and analysis of data using analysis of variance and linear regression. Taking a clear and logical approach, this book examines real problems with real data from the geographical literature in order to illustrate the important role that statistics play in geographical investigations. Presented in a clear and accessible manner the book includes recent, relevant examples, designed to enhance the reader’s understanding.

This book is the definitive guide to cash flow statement analysis and forecasting. It takes the reader from an introduction about how cash flows move within a business, through to a detailed review of the contents of a cash flow statement. This is followed by detailed guidance on how to restate cash flows into a template format. The book shows how to use the template to analyse the data from start up, growth, mature and declining companies, and those using US GAAP and IAS reporting. The book includes real world examples from such companies as Black and Decker (US), Fiat (Italy) and Tesco (UK). A section on cash flow forecasting includes full coverage of spreadsheet risk and good practice. Complete with chapters of particular interest to those involved in credit markets as lenders or counter-parties, those running businesses and those in equity investing, this book is the definitive guide to understanding and interpreting cash flow data.

Effective data presentation is an essential skill for anybody wishing to display or publish research results, but when done badly, it can convey a misleading or confusing message. This new addition to the popular “How to” series explains how to present data in journal articles, grant applications or research presentations clearly, accurately and logically, increasing the chances of successful publication.

Praise for the First Edition “…a well-written book on data analysis and data mining that provides an excellent foundation…” —CHOICE “This is a must-read book for learning practical statistics and data analysis…” —Computing Reviews.com A proven go-to guide for data analysis, Making Sense of Data I: A Practical Guide to Exploratory Data Analysis and Data Mining, Second Edition focuses on basic data analysis approaches that are necessary to make timely and accurate decisions in a diverse range of projects. Based on the authors’ practical experience in implementing data analysis and data mining, the new edition provides clear explanations that guide readers from almost every field of study. In order to facilitate the needed steps when handling a data analysis or data mining project, a step-by-step approach aids professionals in carefully analyzing data and implementing results, leading to the development of smarter business decisions. The tools to summarize and interpret data in order to master data analysis are integrated throughout, and the Second Edition also features: Updated exercises for both manual and computer-aided implementation with accompanying worked examples New appendices with coverage on the freely available Traceis™ software, including tutorials using data from a variety of disciplines such as the social sciences, engineering, and finance New topical coverage on multiple linear regression and logistic regression to provide a range of widely used and transparent approaches Additional real-world examples of data preparation to establish a practical background for making decisions from data Making Sense of Data I: A Practical Guide to Exploratory Data Analysis and Data Mining, Second Edition is an excellent reference for researchers and professionals who need to achieve effective decision making from data. The Second Edition is also an ideal textbook for undergraduate and graduate-level courses in data analysis and data mining and is appropriate for cross-disciplinary courses found within computer science and engineering departments.

A complete guide to carrying out complex survey analysis using R As survey analysis continues to serve as a core component of sociological research, researchers are increasingly relying upon data gathered from complex surveys to carry out traditional analyses. Complex Surveys is a practical guide to the analysis of this kind of data using R, the freely available and downloadable statistical programming language. As creator of the specific survey package for R, the author provides the ultimate presentation of how to successfully use the software for analyzing data from complex surveys while also utilizing the most current data from health and social sciences studies to demonstrate the application of survey research methods in these fields. The book begins with coverage of basic tools and topics within survey analysis such as simple and stratified sampling, cluster sampling, linear regression, and categorical data regression. Subsequent chapters delve into more technical aspects of complex survey analysis, including post-stratification, two-phase sampling, missing data, and causal inference. Throughout the book, an emphasis is placed on graphics, regression modeling, and two-phase designs. In addition, the author supplies a unique discussion of epidemiological two-phase designs as well as probability-weighting for causal inference. All of the book's examples and figures are generated using R, and a related Web site provides the R code that allows readers to reproduce the presented content. Each chapter concludes with exercises that vary in level of complexity, and detailed appendices outline additional mathematical and computational descriptions to assist readers with comparing results from various software systems. Complex Surveys is an excellent book for courses on sampling and complex surveys at the upper-undergraduate and graduate levels. It is also a practical reference guide for applied statisticians and practitioners in the social and health sciences who use statistics in their everyday work.