Pearson - Elementary Statistics Using Excel, 3/E

Pearson

Always Learning

Browse by discipline

Humanities & Social Sciences

Math & Science

Professional & Career

Elementary Statistics Using Excel, 3/E
Mario F. Triola, Dutchess Community College

ISBN-10: 0321365135
ISBN-13: 9780321365132

Publisher: Pearson
Copyright: 2007
Format: Cloth Bound with Disk; 948 pp
Published: 06/19/2006

Print this content

In this section:

Description

Together we can raise confidence to a new level. Triola's Elementary Statistics Using Excel, Third Edition, promotes statistical literacy and critical thinking, using Excel as the key tool. This book guides students through the concepts behind the calculations, raising confidence in their ability to do statistics.

Elementary Statistics Using Excel, Third Edition, is a complete introduction to basic statistics, featuring extensive instruction on the use of Excel spreadsheet technology for the analysis of data. Topics are presented with illustrative examples, many of which use real data. The text also identifies required assumptions. Extensive Excel instructions are provided along with typical displays of results, as well as information about Excel's limitations and alternative approaches to problem-solving. The CD-ROM included with each copy of the book contains: DDXL (Version 2.0), a software add-in that enhances and expands the capability of Excel, and Appendix B data sets in the form of Excel workbooks.

Datasets and other resources (where applicable) for this book are available here.

Features

Highlights of the Third Edition:

Extensive Excel instruction: Section 1.5 of the text introduces important and basic features of using Excel. The text also includes 122 Excel displays and instruction so that Excel can be used more effectively.
Chapter-opening features: A list of chapter sections previews the chapter for the student; a chapter-opening problem, using real data, then motivates the chapter material; and the first section is a chapter overview that provides a statement of the chapter's objectives.
Interpreting Results: Throughout the book there is strong emphasis on interpreting results. Instead of simply obtaining answers, students are asked to make sense of the results and, where appropriate, state a practical conclusion. Worked examples in the text model this approach.
Margin Essays: 122 margin essays illustrate uses and abuses of statistics in real, practical, and interesting applications.
Technology Icons: Exercises using Excel are clearly identified.
Excel Projects: These projects are included among the variety of end-of-chapter features.
Interviews: Author-conducted interviews with professional men and women in a variety of fields who use statistics in their day-to-day work appear in every chapter.
Data Sets: Appendix B includes 18 large data sets, including 7 that are new.
Appendix C: Lists basic functions along with references of key Excel commands.
Appendix F Answers: Answers are shown with values found from both Excel and tables.
End-of-chapter Features:

o A Chapter Review summarizing the key concepts and topics of the chapter

o Statistical Literacy and Critical Thinking exercises

o Review Exercises offering practice on the chapter concepts and procedures

o Cumulative Review Exercises reinforcing earlier material

o From Data to Decision: Critical Thinking capstone problems, Cooperative Group Activities, and Excel Projects

o Internet Projects involving students with Internet data sets and, in some cases, applets

Quick-Reference Endpapers: Tables A-2 and A-3 (the normal and t distributions) are reproduced on the front inside cover pages. A symbol table is included at the back of the book for quick and easy reference to key symbols.
Installation Instructions: Instructions are provided for installing Excel's Data Analysis add-in.
CD-ROM: Qualified adopters receive a CD-ROM containing the Appendix B data sets in electronic formats for Minitab®, Excel, the TI-83/84 Plus, STATDISK®, SAS, and SPSS; STATDISK (Version 10.0) statistical software; DDXL (Version 2.0), an Excel add-in; and TI-83/84 Programs. Instructions are provided for installing Excel's Data Analysis add-in on the CD's Read Me files.

New To This Edition

New! Top 20 Topics in Statistics are marked in the text by icons that highlight these essential topics. Additional resources for these concepts are included in MyStatLab
New! Requirement check: When appropriate, solutions begin with a formal check of the requirements that must be verified before a particular method should be used.
Statistical Literacy and Critical Thinking: Each exercise section begins with four new exercises that specifically involve statistical literacy and critical thinking. Also, the end of each chapter has another four exercises of this type.
New! There are over 1750 exercises—68 percent of them new! More exercises use smaller data sets, and many require interpretation of results.
Real data: 63% of the exercises use real data.

Table of Contents

Chapter 1 Introduction to Statistics

1-1 Overview

1-2 Types of Data

1-3 Critical Thinking

1-4 Design of Experiments

1-5 Introduction to Excel

Chapter 2 Summarizing and Graphing Data

2-1 Overview

2-2 Frequency Distributions

2-3 Histograms

2-4 Statistical Graphics

Chapter 3 Statistics for Describing, Exploring, and Comparing Data

3-1 Overview

3-2 Measures of Center

3-3 Measures of Variation

3-4 Measures of Relative Standing

3-5 Exploratory Data Analysis (EDA)

Chapter 4 Probability

4-1 Overview

4-2 Fundamentals

4-3 Addition Rule

4-4 Multiplication Rule: Basics

4-5 Multiplication Rule: Complements and Conditional Probability

4-6 Probabilities Through Simulations

4-7 Counting

