Statistics for Health Care Professionals: Working With Excel [NOOK Book]


Statistics for Health Care Professionals: Working with Excel (second edition) is written in a clear, easily followed style keyed to the powerful statistical tool, Microsoft Excel 2007. It introduces the use of statistics applicable to health administration, health policy, public health, health information management, and other professions, emphasizing the logic of probability and statistical analysis in all areas. Coverage includes data acquisition, data display, basics of probability, data distributions, ...
See more details below
Statistics for Health Care Professionals: Working With Excel

Available on NOOK devices and apps  
  • NOOK Devices
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK Study
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$51.49 price
(Save 42%)$90.00 List Price
Note: This NOOK Book can be purchased in bulk. Please email us for more information.


Statistics for Health Care Professionals: Working with Excel (second edition) is written in a clear, easily followed style keyed to the powerful statistical tool, Microsoft Excel 2007. It introduces the use of statistics applicable to health administration, health policy, public health, health information management, and other professions, emphasizing the logic of probability and statistical analysis in all areas. Coverage includes data acquisition, data display, basics of probability, data distributions, confidence limits and hypothesis testing, statistical tests for categorical data, tests for related and unrelated data, analysis of variance, simple linear regression, multiple regression, and analysis with a dichotomous categorical dependent variable. A glossary and section-by-section review questions round out this uniquely comprehensive and accessible text.
Read More Show Less

What People Are Saying

From the Publisher
"By using Excel to explain how to conduct a statistical analysis, students will thoroughly grasp not only the mechanics of statistics but the underlying rationale for statistical reasoning."
— James V. Porto, Ph.D., MPA, Director, Executive Master's Programs, Health Policy and Administration School of Public Health, University of North Caroline-Chapel Hill

"Using Excel to teach statistics helped my understanding and makes ultimate sense when teaching statistics in the health care field."
— Scott Bankard, MPT, supervisor of acute rehabilitation services, Pitt County Memorial Hospital

"Thanks to this text, my graduate students actually enjoy our health care statistics course. I am struck by how much the authors cover, how clearly they convey some normally difficult concepts, and how much they incorporate new features found in Excel 2007, all in an easily understood manner."
— David C. Burchfield, PhD, FHFMA, Associate Professor, Master's of Health Administration, The University of Memphis

"The text is very intuitive and pragmatic in using Excel to teach statistical analysis to health profes­sionals. I plan on using it as a desk reference for many years in the future"
— Andrew Matthews, MD, FACEP, medical director, Emergency Care Center, and advisory board member, CMC-NorthEast

Read More Show Less

Product Details

  • ISBN-13: 9780470497920
  • Publisher: Wiley
  • Publication date: 8/7/2009
  • Series: Public Health/Epidemiology and Biostatistics , #9
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 2
  • Pages: 528
  • Sales rank: 1,316,263
  • File size: 15 MB
  • Note: This product may take a few minutes to download.

Meet the Author

John F. Kros is an associate professor of marketing and supply chain management at East Carolina University College of Business, Greenville, North Carolina.

David A. Rosenthal is an associate professor in the Department of Health Informatics and Information Management at the University of Tennessee's Health Science Center, Memphis.

Read More Show Less

Table of Contents



The Authors.

Part One.

1 Statistics and Excel.

1.1 How This Book Differs from Other Statistics Texts.

1.2 Statistical Applications in Health Policy and Health Administration.

Exercises for Section 1.2.

1.3 What Is the "Big Picture"?

1.4 Some Initial Definitions.

Exercises for Section 1.4.

1.5 Five Statistical Tests.

Exercises for Section 1.5.

Key Terms.

2 Excel as a Statistical Tool.

2.1 The Basics.

Exercises for Section 2.1.

2.2 Working and Moving Around in a Spreadsheet.

Exercises for Section 2.2.

2.3 Excel Functions.

Exercises for Section 2.3.

2.4 The =IF() Function.

Exercises for Section 2.4.

2.5 Excel Graphs.

Exercises for Section 2.5.

2.6 Sorting a String of Data.

Exercise for Section 2.6.

2.7 The Data Analysis Pack.

2.8 Functions That Give Results in More Than One Cell.

Exercises for Section 2.8.

2.9 The Dollar Sign ($) Convention for Cell References.

Key Terms.

3 Data Acquisition: Sampling and Data Preparation.

3.1 The Nature of Data.

Exercises for Section 3.1.

3.2 Sampling.

Exercises for Section 3.2.

3.3 Data Access and Preparation.

Exercises for Section 3.3.

3.4 Missing Data.

Key Terms.

4 Data Display: Descriptive Presentation, Excel Graphing Capability.

4.1 The =FREQUENCY() Function.

Exercises for Section 4.1.

4.2 Using the Pivot Table to Generate Frequencies of Categorical Variables.

Exercises for Section 4.2.

4.3 A Logical Extension of the Pivot Table: Two Variables.

Exercises for Section 4.3.

Appendix: Using Excel 2007 to Generate Pivot Tables with One Variable.

Key Terms.

5 Basic Concepts of Probability.

5.1 Some Initial Concepts and Definitions.

Exercises for Section 5.1.

5.2 Marginal Probabilities, Joint Probabilities, and Conditional Probabilities.

Exercises for Section 5.2.

5.3 Binomial Probability.

Exercises for Section 5.3.

5.4 The Poisson Distribution.

Exercises for Section 5.4.

5.5 The Normal Distribution.

Key Terms.

6 Measures of Central Tendency and Dispersion: Data Distributions.

6.1 Measures of Central Tendency and Dispersion.

Exercises for Section 6.1.

6.2 The Distribution of Frequencies.

Exercises for Section 6.2.

6.3 The Sampling Distribution of the Mean.

Exercises for Section 6.3.

6.4 Mean and Standard Deviation of a Discrete Numerical Variable.

Exercises for Section 6.4.

6.5 The Distribution of a Proportion.

Exercises for Section 6.5.

6.6 The t Distribution.

Exercises for Section 6.6.

Key Terms.

Part Two.

7 Confidence Limits and Hypothesis Testing.

7.1 What Is a Confidence Interval?

Exercises for Section 7.1.

7.2 Calculating Confidence Limits for Multiple Samples.

Exercises for Section 7.2.

7.3 What Is Hypothesis Testing?

Exercises for Section 7.3.

7.4 Type I and Type II Errors.

Exercises for Section 7.4.

7.5 Selecting Sample Sizes.

Exercises for Section 7.5.

Key Terms.

8 Statistical Tests for Categorical Data.

8.1 Independence of Two Variables.

Exercises for Section 8.1.

8.2 Examples of Chi-Square Analyses.

Exercises for Section 8.2.

8.3 Small Expected Values in Cells.

Exercises for Section 8.3.

Key Terms.

9 t Tests for Related and Unrelated Data.

9.1 What Is a t Test?.

Exercises for Section 9.1.

9.2 A t Test for Comparing Two Groups.

Exercises for Section 9.2.

9.3 A t Test for Related Data.

Exercises for Section 9.3.

Key Terms.

10 Analysis of Variance.

10.1 One-Way Analysis of Variance.

Exercises for Section 10.1.

10.2 ANOVA for Repeated Measures.

Exercises for Section 10.2.

10.3 Factorial Analysis of Variance.

Exercises for Section 10.3.

Key Terms.

11 Simple Linear Regression.

11.1 Meaning and Calculation of Linear Regression.

Exercises for Section 11.1.

11.2 Testing the Hypothesis of Independence.

Exercises for Section 11.2.

11.3 The Excel Regression Add-In.

Exercises for Section 11.3.

11.4 The Importance of Examining the Scatterplot.

11.5 The Relationship Between Regression and the t Test.

Exercises for Section 11.5.

Key Terms.

12 Multiple Regression: Concepts and Calculation.

12.1 Introduction.

Exercises for Section 12.1.

12.2 Multiple Regression and Matrices.

Exercises for Section 12.2.

Key Terms.

13 Extensions of Multiple Regression.

13.1 Dummy Variables in Multiple Regression.

Exercises for Section 13.1.

13.2 The Best Regression Model.

Exercises for Section 13.2.

13.3 Correlation and Multicolinearity.

Exercises for Section 13.3.

13.4 Nonlinear Relationships.

Exercises for Section 13.4.

Key Terms.

14 Analysis with a Dichotomous Categorical Dependent Variable.

14.1 Introduction to the Dichotomous Dependent Variable.

14.2 An Example with a Dichotomous Dependent Variable: Traditional Treatments.

Exercises for Section 14.2.

14.3 Logit for Estimating Dichotomous Dependent Variables.

Exercises for Section 14.3.

14.4 A Comparison of Ordinary Least Squares, Weighted Least Squares, and Logit.

Exercises for Section 14.4.

Key Terms.




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)