Applied Statistics for Business and Management using Microsoft Excel

This book illustrates 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.

The 2nd edition of 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.

.- Statistics and Data.
.- Summarizing Data.
.- Descriptive Statistics and Graphing.
.- Normal World.
.- Survey Design.
.- Sampling.
.- Inference.
.- Probability.
.- Correlation.
.- Simple Linear Regression.
.- Multiple Regression.
.- Significance Tests.
.- Non Linear Regression.
.- Survey Reports.

Linda Herkenhoff is currently a full professor and Director of both the Online MBA and the Global MBA at Saint Mary’s College in Moraga, California, where she teaches Quantitative Analysis, Qualitative Analysis and Mixed Methods. 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 was the former Founder and President of Sentenium, Inc. This company was sold to Research America, 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 tenured professor with the Department of Business at Diablo Valley College and is the Marketing Program Lead. He earned his B.S. from University of California, Berkeley and an MBA from the University of San Francisco.