Skip to content

Data Analysis with Spreadsheets

ISBN-10: 020540751X

ISBN-13: 9780205407514

Edition: 2006

Authors: David A. Patterson, Randall E. Basham

List price: $90.80
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!


The first book and CD-ROM to use text, video and graphs to clearly describe and illustrate how social workers can use spreadsheets to collect data, analyze statistics and create graphs of research results. Students and instructors will find this an excellent guide to taking advantage of spreadsheet softwarean underutilized, inexpensive and commonly available data analysis tool found in most, if not all, agency settings. This text and CD-ROM offer instructors clearly articulated descriptions and video demonstrations of data analysis procedures that are commonly referred to in research and practice evaluation texts.
Customers also bought

Book details

List price: $90.80
Copyright year: 2006
Publisher: Allyn & Bacon, Incorporated
Publication date: 4/11/2005
Binding: Mixed Media
Pages: 208
Size: 8.25" wide x 10.75" long x 0.75" tall
Weight: 1.144
Language: English

David A. Patterson was the first in his family to graduate from college (1969 A.B UCLA), and he enjoyed it so much that he didn't stop until a PhD, (1976 UCLA). After 4 years developing a wafer-scale computer at Hughes Aircraft, he joined U.C. Berkeley in 1977. He spent 1979 at DEC working on the VAX minicomputer. He and colleagues later developed the Reduced Instruction Set Computer (RISC). By joining forces with IBM's 801 and Stanford's MIPS projects, RISC became widespread. In 1984 Sun Microsystems recruited him to start the SPARC architecture. In 1987, Patterson and colleagues wondered if tried building dependable storage systems from the new PC disks. This led to the popular Redundant Array of Inexpensive Disks (RAID). He spent 1989 working on the CM-5 supercomputer. Patterson and colleagues later tried building a supercomputer using standard desktop computers and switches. The resulting Network of Workstations (NOW) project led to cluster technology used by many startups. He is now working on the Recovery Oriented Computing (ROC) project. In the past, he served as Chair of Berkeley's CS Division, Chair and CRA. He is currently serving on the IT advisory committee to the U.S. President and has just been elected President of the ACM. All this resulted in 150 papers, 5 books, and the following honors, some shared with friends: election to the National Academy of Engineering; from the University of California: Outstanding Alumnus Award (UCLA Computer Science Department), McEntyre Award for Excellence in Teaching (Berkeley Computer Science), Distinguished Teaching Award (Berkeley); from ACM: fellow, SIGMOD Test of Time Award, Karlstrom Outstanding Educator Award; from IEEE: fellow, Johnson Information Storage Award, Undergraduate Teaching Award, Mulligan Education Medal, and von Neumann Medal.

Each chapter concludes with Chapter Summary and References
An Introduction to Spreadsheets
Spreadsheets First Facts
The Brief History of Spreadsheets
Why Use Spreadsheets for Data Analysis in the Social Services?
Spreadsheet Basics
Using Formulas and Functions
Advanced Tools for Understanding Data
A Comparison of Spreadsheets to Statistical Analysis Software
The Paradox of Spreadsheets and Statistical Software in Social Service Practice
Data Collections Waysand Means
The Many Paths to Data Acquisition
Levels of Measurement
Data Coding
Basic Data Entry
Creating Data Entry Forms
Downloading Data
Web-Based Data Retrieval
Relating to Database Software
Web-based Data Collection
Relating to Database Software
Saving What You Have and Using What You Need
Selecting Samples
Samples: First Facts
Simple Random Samples
Systematic Sampling
Stratified Sampling
Random Assignment
Data Cleaning
Types of Problem Data
Detecting Data Errors
Contingency Cleaning
Missing Data: Its Detection and Handling
Detecting Missing Data
Handling Missing Data
Frequency Distributions and Histograms
Understanding the Distribution of Values
Frequency Distributions
Producing Histograms Using the Chart Wizard
Descriptive Statistics
Measures of Central Tendency
Formulas for Measures of Central Tendency
Measures of Dispersion or Variability
Data Analysis Tools: Descriptive Statistics
Producing Frequency Polygrams
Statistical Inference and Hypothesis Testing
Normal Distributions
Probability Distributions
Understanding Hypothesis Testing
Statistical Significance
Effect Size and Sample Size Estimation
Bivariate Statistics
Chi-square Test of Independence
Post hoc Tests of Means
Cross-Tabulation Tables
Using the Pivot Tables Wizard
Graphing Cross-tabulation Tables
Single System Design
Basic Elements of Single System Design
Advanced Designs
Dynamic Chart Production
Single System Group Designs
Correlation and Regeression
Pearson's r and R2
Bivariate Regressions
Two Variable Regression
Creating Scatterplots
Trendlines in Scatterplots
Interpreting Scatterplots
Ordinary Least Squares (OLS) Regression
Interpreting Multivariate Regression (OLS) Output in Excel
Creating a Control Variable for Regression Analysis in Excel
Graphical Representation of Practice Information
Thinking Visually
Graphical Representation
Tools for Graphical Representation of Information
Matching Data to Type of Graph
Enhancing Graphs
Spreadsheets Drawing Tools