Home Page Icon
Home Page
Table of Contents for
Cover
Close
Cover
by David A. Rosenthal, John F. Kros
Statistics for Health Care Management and Administration
Title Page
Copyright
Dedication
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
1.3 What Is the “Big Picture”?
1.4 Some Initial Definitions
1.5 Five Statistical Tests
Key Terms
Chapter 2: Excel as a Statistical Tool
2.1 The Basics
2.2 Working and Moving Around in a Spreadsheet
2.3 Excel Functions
2.4 The =IF() Function
2.5 Excel Graphs
2.6 Sorting a String of Data
2.7 The Data Analysis Pack
2.8 Functions That Give Results in More than One Cell
2.9 The Dollar Sign ($ ) Convention for Cell References
Key Terms
Chapter 3: Data Acquisition: Sampling and Data Preparation
3.1 The Nature of Data
3.2 Sampling
3.3 Data Access and Preparation
3.4 Missing Data
Key Terms
Chapter 4: Data Display: Descriptive Presentation, Excel Graphing Capability
4.1 Creating, Displaying, and Understanding Frequency Distributions
4.2 Using the Pivot Table to Generate Frequencies of Categorical Variables
4.3 A Logical Extension of the Pivot Table: Two Variables
Key Terms
Chapter 5: Basic Concepts of Probability
5.1 Some Initial Concepts and Definitions
5.2 Marginal Probabilities, Joint Probabilities, and Conditional Probabilities
5.3 Binomial Probability
5.4 The Poisson Distribution
5.5 The Normal Distribution
Key Terms
Chapter 6: Measures of Central Tendency and Dispersion: Data Distributions
6.1 Measures of Central Tendency and Dispersion
6.2 The Distribution of Frequencies
6.3 The Sampling Distribution of the Mean
6.4 Mean and Standard Deviation of a Discrete Numerical Variable
6.5 The Distribution of a Proportion
6.6 The t Distribution
Key Terms
Part 2
Chapter 7: Confidence Limits and Hypothesis Testing
7.1 What Is a Confidence Interval?
7.2 Calculating Confidence Limits for Multiple Samples
7.3 What Is Hypothesis Testing?
7.4 Type I and Type II Errors
7.5 Selecting Sample Sizes
Key Terms
Chapter 8: Statistical Tests for Categorical Data
8.1 Independence of Two Variables
8.2 Examples of Chi-Square Analyses
8.3 Small Expected Values in Cells
Key Terms
Chapter 9: t Tests for Related and Unrelated Data
9.1 What Is a t Test?
9.2 A t Test for Comparing Two Groups
9.3 A t Test for Related Data
Key Terms
Chapter 10: Analysis of Variance
10.1 One-Way Analysis of Variance
10.2 ANOVA for Repeated Measures
10.3 Factorial Analysis of Variance
Key Terms
Chapter 11: Simple Linear Regression
11.1 Meaning and Calculation of Linear Regression
11.2 Testing the Hypothesis of Independence
11.3 The Excel Regression Add-In
11.4 The Importance of Examining the Scatterplot
11.5 The Relationship between Regression and the t Test
Key Terms
Chapter 12: Multiple Regression: Concepts and Calculation
12.1 Introduction
Key Terms
Chapter 13: Extensions of Multiple Regression
13.1 Dummy Variables in Multiple Regression
13.2 The Best Regression Model
13.3 Correlation and Multicolinearity
13.4 Nonlinear Relationships
Key Terms
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
14.3 Logit for Estimating Dichotomous Dependent Variables
14.4 A Comparison of Ordinary Least Squares, Weighted Least Squares, and Logit
Key Terms
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
References
Glossary
Index
End User License Agreement
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Contents
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset