Statistics for Health Care Management and Administration : Working with Excel.

Format:

Book

Author/Creator:

Kros, John F.

Contributor:

Rosenthal, David A.

Series:

Public Health/Epidemiology and Biostatistics Ser.

Language:

English

Subjects (All):

Medical statistics.

Physical Description:

1 online resource (562 pages)

Edition:

3rd ed.

Place of Publication:

New York, NY : John Wiley & Sons, Incorporated, 2016.

Contents:

Cover

Title Page

Copyright

Contents

Preface

Introducing Excel

So How Did We Get to Here?

Intended Level of the Textbook

Textbook Organization

Leading by Example(s)

Acknowledgments

The Authors

Part 1

Chapter 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

Chapter 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

Chapter 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

Chapter 4 Data Display: Descriptive Presentation, Excel Graphing Capability

4.1 Creating, Displaying, and Understanding Frequency Distributions

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

Chapter 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

Chapter 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

Part 2

Chapter 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

Chapter 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

Chapter 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

Chapter 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

Chapter 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

Chapter 12 Multiple Regression: Concepts and Calculation

12.1 Introduction

Exercises for Section 12.1

Chapter 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

Chapter 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

Appendix A Multiple Regression and Matrices

An Introduction to Matrix Math

Addition and Subtraction of Matrices

Multiplication of Matrices

Matrix Multiplication and Scalars

Finding the Determinant of a Matrix

Matrix Capabilities of Excel

Explanation of Excel Output Displayed with Scientific Notation.

Using the b Coefficients to Generate Regression Results

Calculation of All Multiple Regression Results

Exercises for Appendix A

References

Glossary

Index

EULA.

Notes:

Description based on publisher supplied metadata and other sources.

Other Format:

Print version: Kros, John F. Statistics for Health Care Management and Administration

ISBN:

9781118712641

OCLC:

935251560