4-8 Bayes’ Theorem (on CD-ROM)

Chapter 5 Probability Distributions

5-1 Overview

5-2 Random Variables

5-3 Binomial Probability Distributions

5-4 Mean, Variance, and Standard Deviation for the Binomial
Distribution

5-5 The Poisson Distribution

Chapter 6 Normal Probability Distributions

6-1 Overview

6-2 The Standard Normal Distribution

6-3 Applications of Normal Distributions

6-4 Sampling Distributions and Estimators

6-5 The Central Limit Theorem

6-6 Normal as Approximation to Binomial

6-7 Assessing Normality

Chapter 7 Estimates and Sample Sizes

7-1 Overview

7-2 Estimating a Population Proportion

7-3 Estimating a Population Mean: δ Known

7-4 Estimating a Population Mean: δ Not Known

7-5 Estimating a Population Variance

Chapter 8 Hypothesis Testing

8-1 Overview

8-2 Basics of Hypothesis Testing

8-3 Testing a Claim about a Proportion

8-4 Testing a Claim about a Mean: δ Known

8-5 Testing a Claim about a Mean: δ Not Known

8-6 Testing a Claim about Variation

Chapter 9 Inferences from Two Samples

9-1 Overview

9-2 Inferences about Two Proportions

9-3 Inferences about Two Means: Independent Samples

9-4 Inferences from Matched Pairs

9-5 Comparing Variation in Two Samples

Chapter 10 Correlation and Regression

10-1 Overview

10-2 Correlation

10-3 Regression

10-4 Variation and Prediction Intervals

10-5 Multiple Regression

10-6 Modeling

Chapter 11 Multinomial Experiments and Contingency Tables

11-1 Overview

11-2 Multinomial Experiments: Goodness- f-Fit

11-3 Contingency Tables: Independence and Homogeneity

11-4 McNemar’s Test for Matched Pairs

Chapter 12 Analysis of Variance

12-1 Overview

12-2 One-Way ANOVA

12-3 Two-Way ANOVA

Chapter 13 Nonparametric Statistics

13-1 Overview

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

13-6 Rank Correlation

13-7 Runs Test for Randomness

Chapter 14 Statistical Process Control

14-1 Overview

14-2 Control Charts for Variation and Mean

14-3 Control Charts for Attributes

Chapter 15 Projects, Procedures, Perspectives

15-1 Projects

15-2 Procedures

15-3 Perspectives

Appendices

Appendix A: Tables

Appendix B: Data Sets

Appendix C: Excel References

Appendix D: Glossary

Appendix E: Bibliography

Appendix F: Answers to Odd-Numbered Exercises (and All Review
Exercises and All Cumulative Review Exercises)

Credits

Courses

Introductory Statistics - Algebra-Based (Statistics)

Next Edition(s)

