Data Analysis with Microsoft Excel: Updated for Office 2000 [Paperback]

Kenneth N. Berk (Author), Patrick Carey (Author)

Book Description

ISBN-10: 0534362788 | ISBN-13: 978-0534362782 | Publication Date: April 3, 2000 | Edition: Bk&CD-Rom

This popular hands-on text teaches readers how to use Microsoft Excel to solve the kind of statistical problems that arise in business and elsewhere. Even readers with no previous experience using computer spreadsheets will find that this book's step-by-step approach and plentiful use of screen shots make it easy to learn how to use Excel for analyzing data. A CD-ROM that accompanies the text contains StatPlus 2.0, data sets and exercises.

Editorial Reviews

About the Author

Ken Berk has a BS in Physics from Carnegie Tech (now Carnegie Mellon) and a PhD in Mathematics from Minnesota. He is Professor Emeritus of Mathematics at Illinois State University and a Fellow of the American Statistical Association. He founded the Software Reviews section of The American Statistician and edited it for six years. He served as Secretary/Treasurer, Program Chair, and Chair of the Statistical Computing Section of the American Statistical Association, and he twice co-chaired the Interface Symposium, the main annual meeting in statistical computing. His published work includes papers on time series, statistical computing, regression analysis, and statistical graphics and the book Data Analysis with Microsoft® Excel (with Patrick Carey).

Patrick Carey received his M.S. in Biostatistics from the University of Wisconsin, where he worked as a researcher designing and analyzing clinical studies. He co-authored his first textbook on using Excel as a statistical tool. Patrick has authored or co-authored over 20 academic and trade texts for the software industry. --This text refers to an alternate Paperback edition.

Product Details

• Paperback: 600 pages
• Publisher: Duxbury Pr; Bk&CD-Rom edition (April 3, 2000)
• Language: English
• ISBN-10: 0534362788
• ISBN-13: 978-0534362782
• Product Dimensions: 9.2 x 7.2 x 1 inches
• Shipping Weight: 2 pounds
• Average Customer Review: 3.8 out of 5 stars  See all reviews (16 customer reviews)
• Amazon Best Sellers Rank: #1,503,728 in Books (See Top 100 in Books)
  • #58 in Books > Computers & Technology > Microsoft > Applications > Office 2000

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

31 of 31 people found the following review helpful:

4.0 out of 5 stars A review by a statistics class (XP edition), October 18, 2003

By 

Reader_in_PA (MACUNGIE, PA USA) - See all my reviews

This review is from: Data Analysis with Microsoft Excel: Updated for Office XP (with CD-ROM) (Paperback)

I use this book as the main text book for the first half of a class in statistics and research methods for students from a wide variety of social science and humanities backgrounds, with little formal statistics or mathematics background.

I surveyed my students with 5 questions about the book, with responses on a Likert scale (1=strongly disagree, 3=neutral, 5=strongly aggree. 17 students responded, which is a small enough sample size to caution applicability of results. The mean value of each response appears after the questions I asked.

1.The book was, overall, helpful in explaining statistical concepts. (Mean=2.73). Students would have appreciated more explanation and examples.
2.The book helped me to analyze data. (Mean=2.3)
3.The StatPlus AddIn was, overall, helpful in analyzing data. (Mean=3.76)
4.The StatPlus AddIn worked well on my computer. (Mean=3.7)
5.Overall, I would recommend this book to next year's class. (Mean=3.05)

Thus, overall, weighting each question equally, my students gave the book 3.12 stars.

As a professor, I give the book 4 stars. The organization of the book chapters fit well in an overview course, with one chapter assinged per week. The StatPlus AddIn is worth the cost of the book itself, as it expands the statistical capabilities of Excel without students needing to purchase additional software. There are a wide range of problems and example data sets which come with the book, applicable to a wide range of disciplines. A significant number of students had computer difficulties installing and running the StatPlus AddIn, so I would recommend to the company a support web page with FAQs, at the least.

Students with little preparation in mathematics or statiscs who need a good step-by-step guide to data analysis will find this book helpful, especially if they do the excercises at the end of the chapters. (The publishers should make the answers available to everyone, not just us instructors -- for those working on their own who want to check their work). However, students with some preparation in statistics or mathematics may be better served with a more advanced text.

35 of 37 people found the following review helpful:

4.0 out of 5 stars Data Analysis with Microsoft Excel by Berk and Carey, January 14, 2000

By A Customer

This review is from: Data Analysis With Microsoft Excel (Business Statistics Series) (Paperback)

As a statistics instructor, I found the book and software very helpful. To extract the software is a bit tricky - you need to read pages 8-10 and 76-77 to get the disk installed. Once installed, the Stat Plus Add-In adds extra tools, including a box plot and normal probability plot, that standard Excel does not have. My students use the software in a computer lab.

33 of 35 people found the following review helpful:

4.0 out of 5 stars Data Analysis for "Non"-Scientists, October 27, 2000

By 

Matthew M. Yau "Voracious reader" (San Francisco, CA) - See all my reviews
(REAL NAME)   

This review is from: Data Analysis With Microsoft Excel (Business Statistics Series) (Paperback)

I was browsing through a local bookstore for a guide to Excel specially tailored for science and engineering applications. I encountered this book and found it very interesting and detailed. It is written in plain English that conveys the message very well. For readers are looking for info about using Excel for statistics (pertaining to business, economics, and social science), this is the perfect book. Yet it does not extrapolate and contain all the necesaary info on science and engineering applications. I still recommend this book for non-scientists.