I'm a student
I'm an educator
Request full copy

Elementary Statistics Using Excel, 7th edition

Published by Pearson (May 8, 2021) © 2022

  • Mario F. Triola Dutchess Community College

eTextbook

per month

  • Anytime, anywhere learning with the Pearson+ app
  • Easy-to-use search, navigation and notebook
  • Simpler studying with flashcards
$79.99

  • Hardcover, paperback or looseleaf edition
  • Affordable rental option for select titles
  • Free shipping on looseleafs and traditional textbooks

MyLab

from$99.99

  • Reach every student with personalized support
  • Customize courses with ease
  • Optimize learning with dynamic study tools

For Introductory Statistics courses.

Real data brings statistics to life

From cybersecurity to drones and more, statistics shapes the world around us. Elementary Statistics Using Excel offers current applications and abundant real data to help students of all majors understand the role of statistics in our lives. The 7th Edition is more relevant and supportive than ever; a wealth of new data sets, exercises and examples along with larger data sets, content updates and new videos support students.

Elementary Statistics Using Excel is part of a series that includes an Essentials version along with Elementary Statistics Using the TI-83/84 Plus Calculator and Elementary Statistics.

Hallmark features of this title

  • Section 1-4 introduces important and basic features of using Excel.
  • Detailed Excel instructions are included throughout.
  • More than 300 displays of Excel functions and results are included throughout.
  • Exercises that are suitable for use with Excel are identified with a special icon.
  • A concise list of Excel Quick References at the end of the text includes brief commands for executing most of the key statistical methods used. The Excel Quick References are located at the end of the text.
  • Excel Projects: The wide variety of end-of-chapter features includes special Excel Projects.

New and updated features of this title

  • Updated real data: The vast majority of exercises, examples and Chapter Problems are based on real data for maximum relevance. 93% of the exercises use real data and 64% of exercises are new, keeping the problems current.
  • Expanded data sets in Appendix B have increased from 32 to 46 total, with 20 new to the 7th Edition, including Internet Traffic, Disney World Wait Times, Car Data, Commute Times, Candies, and Taxi Data.
  • Larger data sets include sets with 6068, 3982, 5755, 8959, and 1000 cases, as well as big data sets with 465,506 cases and 31,784 cases. Working with larger data sets is essential to students progressing into the age of big data and data science.
  • New Big (or Very Large) Data Projects appear near the end of each chapter.
  • All new Chapter Problems open each chapter, using real data to motivate students about concepts; they are revisited within the chapter. New Chapter Problem icons mark examples that relate to the Chapter Problem, showing how different concepts and procedures can be applied to the real-world issue in the material.
  • Revised Margin Essays: 134 margin essays highlight real-world topics and foster student interest; 36 are new to this edition. Also, many Go Figure items briefly describe interesting numbers or statistics.

Features of MyLab Statistics for the 7th Edition

  • Integrated Review embeds prerequisite review which can be used for just-in-time remediation or for corequisite course models. Pre-made Skills Check quizzes assess skills needed to succeed and identify gaps for each student.
    • Videos, worksheets and personalized practice offer just-in-time remediation. Added instruction within students' personalized review homework also includes videos and worksheets as learning aids for relevant exercises for remediation right where they need it.
  • Comprehensive video program:
    • New Animated Flow Charts bring the flow charts from the book to life and can now be assigned with new exercises in the MyLab. Updated  Chapter Review Videos cover Review Exercises and have been updated to match any new Review Exercises in the text. 
    • Section Lecture Videos  work through examples and elaborate on key objectives of the chapter. Chapter Test Videos are available for each chapter test problem in complete, worked-out video solutions either solved by hand, using the TI-84C or StatCrunch. 
  • Real-World Data Examples are extensively updated for the 7th Edition. In the MyLab, all data sets are available for easy download for any statistical software.

1. Introduction to Statistics

  • 1.1 Statistical and Critical Thinking
  • 1.2 Types of Data
  • 1.3 Collecting Sample Data
  • 1.4 Ethics in Statistics (download only)

2. Exploring Data with Tables and Graphs

  • 2.1 Frequency Distributions for Organizing and Summarizing Data
  • 2.2 Histograms
  • 2.3 Graphs That Enlighten and Graphs That Deceive
  • 2.4 Scatterplots, Correlation, and Regression

3. Describing, Exploring, and Comparing Data

  • 3.1 Measures of Center
  • 3.2 Measures of Variation
  • 3.3 Measures of Relative Standing and Boxplots

4. Probability

  • 4.1 Basic Concepts of Probability
  • 4.2 Addition Rule and Multiplication Rule
  • 4.3 Complements, Conditional Probability, and Bayes' Theorem
  • 4.4 Counting
  • 4.5 Simulations for Hypothesis Tests

5. Discrete Probability Distributions

  • 5.1 Probability Distributions
  • 5.2 Binomial Probability Distributions
  • 5.3 Poisson Probability Distributions

