Statistics for Health Policy and Administration Using Microsoft Excel provides an introduction to the use of statistics in health policy and health administration-related fields. The book is keyed to the powerful statistical tool Microsoft Excel and shows how to prepare data and understand the data display capabilities of the program. It also offers the information needed to master probabilitya the foundation of statistical analysis. This important book is structured around illustrative examples that are demonstrated with Excel displays. The book is filled with step-by-step discussions of how statistical problems are solved using Excel, and it contains a wealth of exercises addressing the material covered in each section. Many of the book's exercises include the replication of examples so that the student has an immediate reference with which to compare his or her work and determine whether or not the procedure was carried out correctly. Additional exercises are provided for further practice to reinforce the valuable lessons learnedriflSjffil =IFffi2agt;10, a#39;Long-, IF(B2alt;5/ShortVMediuma#39;a#39;)) second =IF() function is assessed by Excel. ... Excel will operate on up to sixteen nested =IF() statements, but it is hard to imagine why anyone would want so many. It is also useful to ... Create an =IF() statement that determines whether the infant is greater or less in weight than the overall average and assign a 1 to those greater and a 0 to those less. b.
|Title||:||Statistics for Health Policy and Administration Using Microsoft Excel|
|Author||:||James E. Veney|
|Publisher||:||Jossey-Bass - 2003-10-31|