Statistics for Health Care Professionals Working with Excel

Name: Statistics for Health Care Professionals Working with Excel
Price: 78.93 USD
Availability: InStock
ISBN: 9780470393314

ISBN-10: 0470393319

ISBN-13: 9780470393314

Edition: 2nd 2009

Authors: James E. Veney, John F. Kros, David A. Rosenthal, Veney

List price: $70.00

30 day, 100% satisfaction guarantee!

Marketplace

1 new & used from $78.93

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

There is a need for an updated comprehensive text on statistics in health care services. This important resource, that has been thoroughly revised and update to include Excel 2007, offers a comprehensive introduction to statistical methods for the health care researcher and professional. It also includes an overview of Excel 2007 as a powerful tool for research and analysis. This text includes new information on logic of statistical testing, dealing with missing data, relative risk and odds ratios, regression treatment of time series data, and more.

Book details

List price: $70.00
Edition: 2nd
Copyright year: 2009
Publisher: John Wiley & Sons, Limited
Publication date: 9/11/2009
Binding: Paperback
Pages: 528
Size: 6.75" wide x 9.00" long x 1.00" tall
Weight: 1.936
Language: English



Preface


Acknowledgments


The Authors






Statistics and Excel



How This Book Differs from Other Statistics Texts



Statistical Applications in Health Policy and Health Administration


Exercises for Section 1.2



What Is the "Big Picture"?



Some Initial Definitions


Exercises for Section 1.4



Five Statistical Tests


Exercises for Section 1.5


Key Terms



Excel As A Statistical Tool



The Basics


Exercises for Section 2.1



Working and Moving Around in a Spreadsheet


Exercises for Section 2.2



Excel Functions


Exercises for Section 2.3



The = IF() Function


Exercises for Section 2.4



Excel Graphs


Exercises for Section 2.5



Sorting a String of Data


Exercises for Section 2.6



The Data Analysis Pack



Functions that Give Results in More than One Cell


Exercises for Section 2.8



The Dollar Sign ($) Convention for Cell References


Key Terms



Data Acquisition: Sampling and Data Preparation



The Nature of Data


Exercises for Section 3.1



Sampling


Exercises for Section 3.2



Data Access and Preparation


Exercises for Section 3.3



Missing Data


Key Terms



Data Display: Descriptive Presentation, Excel Graphing Capability



The = FREQUENCY() Function


Exercises for Section 4.1



Using the Pivot Table to Generate Frequencies of Categorical Variables


Exercises for Section 4.2



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



Basic Concepts of Probability



Some Initial Concepts and Definitions


Exercises for Section 5.1



Marginal Probabilities, Joint Probabilities, and Conditional Probabilities


Exercises for Section 5.2



Binomial Probability


Exercises for Section 5.3



The Poisson Distribution


Exercises for Section 5.4



The Normal Distribution


Key Terms



Measures of Central Tendency and Dispersion: Data Distributions



Measures of Central Tendency and Dispersion


Exercises for Section 6.1



The Distribution of Frequencies


Exercises for Section 6.2



The Sampling Distribution of the Mean


Exercises for Section 6.3



Mean and Standard Deviation of a Discrete Numerical Variable


Exercises for Section 6.4



The Distribution of a Proportion


Exercises for Section 6.5



The t Distribution


Exercises for Section 6.6


Key Terms






Confidence Limits and Hypothesis Testing



What Is a Confidence Interval?


Exercises for Section 7.1



Calculating Confidence Limits for Multiple Samples


Exercises for Section 7.2



What Is Hypothesis Testing?


Exercises for Section 7.3



Type I and Type II Errors


Exercises for Section 7.4



Selecting Sample Sizes


Exercises for Section 7.5


Key Terms



Statistical Tests for Categorical Data



Independence of Two Variables


Exercises for Section 8.1



Examples of Chi-Square Analyses


Exercises for Section 8.2



Small Expected Values in Cells


Exercises for Section 8.3


Key Terms



t Tests for Related and Unrelated Data



What Is a t Test?


Exercises for Section 9.1



A t Test for Comparing Two Groups


Exercises for Section 9.2



A t Test for Related Data


Exercises for Section 9.3


Key Terms



Analysis of Variance



One-Way Analysis of Variance


Exercises for Section 10.1



ANOVA for Repeated Measures


Exercises for Section 10.2



Factorial Analysis of Variance


Exercises for Section 10.3


Key Terms



Simple Linear Regression



Meaning and Calculation of Linear Regression


Exercises for Section 11.1



Testing the Hypothesis of Independence


Exercises for Section 11.2



The Excel Regression Add-In


Exercises for Section 11.3



The Importance of Examining the Scatterplot



The Relationship Between Regression and the t Test


Exercises for Section 11.5


Key Terms



Multiple Regression: Concepts and Calculation



Introduction


Exercises for Section 12.1



Multiple Regression and Matrices


Exercises for Section 12.2


Key Terms



Extensions of Multiple Regression



Dummy Variables in Multiple Regression


Exercises for Section 13.1



The Best Regression Model


Exercises for Section 13.2



Correlation and Multicolinearity


Exercises for Section 13.3



Nonlinear Relationships


Exercises for Section 13.4


Key Terms



Analysis with a Dichotomous Categorical Dependent Variable



Introduction to the Dichotomous Dependent Variable



An Example with a Dichotomous Dependent Variable: Traditional Treatments


Exercises for Section 14.2



Logit for Estimating Dichotomous Dependent Variables


Exercises for Section 14.3



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


Exercises for Section


Key Terms


Glossary


References


Index