Skip to main content
  • Textbook
  • © 2013

Applied Statistics for Business and Management using Microsoft Excel

  • Offers real-world case studies in a user-friendly learning format to drive home key theories and lessons
  • Provides an applied approach for statisticians looking to implement Excel 2010 within a professional setting
  • Contains numerous practice problems following each chapter with solutions at the back of the book
  • Includes additional supplemental content in the form of appendices and tutorials
  • Includes supplementary material: sn.pub/extras

Buy it now

Buying options

eBook USD 84.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

This is a preview of subscription content, log in via an institution to check for access.

Table of contents (15 chapters)

  1. Front Matter

    Pages i-xiv
  2. Data and Statistics

    • Linda Herkenhoff, John Fogli
    Pages 1-9
  3. Introduction to Excel and Basic Charts

    • Linda Herkenhoff, John Fogli
    Pages 11-45
  4. Summarizing Data: Descriptive Statistics and Histograms

    • Linda Herkenhoff, John Fogli
    Pages 47-78
  5. Normal Distributions

    • Linda Herkenhoff, John Fogli
    Pages 79-116
  6. Survey Design

    • Linda Herkenhoff, John Fogli
    Pages 117-141
  7. Sampling

    • Linda Herkenhoff, John Fogli
    Pages 143-160
  8. Inference

    • Linda Herkenhoff, John Fogli
    Pages 161-182
  9. Probability

    • Linda Herkenhoff, John Fogli
    Pages 183-204
  10. Correlation

    • Linda Herkenhoff, John Fogli
    Pages 205-220
  11. Simple Linear Regression

    • Linda Herkenhoff, John Fogli
    Pages 221-247
  12. Significance Tests Part 1

    • Linda Herkenhoff, John Fogli
    Pages 249-307
  13. Significance Tests Part 2

    • Linda Herkenhoff, John Fogli
    Pages 309-353
  14. Multiple Regression

    • Linda Herkenhoff, John Fogli
    Pages 355-370
  15. Non-linear Regression

    • Linda Herkenhoff, John Fogli
    Pages 371-390
  16. Survey Reports

    • Linda Herkenhoff, John Fogli
    Pages 391-414
  17. Back Matter

    Pages 415-417

About this book

Applied Business Statistics for Business and Management using Microsoft Excel is the first book to illustrate the capabilities of Microsoft Excel to teach applied statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical statistical problems in industry. 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. Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in statistics courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Applied Business Statistics for Business and Management capitalizes on these improvements by teaching students and practitioners how to apply Excel to statistical techniques necessary in their courses and workplace. Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand business problems. Practice problems are provided at the end of each chapter with their solutions.

Authors and Affiliations

  • Saint Mary's College, Orinda, USA

    Linda Herkenhoff

  • Sentenium Inc., Pleasant Hill, USA

    John Fogli

About the authors

Linda Herkenhoff is currently a full professor and director of the Transglobal MBA program at Saint Mary’s College in Moraga, California, where she teaches Quantitative Analysis and Statistics. She is the former Executive Director of Human Resources for Stanford University. The first sixteen years of her career included various responsibilities within Chevron Corporation, primarily as a geophysicist. She has lived/worked/conducted research in over 30 countries and has spent time on all 7 continents.

 

John Fogli is the Founder and President of Sentenium, Inc.  John's business research methods have helped public and private industries better understand the involvement necessary to lead consensus solutions. He has facilitated over 500 survey projects in the areas of consumer, employee, political, and operation(s) research. He is a member of the Market Research Association and holds a Professional Research Certificate. He is currently a part-time faculty member with the Department of Business at Diablo Valley College and sits on the Executive Council for The Pacific Chapter of American Association for Public Opinion Research. He earned his B.S. from University of California, Berkeley and an MBA from the University of San Francisco.

Bibliographic Information

Buy it now

Buying options

eBook USD 84.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access