Elementary Statistics Using Excel, 4/E
Triola
©2010 | Pearson | Cloth Bound w/CD-ROM; 928 pp | Instock
ISBN-10: 0321564960 | ISBN-13: 9780321564962
Net price: $120.00 (What's this?)Brief Description |

Elementary Statistics Using Excel, Fourth Edition, offers a complete introduction to basic statistics, featuring extensive instruction on the use of Excel spreadsheets for data analysis. Extensive Excel^® instructions are provided along with typical displays of results, as well as information about Excel's limitations and alternative approaches to problem-solving. Real data in many examples help readers see the prevalence of statistics in the real world.

The CD-ROM included with each copy of the book contains: DDXL (Version 2.0), a software add-in that enhances and expands the capability of Excel, and Appendix B data sets in the form of Excel workbooks.

Datasets and other resources (where applicable) for this book are available here.
More Info

Print this content

In this section:

ActivStats
Author Bios

Author Bios

Mario F. Triola is a Professor Emeritus of Mathematics at Dutchess Community College, where he has taught statistics for over 30 years. Marty is the author of Essentials of Statistics, Elementary Statistics Using Excel, Elementary Statistics Using the Graphing Calculator, and he is a co-author of Biostatistics for the Biological and Health Sciences, Statistical Reasoning for Everyday Life and Business Statistics. He has written several manuals and workbooks for technology supporting statistics education. Outside of the classroom, Marty has been a speaker at many conferences and colleges. His consulting work includes the design of casino slot machines and fishing rods, and he has worked with attorneys in determining probabilities in paternity lawsuits, identifying salary inequities based on gender, analyzing disputed election results, analyzing medical data, and analyzing medical school surveys. Marty has testified as an expert witness in New York State Supreme Court. The Text and Academic Authors Association has awarded Mario F. Triola a "Texty" for Excellence for his work on Elementary Statistics.

Print this content

In this section:

Websites and Online Courses

Websites and Online Courses

Companion Website for Elementary Statistics, 10/E
Triola
©2007 | Pearson | On-line Supplement | Live
ISBN-10: 0321369076 | ISBN-13: 9780321369079

Show Downloadable Files

More Info

MathXL -- Instant Access -- for Elementary Statistics Using Excel, 3/E
Triola
©2007 | Pearson | On-line Supplement | Live
ISBN-10: 032141098X | ISBN-13: 9780321410986
Online purchase price: $50.00More Info

Print this content

In this section:

Instructor Resources

Downloadable Instructor Resources
Other Instructor Resources

Student Resources

Websites and online courses

eLearning & Assessment

Websites and Online Courses

Course & Discipline Resources

For Introductory Statistics - Algebra-Based

Insider's Guide to Teaching with the Triola Statistics Series, 10/E
Triola
©2008 | Pearson | Paper; 132 pp | Instock
ISBN-10: 0321409647 | ISBN-13: 9780321409645

Show Downloadable Files

More Info

Instructor's Solutions Manual for Elementary Statistics Using Excel, 3/E
Triola
©2007 | Pearson | Paper | Out of Stock
ISBN-10: 0321365143 | ISBN-13: 9780321365149

Show Downloadable Files

More Info

Companion Website for Elementary Statistics, 10/E
Triola
©2007 | Pearson | On-line Supplement | Live
ISBN-10: 0321369076 | ISBN-13: 9780321369079

Show Downloadable Files

More Info

Websites and online courses

Companion Website for Elementary Statistics, 10/E
Triola
©2007 | Pearson | On-line Supplement | Live
ISBN-10: 0321369076 | ISBN-13: 9780321369079

Show Downloadable Files

More Info

For Introductory Statistics - Algebra-Based

Excel 2007 with DDXL Study Card for Statistics
Priestly
©2009 | Pearson | Study Card; 6 pp | Instock
ISBN-10: 0321592808 | ISBN-13: 9780321592804
Suggested retail price: $4.00Net price: $3.00 (What's this?)More Info

Excel 2010 with XLStat Study Card
Pearson
©2012 | Pearson | Study Card; 6 pp | Instock
ISBN-10: 0321747755 | ISBN-13: 9780321747754
Suggested retail price: $4.00Net price: $3.00 (What's this?)More Info

Graphing Calculator Study Card for Statistics
McDonald-Newman
©2009 | Pearson | Study Card | Instock
ISBN-10: 0321570774 | ISBN-13: 9780321570772
Suggested retail price: $4.00Net price: $3.00 (What's this?)More Info

IBM® SPSS® Statistics Student Version Study Card for Statistics
Priestly
©2009 | Pearson | Study Card | Instock
ISBN-10: 0321589793 | ISBN-13: 9780321589798
Suggested retail price: $4.00Net price: $3.00 (What's this?)More Info

JMP® Study Card for Statistics
Priestly
©2009 | Pearson | Study Card; 6 pp | Instock
ISBN-10: 0321592816 | ISBN-13: 9780321592811
Suggested retail price: $4.00Net price: $3.00 (What's this?)More Info

Minitab® Study Card for Statistics
Priestly
©2010 | Pearson | Study Card | Instock
ISBN-10: 0321592824 | ISBN-13: 9780321592828
Suggested retail price: $4.00Net price: $3.00 (What's this?)More Info

R Study Card for Statistics
Reimherr
©2009 | Pearson | Study Card | Instock
ISBN-10: 0321592832 | ISBN-13: 9780321592835
Suggested retail price: $4.00Net price: $3.00 (What's this?)More Info

StatCrunch Study Card
West
©2010 | Pearson | Study Card | Instock
ISBN-10: 0321628926 | ISBN-13: 9780321628923
Suggested retail price: $4.00Net price: $3.00 (What's this?)More Info

XLStat for Pearson Education Access Code Card
Addinsoft
©2011 | Pearson | Access Code Card | Instock
ISBN-10: 032175932X | ISBN-13: 9780321759320
Suggested retail price: $10.00Net price: $10.00 (What's this?)More Info

Websites and Online Courses

Companion Website for Elementary Statistics, 10/E
Triola
©2007 | Pearson | On-line Supplement | Live
ISBN-10: 0321369076 | ISBN-13: 9780321369079

Show Downloadable Files

More Info

Password:

Forgot login/password? | Need to redeem an access code?

We're sorry!

We don't recognize your login or password. Please try again.

If you continue to have problems, try retrieving your login name password or contacting Customer Technical Support.

We're sorry!

The account you used to log in on the previous website does not contain IRC access.
If you have a separate IRC count, please log in using that login name and password.
If you do not have an IRC account, you canrequest access here

close window

Your access will expire soon.

To ensure uninterrupted service, you should renew your access for this site soon.

Renew now or proceed without renewing.

close window

We're sorry!

Your access to the Instructor Resource Center has expired.

To continue using the IRC, renew your access now.

An internal error has occurred. Please try again.

Instructor Resource Center File Download

This work is protected by local and international copyright laws and is provided solely for the use of instructors in teaching their courses and assessing student learning. Dissemination or sale of any part of this work (including on the World Wide Web) will destroy the integrity of the work and is not permitted. The work and materials from this site should never be made available to students except by instructors using the accompanying text in their classes. All recipients of this work are expected to abide by these restrictions and to honor the intended pedagogical purposes and the needs of other instructors who rely on these materials.

Cancel

I accept, proceed with download

Print this content

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students contact your Pearson Higher Education representative.

Elementary Statistics Using Excel, 3/E