Data Analysis with Spreadsheets / Edition 1

Hardcover (Print)
Buy Used
Buy Used from
(Save 34%)
Item is in good condition but packaging may have signs of shelf wear/aging or torn packaging.
Condition: Used – Good details
Used and New from Other Sellers
Used and New from Other Sellers
from $68.10
Usually ships in 1-2 business days
(Save 25%)
Other sellers (Hardcover)
  • All (3) from $68.10   
  • New (1) from $81.01   
  • Used (2) from $68.10   
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any coupons and promotions
Seller since 2008

Feedback rating:



New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

020540751X New. Has the slightest of shelf wear (like you might see in a major bookstore chain). Looks like an interesting title! We provide domestic tracking upon request, ... provide personalized customer service and want you to have a great experience purchasing from us. 100% satisfaction guaranteed and thank you for your consideration. Read more Show Less

Ships from: Chicago, IL

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Sort by


Introduce your Social Work students to data collection, statistical analysis, and graphical representation of results using spreadsheets: an inexpensive and readily available data analytic software. This text and companion CD-ROM use videos, text, and graphics to provide students clearly articulated descriptions and demonstrations of data analysis procedures that are commonly referred to in research, statistics and practice evaluation texts.

“I have nothing but praise for this book. Hurry and publish it.”
Steve Marson, UNC Pembroke

“The CD-Rom is a valuable accompaniment to the text, especially for visual and auditory learners. The voices are audible and at a pace that listeners can easily follow along. The table layout where users can click on the chapter and topics they are interested in is easy to navigate. I would definitely consider adopting this text for my course.”
Margaret E. Adamek, Indiana University

“The authors are correct in stating that computers with spreadsheets are widely available, and that they contain powerful functions. As such, it is helpful to have a text that can show future practitioners how to use these tools to improve their practice. The CD provides an excellent supplement to the text. Students can use the CD at their own speed, can repeat lessons as necessary and can use the CD in their agencies to analyze data.”
John Goad, Arizona State University

Related Titles:
Research Methods for Social Work, 1/e
James R. Dudley Order No. 0-205-36529-9

Information Technology for Social Work (with Research Navigator Guide for the Helping Professions), 1/e
Phyllis Schiller Order No. 0-205-45367-8

Statistics for Social Workers, 6/e
Robert W. Weinbach and Richard M. Grinnell Jr.
Order No. 0-205-37598-7

Planning and Conducting Agency-Based Research, 3/e
Alex J. Westerfelt and Tracy J. Dietz Order No. 0-205-38687-3

Research Methods for Social Workers, 5/e
Bonnie L. Yegidis and Robert W. Weinbach Order No. 0-205-40818-4

Read More Show Less

Product Details

  • ISBN-13: 9780205407514
  • Publisher: Pearson
  • Publication date: 4/11/2005
  • Edition description: BK&CD-ROM
  • Edition number: 1
  • Pages: 208
  • Product dimensions: 8.50 (w) x 10.84 (h) x 0.54 (d)

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.


Understanding Hypothesis Testing.

Statistical Significance.

Effect Size and Sample Size Estimation.

8. Bivariate Statistics.

Chi-square Test of Independence.



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.


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.



Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)