Find the Full Original Textbook (PDF) in the link
below:
CLICK HERE
Abstract: Statistics for Managers Using
Microsoft Excel, 9th Edition by David
Levine
Authors: David M. Levine, David F. Stephan, Kathryn
A. Szabat
Publisher: Pearson
Publication Year: 2020
Edition: Ninth Edition
ISBN: 9780135969854 (Rental Edition),
9780136847564 (Standard Edition)
Target Audience: One-semester courses in
Introduction to Business Statistics, undergraduate
and graduate business students
Overview and Distinguished Position
"Statistics for Managers Using Microsoft Excel, 9th
Edition" represents the pinnacle achievement in
business statistics education, establishing itself as
the undisputed gold standard for learning Microsoft
Excel applications in business statistical analysis.
This comprehensive textbook seamlessly integrates
statistical theory with practical Microsoft Excel
applications, creating an unparalleled educational
resource that bridges the critical gap between
academic statistical concepts and real-world
business decision-making.
The textbook's distinguished reputation stems from its
innovative approach to teaching statistics within the
specific context of business fields, making statistical
concepts immediately relevant and applicable to
students' future careers. Unlike traditional statistics
textbooks that treat software as a supplementary tool,
this work positions Microsoft Excel as the central
platform for statistical analysis, reflecting the reality
of modern business environments where Excel
proficiency in statistical applications is essential for
managerial success.
Author Expertise and Institutional Background
The textbook benefits from the combined expertise of
three distinguished academics who bring
complementary strengths to the work:
David M. Levine serves as Professor Emeritus of
Statistics and Computer Information Systems at
Baruch College (City University of New York). His
academic credentials include B.B.A. and M.B.A.
degrees in statistics from City College of New York
and a Ph.D. from New York University in industrial
engineering and operations research. Levine is
nationally recognized as a leading innovator in
statistics education and is the co-author of 14 books,
including bestselling statistics textbooks such as
"Basic Business Statistics: Concepts and
Applications," "Business Statistics: A First Course,"
and "Applied Statistics for Engineers and Scientists
Using Microsoft Excel and Minitab."
His scholarly contributions extend beyond textbook
authorship to include publications in prestigious
journals such as Psychometrika, The American
Statistician, Communications in Statistics, Decision
Sciences Journal of Innovative Education, Multivariate
Behavioral Research, Journal of Systems
Management, Quality Progress, and The American
Anthropologist. Levine has received several awards for
outstanding teaching and curriculum development
from Baruch College and has been an influential
speaker at conferences organized by the Decision
Sciences Institute (DSI), American Statistical
Association (ASA), and Making Statistics More
Effective in Schools and Business (MSMESB).
David F. Stephan brings unique expertise as an
independent instructional technologist who served for
over 20 years as an Instructor/Lecturer of Computer
Information Systems at Baruch College. His
background includes service as Assistant to the
Provost and to the Dean of the School of Business &
Public Administration for computing, where he
pioneered the use of computer classrooms for
business teaching. Stephan is the originator of PHStat,
the Pearson Education statistical add-in for Microsoft
Excel that plays a central role in the textbook's
approach.
Kathryn A. Szabat serves as Associate Professor and
Chair of Business Systems and Analytics at LaSalle
University. Her research has been published in
international journals including the International
Journal of Applied Decision Sciences, Accounting
Education, Journal of Applied Business and
Economics, Journal of Healthcare Management, and
Journal of Management Studies. She holds a B.S. in
mathematics from State University of New York at
Albany and M.S. and Ph.D. degrees in statistics with a
cognate in operations research from the Wharton
School of the University of Pennsylvania.
Pedagogical Framework and GAISE Alignment
The 9th edition is guided by principles set forth in the
American Statistical Association's Guidelines for
Assessment and Instruction in Statistics Education
(GAISE) reports, ensuring that the textbook aligns with
current best practices in statistics education. This
alignment represents a fundamental commitment to
evidence-based teaching methodologies that
emphasize conceptual understanding, active learning,
and practical application over rote memorization of
formulas and procedures.
The GAISE framework emphasizes six key
recommendations that permeate throughout the
textbook: emphasizing statistical literacy and
developing statistical thinking, using real data with
context and purpose, fostering active learning,
assessing student learning in ways that improve and
evaluate instruction, using technology to explore
concepts and analyze data, and promoting
conceptual understanding rather than mere
knowledge of procedures.
The authors' diverse teaching experiences inform
every aspect of the textbook's design, from the
selection of examples and exercises to the
organization of chapters and the integration of
technology. This pedagogical sophistication ensures
that the textbook not only presents statistical content
effectively but also models best practices for
instruction that can be adapted by educators in
various institutional contexts.
Comprehensive Content Structure and Organization
The textbook is systematically organized to provide a
logical progression from foundational concepts to
advanced applications, with each chapter building
upon previous knowledge while introducing new
complexity in manageable increments.
Foundational Framework
First Things First (FTF) - This introductory section
establishes the fundamental perspective that will
guide students throughout their statistical learning
journey:
• FTF.1 Think Differently About Statistics -
Challenges traditional perceptions of statistics as
a dry, mathematical subject by positioning it as an
essential tool for business decision-making
• FTF.2 Business Analytics: The Changing Face of
Statistics - Introduces the modern landscape of
data-driven business decision-making
• FTF.3 Starting Point for Learning Statistics -
Establishes realistic expectations and learning
objectives
• FTF.4 Starting Point for Using Software - Provides
foundational computer literacy skills
• FTF.5 Starting Point for Using Microsoft Excel -
Introduces Excel as a statistical platform
Core Statistical Foundations
Chapter 1: Defining and Collecting Data establishes
the fundamental building blocks of statistical
analysis:
• 1.1 Defining Variables - Introduces the conceptual
framework for understanding different types of
data
• 1.2 Collecting Data - Explores methodologies for
gathering reliable information
• 1.3 Types of Sampling Methods - Examines
various approaches to sample selection and their
implications
• 1.4 Data Cleaning - Addresses the practical reality
of preparing data for analysis
• 1.5 Other Data Preprocessing Tasks - Covers
additional preparation steps essential for
meaningful analysis
• 1.6 Types of Survey Errors - Identifies potential
pitfalls in data collection
Chapter 2: Organizing and Visualizing Variables
focuses on transforming raw data into meaningful
information:
• 2.1 Organizing Categorical Variables - Provides
frameworks for handling qualitative data
• 2.2 Organizing Numerical Variables - Establishes
methods for quantitative data organization
• 2.3 Visualizing Categorical Variables - Introduces
graphical representations for categorical data
• 2.4 Visualizing Numerical Variables - Explores
visualization techniques for quantitative data
• 2.5 Visualizing Two Numerical Variables -
Addresses bivariate relationships
• 2.6 Organizing a Mix of Variables - Handles
complex datasets with multiple variable types
• 2.7 Visualizing a Mix of Variables - Creates
comprehensive visual representations
• 2.8 Filtering and Querying Data - Introduces data
manipulation techniques
• 2.9 Pitfalls in Organizing and Visualizing Variables
- Identifies common errors and misinterpretations
Chapter 3: Numerical Descriptive Measures
provides the mathematical foundation for data
summarization:
• 3.1 Measures of Central Tendency - Explores
mean, median, and mode in business contexts
• 3.2 Measures of Variation and Shape - Examines
variability and distribution characteristics
• 3.3 Exploring Numerical Variables - Applies
descriptive measures to real business data
• 3.4 Numerical Descriptive Measures for a
Population - Distinguishes between sample and
population parameters
Probability and Distribution Theory
The textbook continues with comprehensive coverage
of probability theory and probability distributions,
essential foundations for inferential statistics and
business decision-making under uncertainty. These
chapters establish the theoretical framework
necessary for understanding statistical inference
while maintaining practical relevance through
business applications and Excel implementations.
Inferential Statistics and Hypothesis Testing
Advanced chapters cover the full spectrum of
inferential statistical methods commonly used in
business analysis, including confidence intervals,
hypothesis testing for single and multiple populations,
analysis of variance (ANOVA), and regression analysis.
Each statistical technique is presented within the
context of specific business scenarios, helping
students understand not just how to perform analyses
but when and why to apply particular methods.
Advanced Applications and Specialized Topics
The latter chapters address sophisticated analytical
techniques increasingly important in contemporary
business analysis, including multiple regression
analysis, time series analysis and forecasting, and the
dedicated chapter on business analytics that reflects
the growing importance of data science in business
decision-making.
Revolutionary Excel Integration
The textbook's distinguishing characteristic lies in its
comprehensive integration of Microsoft Excel
throughout the statistical learning process. This
integration goes far beyond using Excel as a
computational tool; instead, Excel becomes the lens
through which students learn to think about statistical
problems and solutions.
End-of-Chapter Excel Guides provide detailed, step-
by-step instructions for implementing each statistical
technique covered in the chapter. These guides are
written with careful attention to Excel's interface and
functionality, ensuring that students can successfully
execute analyses while understanding the underlying
statistical logic.
In-Depth Excel Step-by-Step Instructions offer
comprehensive coverage of Excel procedures, from
basic data entry and manipulation to advanced
statistical functions. These instructions are designed
to accommodate students with varying levels of Excel
experience while building toward sophisticated
analytical capabilities.
Excel Guide Workbooks provide hands-on practice
opportunities with pre-configured datasets that allow
students to focus on statistical concepts rather than
data entry. These workbooks are carefully designed to
reinforce chapter concepts while building Excel
proficiency.
PHStat Integration represents perhaps the most
innovative aspect of the textbook's approach. PHStat
is a statistical add-in system for Excel originally
developed by co-author David F. Stephan that extends
Excel's built-in statistical capabilities. PHStat
simplifies complex statistical procedures while
maintaining full transparency about the underlying
calculations, allowing students to focus on
interpretation and decision-making rather than getting
lost in computational details.
Multiple Excel Appendices provide comprehensive
reference materials for Excel functions, data analysis
tools, and PHStat procedures. These appendices
serve as valuable resources that students can use
throughout their academic careers and into their
professional lives.
Business Analytics Integration
The 9th edition includes a full chapter dedicated to
business analytics, reflecting the growing importance
of data-driven decision-making in contemporary
business environments. This chapter bridges
traditional statistical analysis with modern data
science applications, preparing students for the
evolving demands of business analysis.
The business analytics content covers essential
topics including data mining, predictive modeling, and
descriptive analytics within the context of business
applications. Students learn to apply statistical
techniques not just for hypothesis testing and
estimation but for discovering patterns, predicting
outcomes, and optimizing business processes.
This focus on business analytics aligns with current
industry trends toward evidence-based management
and quantitative decision-making. Students gain
exposure to analytical thinking that will serve them
well in careers across various business functions,
from marketing and finance to operations and
strategic planning.
Real-World Data and Current Applications
Throughout the textbook, current data throughout
gives you valuable practice analyzing the types of data
you will see in your future career. This commitment to
using contemporary, relevant datasets ensures that
students engage with realistic business scenarios
rather than artificial examples that may seem
disconnected from practical applications.
The data selections span various business sectors
and functional areas, exposing students to the
diversity of analytical challenges they will encounter in
their careers. Examples include financial data,
marketing research results, quality control
measurements, survey responses, and operational
performance metrics. This breadth of applications
helps students understand the universal applicability
of statistical methods across business disciplines.
Enhanced Learning Support Features
The textbook incorporates numerous pedagogical
features designed to support diverse learning styles
and promote deep understanding:
Friendly Writing Style with Tips and Learning Aids
creates an accessible learning environment that
reduces statistics anxiety while building confidence.
The authors' approachable tone demystifies statistical
concepts without sacrificing rigor or accuracy.
Two Online-Only Chapters extend the textbook's
coverage beyond the printed material, providing
additional depth on specialized topics or emerging
areas of statistical application. This digital extension
reflects the authors' commitment to comprehensive
coverage while maintaining a manageable printed text
length.
Digital Cases referenced throughout the text provide
extended, realistic scenarios that allow students to
apply multiple statistical techniques to complex
business problems. These cases simulate the type of
comprehensive analytical projects that characterize
professional statistical practice.
MyLab Statistics Integration provides a complete
online learning environment that extends and
reinforces textbook content. This digital platform
includes homework assignments, tutorials, and
assessment tools that adapt to individual student
needs, providing personalized learning pathways that
optimize educational outcomes.
StatCrunch Integration offers cloud-based statistical
software access that complements Excel instruction
by providing exposure to specialized statistical
software used in professional environments. This
integration ensures that students gain familiarity with
multiple analytical platforms while building
transferable statistical thinking skills.
Pedagogical Innovation and Assessment
The textbook incorporates innovative assessment
approaches that move beyond traditional testing to
evaluate students' ability to apply statistical thinking
to realistic business problems. These assessment
strategies align with GAISE recommendations for
evaluating statistical understanding rather than mere
computational ability.
Project-Based Learning opportunities throughout the
text engage students in extended analytical projects
that mirror professional statistical practice. These
projects require students to formulate questions,
collect and analyze data, and communicate findings—
skills essential for managerial success.
Technology-Enhanced Learning leverages Excel and
PHStat capabilities to allow students to focus on
interpretation and decision-making rather than
computational mechanics. This approach reflects
contemporary professional practice where software
handles calculations while analysts focus on asking
the right questions and interpreting results
appropriately.
Collaborative Learning Support provides
frameworks for group projects and peer learning that
reflect the collaborative nature of most professional
analytical work. Students learn to communicate
statistical findings effectively and to work productively
in analytical teams.
Professional Relevance and Career Preparation
The textbook's design reflects a deep understanding of
the skills and knowledge that business professionals
need for success in data-driven environments. The
authors present statistics in the context of specific
business fields, and now include a full chapter on
business analytics, ensuring that students develop
immediately applicable capabilities.
Industry-Relevant Skill Development focuses on the
analytical competencies most valued by employers,
including the ability to work with real data,
communicate findings effectively, and apply
statistical thinking to business problems. These skills
translate directly to improved job market
competitiveness and professional effectiveness.
Managerial Perspective Integration throughout the
text helps students understand how statistical
analysis fits into broader managerial decision-making
processes. Students learn not just how to perform
analyses but how to integrate analytical findings into
strategic and operational decisions.
Contemporary Business Context ensures that
examples, exercises, and applications reflect current
business realities and challenges. This contemporary
focus helps students understand the relevance of
statistical learning for their future careers while
building enthusiasm for analytical thinking.
Global Perspective and Accessibility
The availability of a Global Edition reflects the
textbook's international applicability and the universal
relevance of statistical thinking in business contexts.
While examples and applications may reflect
particular business environments, the underlying
principles and methods apply across cultural and
economic contexts.
Find the Full Original Textbook (PDF) in the link
below:
CLICK HERE