Essentials of Modern Business Statistics with Microsoft Excel

by David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran

Overview

Develop a strong conceptual understanding of statistics as ESSENTIALS OF MODERN BUSINESS STATISTICS WITH MICROSOFT EXCEL, 8E balances real-world applications with an integrated focus on the latest version of Microsoft Excel. This best-selling, essentials edition clearly develops each statistical technique in an application setting. You learn to master statistical methodology with an easy-to-follow presentation of a statistical procedure followed by a discussion of how to use Excel 2019 to perform the procedure. Step-by-step instructions and screen captures ensure understanding. More than 140 new business examples, proven methods, and application exercises show how statistics provide insights into today's business decisions and problems. A unique problem-scenario approach and new case problems demonstrate how to apply statistical methods to practical business situations. MindTap digital resources provide tools to help you master Excel, Excel Online, and R as well as gain an understanding of business statistics.

Product Details

ISBN-13:	9780357131626
Publisher:	Cengage Learning
Publication date:	01/01/2020
Series:	MindTap Course List
Edition description:	8th ed.
Pages:	816
Product dimensions:	8.50(w) x 11.00(h) x 1.40(d)

About the Author

David R. Anderson is a leading author and professor emeritus of quantitative analysis in the College of Business Administration at the University of Cincinnati. Dr. Anderson has served as head of the Department of Quantitative Analysis and Operations Management and as associate dean of the College of Business Administration. He was also coordinator of the college’s first executive program. In addition to introductory statistics for business students, Dr. Anderson taught graduate-level courses in regression analysis, multivariate analysis and management science. He also taught statistical courses at the Department of Labor in Washington, D.C. Dr. Anderson has received numerous honors for excellence in teaching and service to student organizations. He is the co-author of ten well-respected textbooks related to decision sciences and he actively consults with businesses in the areas of sampling and statistical methods. Born in Grand Forks, North Dakota, Dr. Anderson earned his B.S., M.S. and Ph.D. degrees from Purdue University.

Dennis J. Sweeney is professor emeritus of quantitative analysis and founder of the Center for Productivity Improvement at the University of Cincinnati. Born in Des Moines, Iowa, he earned a B.S.B.A. degree from Drake University and his M.B.A. and D.B.A. degrees from Indiana University, where he was an NDEA fellow. Dr. Sweeney has worked in the management science group at Procter & Gamble and has been a visiting professor at Duke University. He also served as head of the Department of Quantitative Analysis and served four years as associate dean of the College of Business Administration at the University of Cincinnati. Dr. Sweeney has published more than 30 articles and monographs in the area of management science and statistics. The National Science Foundation, IBM, Procter & Gamble, Federated Department Stores, Kroger and Cincinnati Gas & Electric have funded his research, which has been published in journals such as Management Science, Operations Research, Mathematical Programming and Decision Sciences. Dr. Sweeney has co-authored 10 textbooks in the areas of statistics, management science, linear programming and production and operations management.

N/A

Jeffrey D. Camm is the Inmar Presidential Chair of Analytics and Senior Associate Dean for Faculty in the School of Business at Wake Forest University. Born in Cincinnati, Ohio, he holds a B.S. from Xavier University (Ohio) and a Ph.D. from Clemson University. Prior to joining the faculty at Wake Forest, Dr. Camm served on the faculty of the University of Cincinnati. He has also been a visiting scholar at Stanford University and a visiting professor of business administration at the Tuck School of Business at Dartmouth College. Dr. Camm has published more than 45 papers in the general area of optimization applied to problems in operations management and marketing. He has published his research in Science, Management Science, Operations Research, The INFORMS Journal on Applied Analytics and other professional journals. Dr. Camm was named the Dornoff Fellow of Teaching Excellence at the University of Cincinnati and he was the recipient of the 2006 INFORMS Prize for the Teaching of Operations Research Practice. A firm believer in practicing what he preaches, he has served as a consultant to numerous companies and government agencies. Dr. Camm served as editor-in-chief of INFORMS Journal on Applied Analytics and is an INFORMS fellow.

James J. Cochran is Professor of Applied Statistics, the Mike and Cathy Mouron Research Chair and Associate Dean for Faculty and Research at the University of Alabama. Born in Dayton, Ohio, he earned his B.S., M.S. and M.B.A. degrees from Wright State University and his Ph.D. from the University of Cincinnati. Dr. Cochran has served at The University of Alabama since 2014 and has been a visiting scholar at Stanford University, Universidad de Talca, the University of South Africa and Pole Universitaire Leonard de Vinci. Dr. Cochran has published more than 50 papers in the development and application of operations research and statistical methods. He has published his research in Management Science, The American Statistician, Communications in Statistics-Theory and Methods, Annals of Operations Research, European Journal of Operational Research, Journal of Combinatorial Optimization, INFORMS Journal on Applied Analytics, BMJ Global Health and Statistics and Probability Letters. He was the 2008 recipient of the INFORMS Prize for the Teaching of Operations Research Practice and the 2010 recipient of the Mu Sigma Rho Statistical Education Award. He received the Founders Award in 2014 and the Karl E. Peace Award in 2015 from the American Statistical Association. In 2017 he received the American Statistical Association’s Waller Distinguished Teaching Career Award and in 2018 he received the INFORMS President’s Award. Dr. Cochran is an elected member of the International Statistics Institute, a fellow of the American Statistical Association and a fellow of INFORMS. A strong advocate for effective statistics and operations research education as a means of improving the quality of applications to real problems, Dr. Cochran has organized and chaired teaching workshops throughout the world.

Table of Contents

1. Data and Statistics. 2. Descriptive Statistics: Tabular and Graphical Displays. 3. Descriptive Statistics: Numerical Measures. 4. Introduction to Probability. 5. Discrete Probability Distributions. 6. Continuous Probability Distributions. 7. Sampling and Sampling Distributions. 8. Interval Estimation. 9. Hypothesis Tests. 10. Inferences About Means and Proportions with Two Populations. 11. Inferences About Population Variances. 12. Test of Goodness of Fit, Independence, and Multiple Proportions. 13. Experimental Design and Analysis of Variance. 14. Simple Linear Regression. 15. Multiple Regression. Appendix A: References and Bibliography. Appendix B: Tables. Appendix C: Summation Notation. Appendix D: Self-Test Solutions and Answers to Even-Numbered Exercises (online). Appendix E: Microsoft Excel 2016 and Tools for Statistical Analysis.