You will learn how to estimate the population mean (average) for a group of events or objects at a 95 % confidence level so that you are 95 % confident that the population mean is between a lower limit of the data and an upper limit of the data. This chapter explains how to find the 95 % confidence interval about the mean for a set of data, and how to test hypotheses about your data using this confidence interval. An additional practice problem is presented in the Practice Test given in Appendix B along with its answer in Appendix C of this book. Three practice problems are given at the end of the chapter to test your Excel skills, and the answers to these problems appear in Appendix A of this book. You will also learn how to use Fill/Series commands, how to change the width of a column, how to center information in a group of cells, how to give a “name” to a group of cells, how to find the sample size for a data set, how to format numbers with a specific number of decimal places, how to save an Excel worksheet into your computer, and how to print out an Excel worksheet. Then, the steps needed to compute these formulas using Excel commands are explained so that you can practice using Excel to use these formulas correctly. The formulas are presented, explained, and a practical example is given for each formula that shows how the formula can be applied using a calculator.
All three of these statistics are basic to the study of statistics and are used frequently within many additional statistical tests. This chapter deals with how you can use Excel to find the average (i.e., “mean”) of a set of scores, the standard deviation of these scores (STDEV), and the standard error of the mean (s.e.) of these scores.
Separately, there is a full Practice Test (with answers in an Appendix) that allows readers to test what they have learned. Practice problems are provided at the end of each chapter with their solutions in an Appendix.
However, Excel 2010 for Health Services Management Statistics: A Guide to Solving Practical Problems is the first book to capitalize on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work.Įach chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand health services management problems. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. If understanding statistics isn’t your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you.Įxcel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in health services management courses. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical health services management problems. This is the first book to show the capabilities of Microsoft Excel to teach health services management statistics effectively.