Table of Contents
Teaching Tips...................................................................................................................................1
Chapter 1 Defining and Collecting Data............................................................................................... 39
Chapter 2 Organizing and Visualizing Variables ................................................................................. 46
Chapter 3 Numerical Descriptive Measures ..................................................................................... ..141
Chapter 4 Basic Probability ................................................................................................................ 183
Chapter 5 Discrete Probability Distributions ...................................................................................... 190
Chapter 6 The Normal Distribution and Other Continuous Distributions .......................................... 215
Chapter 7 Sampling Distributions....................................................................................................... 241
Chapter 8 Confidence Interval Estimation.......................................................................................... 261
Chapter 9 Fundamentals of Hypothesis Testing: One-Sample Tests.................................................. 292
Chapter 10 Two-Sample Tests............................................................................................................. 337
Chapter 11 Analysis of Variance .......................................................................................................... 415
Chapter 12 Chi-Square and Nonparametric Tests ................................................................................ 441
Chapter 13 Simple Linear Regression .................................................................................................. 482
Chapter 14 Introduction to Multiple Regression .................................................................................. 521
Chapter 15 Multiple Regression Model Building ................................................................................. 584
Chapter 16 Time-Series Forecasting..................................................................................................... 641
Chapter 17 Getting Ready to Analyze Data in the Future .................................................................... 696
Chapter 18 Statistical Applications in Quality Management (Online) ................................................. 748
Chapter 19 Decision Making (Online).................................................................................................. 781
Online Sections .................................................................................................................. 820
Instructional Tips and Solutions for Digital Cases............................................................. 883
The Brynne Packaging Case .............................................................................................. 918
The CardioGood Fitness Case ........................................................................................... 920

The Choice Is Yours/More Descriptive Choices Follow-up Case .................................... 1043
The Clear Mountain State Student Surveys Case ............................................................. 1130
The Craybill Instrumentation Company Case.................................................................. 1230
The Managing Ashland MultiComm Services Case ......................................................... 1232
The Mountain States Potato Company Case .................................................................... 1287
The Sure Value Convenience Stores Case........................................................................ 1296

Preface
The first part of the Instructor’s Solutions Manual contains our educational philosophy and teaching tips
for each chapter of the text. Solutions to End-of-Section Problems and Chapter Review Problems in each
chapter follow. Instructional tips and solutions for the digital cases are included next. Answers to the
Brynne Packaging Case, the CardioGood Fitness Case, the Choice Is Yours/More Descriptive Choices
Follow-up Case, the Clear Mountain State Student Surveys Case, the Craybill Instrumentation Company
Case, the Managing Ashland MultiComm Services Case, the Mountain States Potato Company Case and
the Sure Value Convenience Stores Case are included last.
The purpose of this Instructor’s Solutions Manual is to facilitate grading of assignments or exams by
instructors and/or teaching assistants. Screen shots using output from PHStat are integrated throughout.
Most of the problems are solved using PHStat. To present the steps involved in solving a problem, some
intermediate numerical results are presented accurate to only a reasonable number of significant digits.
Hence, instructors are reminded that the final results presented in this manual that are obtained using
PHStat can sometimes be different from those obtained with a hand calculator computed using the
intermediate values due to rounding.

Teaching Tips for
Statistics for Managers using Microsoft® Excel 8th Edition,
Global Edition
Our Starting Point
Over a generation ago, advances in “data processing” led to new business opportunities as first
centralized and then desktop computing proliferated. The Information Age was born. Computer
science became much more than just an adjunct to a mathematics curriculum, and whole new
fields of studies, such as computer information systems, emerged.
More recently, further advances in information technologies have combined with data
analysis techniques to create new opportunities in what is more data science than data processing
or computer science. The world of business statistics has grown larger, bumping into other
disciplines. And, in a reprise of something that occurred a generation ago, new fields of study,
this time with names such as informatics, data analytics, and decision science, have emerged.
This time of change makes what is taught in business statistics and how it is taught all the
more critical. These new fields of study all share statistics as a foundation for further learning.
We are accustomed to thinking about change, as seeking ways to continuously improve the
teaching of business statistics have always guided our efforts. We actively participate in Decision
Sciences Institute (DSI), American Statistical Association (ASA), and Making Statistics More
Effective in Schools and Business (MSMESB) conferences. We use the ASA’s Guidelines for
Assessment and Instruction (GAISE) reports and combine them with our experiences teaching
business statistics to a diverse student body at several large universities.
What to teach and how to teach it are particularly significant questions to ask during a time of
change. As an author team, we bring a unique collection of experiences that we believe helps us
find the proper perspective in balancing the old and the new. Our lead author, David M. Levine,
was the first educator, along with Mark L. Berenson, to create a business statistics textbook that

Loading page 6...

Loading page 7...

Loading page 8...

Loading page 9...

Loading page 10...

Loading page 11...

Loading page 12...

Loading page 13...

Loading page 14...

Loading page 15...

Loading page 16...

Loading page 17...

Loading page 18...

Loading page 19...

Loading page 20...

Loading page 21...

Loading page 22...

Loading page 23...

Loading page 24...

Loading page 25...

Loading page 26...

Loading page 27...

Loading page 28...

Loading page 29...

Loading page 30...

Loading page 31...

Statistics for Managers Using Microsoft Excel 8th Edition Solution Manual

Study Now!

Document Details

Related Documents

Solution Manual For Statistics for Managers Using Microsoft Excel, 7th Edition

Test Bank For Success at Statistics: A Worktext with Humor, 6th Edition

Diagnostic and Statistical Manual of Mental Disorders 5th Edition Test Bank

Test Bank For Elementary Statistics, 3rd Edition

Elementary Statistics, 13th Edition Test Bank

Test Bank for Business Statistics: A First Course, 3rd Edition

Statistical Reasoning for Everyday Life, 5th Edition Test Bank

Test Bank for Business Statistics: A Decision-Making Approach, 10th Edition

Elementary Statistics Using Excel, 6th Edition Test Bank

Fundamentals of Statistics, 5th Edition Test Bank

Company

Explore

Study Tools