Advertisement

© 2013

Excel 2010 for Physical Sciences Statistics

A Guide to Solving Practical Problems

Textbook

Table of contents

  1. Front Matter
    Pages i-xvii
  2. Thomas J. Quirk, Meghan Quirk, Howard Horton
    Pages 1-19
  3. Thomas J. Quirk, Meghan Quirk, Howard Horton
    Pages 21-35
  4. Thomas J. Quirk, Meghan Quirk, Howard Horton
    Pages 37-66
  5. Thomas J. Quirk, Meghan Quirk, Howard Horton
    Pages 67-81
  6. Thomas J. Quirk, Meghan Quirk, Howard Horton
    Pages 83-110
  7. Thomas J. Quirk, Meghan Quirk, Howard Horton
    Pages 111-152
  8. Thomas J. Quirk, Meghan Quirk, Howard Horton
    Pages 153-168
  9. Thomas J. Quirk, Meghan Quirk, Howard Horton
    Pages 169-185
  10. Back Matter
    Pages 187-248

About this book

Introduction

This is the first book to show the capabilities of Microsoft Excel to teach physical sciences statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical science problems. 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.

Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand science problems. Practice problems are provided at the end of each chapter with their solutions in an appendix. Separately, there is a full Practice Test (with answers in an Appendix) that allows readers to test what they have learned.

·         Includes 159 illustrations in color.

·         Suitable for undergraduates or graduate students.

Professor. Thomas J. Quirk is currently a Professor of Marketing in the Walker School of Business and Technology at Webster University in St. Louis, Missouri (USA). He has published over 20 articles in professional journals and presented more than 20 papers at professional conferences. He holds a B.S. in Mathematics from John Carroll University, and both an M.A. in Education and a Ph.D. in Educational Psychology from Stanford University, as well as an M.B.A. from the University of Missouri-St. Louis.

Dr. Meghan H. Quirk holds both a Ph.D. in Biological Education and an M.A. in Biological Sciences from the University of Northern Colorado (UNC) and a B.A. in Biology and Religion at Principia College in Elsah, Illinois. She has done research on foodweb dynamics at Wind Cave National Park in South Dakota and research in agro-ecology in Southern Belize. She has co-authored an article on shortgrass steppe ecosystems in Photochemistry & Photobiology. She was a National Science Foundation Fellow GK-12, and currently teaches in Bailey, Colorado.

Howard F. Horton holds an M.S. in Biological Sciences from the University of Northern Colorado (UNC) and a B.S. in Biological Sciences from Mesa State College. He has worked on research projects in Pawnee National Grasslands, Rocky Mountain National Park, Long-Term Ecological Research at Toolik Lake, Alaska, and Wind Cave, South Dakota. He has co-authored articles in The International Journal of Speleology and The Journal of Cave and Karst Studies. He was a National Science Foundation Fellow GK-12, and a District Wildlife Manager with the Colorado Division of Parks and Wildlife. He is currently the Angler Outreach Coordinator with Colorado Parks and Wildlife.

Keywords

Applied Physical Sciences Statistics Excel Excel 2010 Excel 2010 Physical Sciences Statistics Physical Sciences Physical Sciences Statistics Physical Sciences Statistics with Excel 2010 Practical Physical Sciences Statistics

Authors and affiliations

  1. 1.Professor of MarketingWebster UniversitySt. LouisUSA
  2. 2.BaileyUSA
  3. 3.BaileyUSA

About the authors

At the beginning of his academic career, Prof. Thomas J. Quirk spent six years in educational research at The American Institutes for Research and Educational Testing Service.  He is currently a Professor of Marketing in the George Herbert Walker School of Business & Technology at Webster University based in St. Louis, Missouri (USA) where he teaches Marketing Statistics, Marketing Research, and Pricing Strategies.  He has written 60+ textbook supplements in Marketing and Management, published 20+ articles in professional journals, and presented 20+ papers at professional meetings.  He holds a B.S. in Mathematics from John Carroll University, both an M.A. in Education and a Ph.D. in Educational Psychology from Stanford University, and an M.B.A. from The University of Missouri-St. Louis.  This is Professor Quirk’s ninth statistics book with Springer.

Meghan H.Quirk holds both a Ph.D. in Biological Education and an M.A. in Biological Sciences from the University of Northern Colorado (UNC) and a B.A. in Biology and Religion at Principia College in Elsah, Illinois.  She has done research on foodweb dynamics at Wind Cave National Park in South Dakota and research in agro-ecology in Southern Belize.  She has co-authored  an article on shortgrass steppe ecosystems in Photochemistry & Photobiology and has presented papers at the Shortgrass Steppe Symposium in Fort Collins, Colorado, the Long-term Ecological Research All Scientists Meeting in Estes Park, Colorado, and participated in the NSF Site Review of the Shortgrass Steppe Long Term Ecological Research in Nunn, Colorado.  She was a National Science Foundation Fellow GK-12, and currently teaches in Bailey, Colorado.

Howard F. Horton holds an MS in Biological Sciences from the University of Northern Colorado (UNC) and a BS in Biological Sciences from Mesa State College.  He has worked on research projects in Pawnee National Grasslands, Rocky Mountain National Park, Long Term Ecological Research at Toolik Lake, Alaska, and Wind Cave, South Dakota.  He has co-authored articles in The International Journal of Speleology and The Journal of Cave and Karst Studies. He was a National Science Foundation Fellow GK-12, and is currently a District Wildlife Manager with the Colorado Division of Parks and Wildlife.

Bibliographic information

Reviews

“This book does, in general, a splendid job of showing the reader how to make statistical calculations with the aid of Excel. … The book is very useful in many other disciplines other than the physical sciences. As I read through the many examples in the book, I found that these applications permeate a wide range of topics in a variety of disciplines.” (Jeffrey E. Jarrett, Technometrics, Vol. 56 (3), August, 2014)