Data Analysis with Spreadsheets (with CD-ROM)
ISBN-10: 0-205-40751-X
ISBN-13: 978-0-205-40751-4
Published by Allyn & Bacon
© 2006
Pub. Date: Apr 11, 2005
Format: Paper Bound w/CD-ROM
Description
David A. Patterson and Randall E. Basham have produced the first book and CD-ROM to combine 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 professionals will find this an excellent guide to taking advantage of spreadsheet software, an underutilized, inexpensive and commonly available data analytic tool found in most, if not all, agency settings.
Data Analysis with Spreadsheest offer instructors clearly articulated descriptions and video demonstrations of data analysis procedures that are commonly referred to in research and practice evaluation texts. This text and CD-ROM present a variety of ways to select random samples and clearly demonstrate how to produce descriptive statistics, frequency distributions, and bivariate analyses using spreadsheets.
Table of Contents
Each chapter concludes with “Chapter Summary” and “References.”
1. 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.
2. Data Collections Ways and 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.
3. Selecting Samples.
Samples: First Facts.
Simple Random Samples.
Systematic Sampling.
Stratified Sampling.
Random Assignment.
4. Data Cleaning
Types of Problem Data.
Detecting Data Errors.
Contingency Cleaning.
Missing Data: Its Detection and Handling.
Detecting Missing Data.
Handling Missing Data.
5. Frequency Distributions and Histograms.
Understanding the Distribution of Values.
Frequency Distributions.
Producing Histograms Using the Chart Wizard.
6. 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.
7. Statistical Inference and Hypothesis Testing.
Normal Distributions.
Probability Distributions.
Skewness.
Understanding Hypothesis Testing.
Statistical Significance.
Effect Size and Sample Size Estimation.
8. Bivariate Statistics.
Chi-square Test of Independence.
t-Test.
ANOVA.
Post hoc Tests of Means.
9. Cross-Tabulation Tables.
Using the Pivot Tables Wizard.
Graphing Cross-tabulation Tables.
10. Single System Design.
Basic Elements of Single System Design.
Advanced Designs.
Dynamic Chart Production.
Single System Group Designs.
11. Correlation and Regeression.
Pearson's r and R2.
Bivariate Regressions.
Regression.
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.
12. 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.
Ecomaps.
Genograms.
This textbook is also sold in the various packages listed below. Before purchasing one of these packages, speak with your professor about which one will help you be successful in your course.
Package ISBN-13: 9780205615407
$77.40 | Add to Cart
This package contains:
- Data Analysis with Spreadsheets (with CD-ROM)
David A. Patterson, Randall E. Basham | ©2006 | Paper Bound w/CD-ROM; 208 pages - MyHelpingLab CourseCompass with E-Book Student Access Code Card (for valuepacks)
Allyn & Bacon | ©2006 | Access Code Card
Package ISBN-13: 9780205615414
$77.40 | Add to Cart
This package contains:
- Data Analysis with Spreadsheets (with CD-ROM)
David A. Patterson, Randall E. Basham | ©2006 | Paper Bound w/CD-ROM; 208 pages - MyHelpingLab Student Access Code Card (for valuepacks)
Allyn & Bacon | ©2006 | Access Code Card
Package ISBN-13: 9780205524426
$123.27 | Add to Cart
This package contains:
- Data Analysis with Spreadsheets (with CD-ROM)
David A. Patterson, Randall E. Basham | ©2006 | Paper Bound w/CD-ROM; 208 pages - Research Methods for Social Work
David E. Cournoyer, Waldo C. Klein | ©2000 | Paper; 274 pages
Package ISBN-13: 9780205527038
$114.67 | Add to Cart
This package contains:
- Data Analysis with Spreadsheets (with CD-ROM)
David A. Patterson, Randall E. Basham | ©2006 | Paper Bound w/CD-ROM; 208 pages - Evaluating Social Work Services and Programs
Robert W. Weinbach | ©2005 | Paper; 384 pages
Package ISBN-13: 9780205491841
$123.27 | Add to Cart
This package contains:
- Data Analysis with Spreadsheets (with CD-ROM)
David A. Patterson, Randall E. Basham | ©2006 | Paper Bound w/CD-ROM; 208 pages - Research Methods for Social Work
James R. Dudley | ©2005 | Paper; 352 pages
Package ISBN-13: 9780205526765
$129.27 | Add to Cart
This package contains:
- Data Analysis with Spreadsheets (with CD-ROM)
David A. Patterson, Randall E. Basham | ©2006 | Paper Bound w/CD-ROM; 208 pages - Social Work Research: An Applied Approach
Sakinah Salahu-Din | ©2003 | Paper; 352 pages
Package ISBN-13: 9780205529605
$126.47 | Add to Cart
This package contains:
- Data Analysis with Spreadsheets (with CD-ROM)
David A. Patterson, Randall E. Basham | ©2006 | Paper Bound w/CD-ROM; 208 pages - Statistics for Social Workers, 7th Edition
Robert W. Weinbach, Richard M. Grinnell | ©2007 | Paper; 320 pages
Package ISBN-13: 9780205493012
$141.32 | Add to Cart
This package contains:
- Data Analysis with Spreadsheets (with CD-ROM)
David A. Patterson, Randall E. Basham | ©2006 | Paper Bound w/CD-ROM; 208 pages - Research Methods for Social Workers, 6th Edition
Bonnie L. Yegidis, Robert W. Weinbach | ©2009 | Paper; 368 pages
Package ISBN-13: 9780205527083
$101.27 | Add to Cart
This package contains:
- Data Analysis with Spreadsheets (with CD-ROM)
David A. Patterson, Randall E. Basham | ©2006 | Paper Bound w/CD-ROM; 208 pages - Social Work Evaluation: Principles and Methods
Leon H. Ginsberg | ©2001 | Paper; 308 pages
Package ISBN-13: 9780205572816
$128.27 | Add to Cart
This package contains:
- Data Analysis with Spreadsheets (with CD-ROM)
David A. Patterson, Randall E. Basham | ©2006 | Paper Bound w/CD-ROM; 208 pages - Social Work Research Methods: From Conceptualization to Dissemination
Brett Drake, Melissa Jonson-Reid | ©2008 | Cloth; 688 pages
Package ISBN-13: 9780205526543
$131.27 | Add to Cart
This package contains:
- Data Analysis with Spreadsheets (with CD-ROM)
David A. Patterson, Randall E. Basham | ©2006 | Paper Bound w/CD-ROM; 208 pages - Data Analysis for Social Workers
Denise Montcalm, David Royse | ©2002 | Paper; 352 pages
Package ISBN-13: 9780205496099
$152.47 | Add to Cart
This package contains:
- Data Analysis with Spreadsheets (with CD-ROM)
David A. Patterson, Randall E. Basham | ©2006 | Paper Bound w/CD-ROM; 208 pages - Elementary Statistics in Criminal Justice Research: The Essentials
James Alan Fox, Jack Levin, Michael Shively | ©2005 | Paper; 352 pages
