Statistics with Excel (2nd Edition) [Spiral-bound]

Beverly Jean Dretzke (Author)

Book Description

Publication Date: June 25, 2001 | ISBN-10: 0130223573 | ISBN-13: 978-0130223579 | Edition: 2nd

For a one or two term course in introductory statistics using Excel. Appropriate for a variety of disciplines including mathematics, the social sciences, and business. This manual provides statistics students with a complete introduction to statistics using Excel. Its availability, easy-to-understand, basic spreadsheet operations, and analysis tools make Excel a superb software package to carry out statistical analyses in required core courses.

Editorial Reviews

From the Back Cover

This step-by-step Excel manual is designed for those who desire to learn how to effectively use Excel for data analysis. Its availability, easy-to-understand, basic spreadsheet operations, and analysis tools make Excel a superb software package to carry out statistical analyses. Expanded coverage of graphing and regression analysis. Use of Excel (instead of hand-held calculators) for “number crunching.” Coverage of more complex analysis that can be carried out with StatBox software. Add in Disk included. For a variety of disciplines, including mathematics, the social sciences, and business. Can be used by data analysts who wish to use Excel to record, manipulate, and analyze their data set.

Excerpt. © Reprinted by permission. All rights reserved.

Preface

The first edition of Statistics with Microsoft® Excel was prepared in 1997 and published in 1998. Since that time, the Office 2000 version of Microsoft® Excel became available. Although Excel 2000 works on the same principles as Excel 97, there are slight differences with respect to the appearance of some of the dialog boxes. For users of this manual who rely greatly on screen prints as a means of following along and checking the accuracy of their work, I felt it was necessary to update these to the current version. Therefore, the screen prints appearing in this manual were obtained on computers utilizing Excel 2000. Instructions were revised to reflect any differences. In addition, with Excel 2000, Pivot Tables can be constructed in a mare interactive manner, and I included some instructions on this in Chapter 12.

During the past three years, I have used Statistics with Microsoft® Excel in all my introductory statistics courses. Feedback received from students led to some layout and content revisions. For example, in an attempt to make the instructions easier to follow, I numbered the steps, rather than using bullets, and used wider spacing. I also reduced the size of some of the sample data sets and included more complete instructions on how to create histograms and bar graphs.

Introductory statistics students traditionally make frequent use of a hand-held calculator to carry out numerous exercises in which they apply the formulas for the mean, variance, standard deviation, z-scores, and so on. Rather than using a hand-held calculator for these computations, however, I preferred that my students use Excel. I found that the earlier manual did not give sufficient guidance in using formulas for these tasks. Therefore, I included a section in Chapter 3 of this edition that provides instructions specifically for these applications.

Several users of the first edition sent e-mail messages in which they made comments or asked questions about the manual and Excels statistical analysis capabilities. I was very surprised to receive messages from Europe and Africa as well as the United States, and I am very grateful for this input. Some of the revisions and additions in the second edition were made in response to these messages. For example, this edition includes a detailed section on dummy coding of qualitative variables in regression analysis and an explanation of how to use Excel to rank data and compute a Spearman rank correlation coefficient.

Much of the work on this manual was completed while I was a visiting professor at Kansai Gaidai University in Hirakata City, Osaka, Japan. I am grateful to Dean Hajime Yamamoto and the staff of the Center for International Education for providing excellent facilities and a very congenial atmosphere.

I wish to thank Kathy Boothby-Sestak and Quincy McDonald of Prentice-Hall for their assistance. I am grateful to Eric Dretzke for technical support regarding computer hardware and software. Special thanks goes to Kathleen S. Finder, an information-processing consultant at the University of Wisconsin-Eau Claire for her invaluable guidance.

If you have any comments or suggestions that you would like to make regarding this manual, please send me a message.

Beverly J. Dretzke
([e-mail])

Product Details

• Spiral-bound: 257 pages
• Publisher: Prentice Hall; 2nd edition (June 25, 2001)
• Language: English
• ISBN-10: 0130223573
• ISBN-13: 978-0130223579
• Product Dimensions: 10.7 x 8.8 x 0.7 inches
• Shipping Weight: 1.3 pounds
• Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
• Amazon Best Sellers Rank: #1,915,232 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

5.0 out of 5 stars Staistics with Excel, May 20, 2007

By 

J. DECK (Orlando, FL USA) - See all my reviews
(REAL NAME)   

This review is from: Statistics with Excel (2nd Edition) (Spiral-bound)

It was mandatory to purchase this book for my graduate level statistics class. It was very helpful. I was amazed how powerful Excel was to use, after reading this book.