6. Normal Probability Distributions

  • 6.1 The Standard Normal Distribution
  • 6.2 Real Applications of Normal Distributions
  • 6.3 Sampling Distributions and Estimators
  • 6.4 The Central Limit Theorem
  • 6.5 Assessing Normality
  • 6.6 Normal as Approximation to Binomial (download only)

7. Estimating Parameters and Determining Sample Sizes

  • 7.1 Estimating a Population Proportion
  • 7.2 Estimating a Population Mean
  • 7.3 Estimating a Population Standard Deviation or Variance
  • 7.4 Bootstrapping: Using Technology for Estimates

8. Hypothesis Testing

  • 8.1 Basics of Hypothesis Testing
  • 8.2 Testing a Claim About a Proportion
  • 8.3 Testing a Claim About a Mean
  • 8.4 Testing a Claim About a Standard Deviation or Variance
  • 8.5 Resampling: Using Technology for Hypothesis Testing

9. Inferences from Two Samples

  • 9.1 Two Proportions
  • 9.2 Two Means: Independent Samples
  • 9.3 Matched Pairs
  • 9.4 Two Variances or Standard Deviations
  • 9.5 Resampling: Using Technology for Inferences

10. Correlation and Regression

  • 10.1 Correlation
  • 10.2 Regression
  • 10.3 Prediction Intervals and Variation
  • 10.4 Multiple Regression
  • 10.5 Nonlinear Regression

11. Goodness-of-Fit and Contingency Tables

  • 11.1 Goodness-of-Fit
  • 11.2 Contingency Tables

12. Analysis of Variance

  • 12.1 One-Way ANOVA
  • 12.2 Two-Way ANOVA

13. Nonparametric Tests

  • 13.1 Basics of Nonparametric Tests
  • 13.2 Sign Test
  • 13.3 Wilcoxon Signed-Ranks Test for Matched Pairs
  • 13.4 Wilcoxon Rank-Sum Test for Two Independent Samples
  • 13.5 Kruskal-Wallis Test for Three or More Samples
  • 13.6 Rank Correlation
  • 13.7 Runs Test for Randomness

14. Statistics Process Control

  • 14.1 Control Charts for Variation and Mean
  • 14.2 Control Charts for Attributes

15. Holistic Statistics

APPENDICES

A: TABLES

B: DATA SETS

C: WEBSITES AND BIBLIOGRAPHY OF BOOKS

D: ANSWERS TO ODD-NUMBERED SECTION EXERCISES (and all Quick Quizzes, all Review Exercises, and all Cumulative Review Exercises)

Credits

Index

About our author

Mario F. Triola is a Professor Emeritus of Mathematics at Dutchess Community College, where he has taught statistics for over 30 years. Marty also is the author of Elementary Statistics, 14th Edition and Elementary Statistics Using the TI-83/84 Plus Calculator, 5th Edition. He is a coauthor of Biostatistics for the Biological and Health Sciences, 2nd Edition, Statistical Reasoning for Everyday Life, 5th Edition, and Business Statistics. Essentials of Statistics is currently available as a Global Edition, and it has been translated into several foreign languages.

Marty designed the original Statdisk statistical software, and he has written several manuals and workbooks for technology supporting statistics education. He has been a speaker at many conferences and colleges. Marty's consulting work includes the design of casino slot machines and fishing rods. He has worked with attorneys in determining probabilities in paternity lawsuits, analyzing data in medical malpractice lawsuits, identifying salary inequities based on gender, and analyzing disputed election results. He has also used statistical methods in analyzing medical school surveys, analyzing survey results for the New York City Transit Authority, and analyzing COVID-19 virus data for government officials. Marty has testified as an expert witness in the New York State Supreme Court. The Text and Academic Authors Association has awarded Marty a “Texty” for Excellence for his work on Elementary Statistics; as of this writing, Elementary Statistics has been the #1 statistics book in the United States for the past 25 years.

Need help? Get in touch

MyLab

Customize your course to teach your way. MyLab® is a flexible platform merging world-class content with dynamic study tools. It takes a personalized approach designed to ignite each student's unique potential. And, with the freedom it affords to adapt your pedagogy, you can reinforce select concepts and guide students to real results.

Pearson+

All in one place. Pearson+ offers instant access to eTextbooks, videos and study tools in one intuitive interface. Students choose how they learn best with enhanced search, audio and flashcards. The Pearson+ app lets them read where life takes them, no wi-fi needed. Students can access Pearson+ through a subscription or their MyLab or Mastering course.

Video
Play
Privacy and cookies
By watching, you agree Pearson can share your viewership data for marketing and analytics for one year, revocable by deleting your cookies.

Video transcript (PDF | 25KB) 

Empower your students, in class and beyond

Meet students where they are with MyLab®, and capture their attention in every lecture, activity, and assignment using immersive content, customized tools, and interactive learning experiences in your discipline.

Digital Learning NOW

Extend your professional development and meet your students where they are with free weekly Digital Learning NOW webinars. Attend live, watch on-demand, or listen at your leisure to expand your teaching strategies. Earn digital professional development badges for attending a live session.

Explore webinars