|

Addison-Wesley / Prentice Hall

Statistics

My Instructor Resource Center :  Log in or request access

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

ISBN-10: 0321365135
ISBN-13:  9780321365132

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

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.

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!  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.

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    

 

 

 

  • 9780321564962
    Elementary Statistics Using Excel, 4/E
    Triola
    ©2010 | Pearson | Cloth Bound w/CD-ROM; 928 pp | Instock
    ISBN-10: 0321564960 | ISBN-13: 9780321564962
    Brief Description

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.

MathXL Course, 3/E
Triola
©2007 | Pearson | On-line Supplement | Instock
ISBN-10: 032141098X | ISBN-13: 9780321410986
Online purchase price: $42.00


MyStatLab/MyMathLab Online Course for Elementary Statistics Using Excel, 3/E
Triola
©2007 | Pearson | On-line Supplement | Instock
ISBN-10: 0321365151 | ISBN-13: 9780321365156
Online purchase price: $72.00URLhttp://www.mymathlab.com
Availability: Now! | Student Access Type: Access Code Required
Request Content       Take a Tour


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

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

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
    View Downloadable Files

Instructor's Solutions Manual, 3/E
Triola
©2007 | Pearson | Paper | Instock
ISBN-10: 0321365143 | ISBN-13: 9780321365149
    View Downloadable Files

MathXL Course, 3/E
Triola
©2007 | Pearson | On-line Supplement | Instock
ISBN-10: 032141098X | ISBN-13: 9780321410986
Online purchase price: $42.00


MyStatLab/MyMathLab Online Course for Elementary Statistics Using Excel, 3/E
Triola
©2007 | Pearson | On-line Supplement | Instock
ISBN-10: 0321365151 | ISBN-13: 9780321365156
Online purchase price: $72.00URLhttp://www.mymathlab.com
Availability: Now! | Student Access Type: Access Code Required
Request Content       Take a Tour


PowerPoint Lecture Presentation CD for the Triola Statistics Series, 10/E
Triola
©2007 | Pearson | CD-ROM Only | Instock
ISBN-10: 032136905X | ISBN-13: 9780321369055
    View Downloadable Files

Printed Test Bank for the Triola Statistics Series, 10/E
Baker
©2008 | Pearson | Paper; 298 pp | Instock
ISBN-10: 0321369149 | ISBN-13: 9780321369147
    View Downloadable Files

TestGen, 10/E
Triola
©2008 | Pearson | CD-ROM Only | Instock
ISBN-10: 0321369041 | ISBN-13: 9780321369048
    View Downloadable Files

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

Digital Video Tutor (Videos on CD-ROM), 10/E
Triola & White
©2007 | Pearson | Software | Instock
ISBN-10: 0321412680 | ISBN-13: 9780321412683


Excel Lab Manual for the Triola Statistics Series, 10/E
Halsey & Reda
©2008 | Pearson | Paper | Instock
ISBN-10: 0321369092 | ISBN-13: 9780321369093


MathXL Course, 3/E
Triola
©2007 | Pearson | On-line Supplement | Instock
ISBN-10: 032141098X | ISBN-13: 9780321410986
Online purchase price: $42.00


MathXL Digital Student Access Code (24-month)
Addison-Wesley
©2008 | Pearson | Digital Access Code | Instock
ISBN-10: 0321488660 | ISBN-13: 9780321488664
Online purchase price: $70.00

MyStatLab/MyMathLab Online Course for Elementary Statistics Using Excel, 3/E
Triola
©2007 | Pearson | On-line Supplement | Instock
ISBN-10: 0321365151 | ISBN-13: 9780321365156
Online purchase price: $72.00URLhttp://www.mymathlab.com

Statistics Study Card
Triola
©2008 | Pearson | Study Card; 6 pp | Instock
ISBN-10: 0321293150 | ISBN-13: 9780321293152


Student's Solutions Manual for Elementary Statistics Using Excel, 3/E
Loyer
©2007 | Pearson | Paper | Instock
ISBN-10: 0321365186 | ISBN-13: 9780321365187


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


Graphing Calculator Study Card for Statistics
McDonald-Newman
©2009 | Pearson | Study Card | Instock
ISBN-10: 0321570774 | ISBN-13: 9780321570772


JMP v. 6 Study Card for Statistics
Priestly
©2009 | Pearson | Study Card; 6 pp | Instock
ISBN-10: 0321592816 | ISBN-13: 9780321592811


Minitab v. 15 Study Card for Statistics
Priestly
©2010 | Pearson | Study Card | Instock
ISBN-10: 0321592824 | ISBN-13: 9780321592828


R Study Card for Statistics
Reimherr
©2009 | Pearson | Study Card | Instock
ISBN-10: 0321592832 | ISBN-13: 9780321592835


SPSS v. 17 Study Card for Statistics
Priestly
©2009 | Pearson | Study Card | Instock
ISBN-10: 0321589793 | ISBN-13: 9780321589798


StatCrunch Study Card
West
©2010 | Pearson | Study Card | Instock
ISBN-10: 0321628926 | ISBN-13: 9780321628923


MathXL Course, 3/E
Triola
©2007 | Pearson | On-line Supplement | Instock
ISBN-10: 032141098X | ISBN-13: 9780321410986
Online purchase price: $42.00


MyStatLab/MyMathLab Online Course for Elementary Statistics Using Excel, 3/E
Triola
©2007 | Pearson | On-line Supplement | Instock
ISBN-10: 0321365151 | ISBN-13: 9780321365156
Online purchase price: $72.00URLhttp://www.mymathlab.com
Availability: Now! | Student Access Type: Access Code Required
Request Content       Take a Tour


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

Give your students a choice! PearsonChoices products are designed to give your students more value and flexibility by letting them choose from a variety of text and media formats to best match their learning style and their budget.

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, see the Packages Tab.

  • 9780321369284
    Elementary Statistics Using Excel plus MyMathLab/MyStatLab Student Access Kit, 3/E
    Triola
    ©2007 | Pearson | Cloth Package | Instock
    ISBN-10: 0321369289 | ISBN-13: 9780321369284

  • 9780321627858
    Elementary Statistics Using Excel, A La Carte + MyMathLab, 3/E
    Triola
    ©2007 | Pearson | Paper Package | Instock
    ISBN-10: 0321627857 | ISBN-13: 9780321627858

  • 9780321627841
    Elementary Statistics Using Excel, Books a la Carte Edition, 3/E
    Triola
    ©2007 | Pearson | Unbound (Saleable) | Instock
    ISBN-10: 0321627849 | ISBN-13: 9780321627841

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, browse our available packages below, or contact your Pearson Higher Education representative to create your own package.

Package ISBN-10: 0321479297 | ISBN-13: 9780321479297
©2007 | Instock
Suggested retail price: $170.93  Buy from myPearsonStore

This package contains:

Triola | ©2007 | Pearson | Cloth Bound with Disk; 948 pp
Allyn & Bacon | ©2006 | Pearson | CD-ROM Only


Package ISBN-10: 0321440102 | ISBN-13: 9780321440105
©2007 | Instock
Suggested retail price: $141.33  Buy from myPearsonStore

This package contains:

Triola | ©2007 | Pearson | Cloth Bound with Disk; 948 pp
  • MathXL 12-month Student Access Kit (for valuepacks), 2/E
Addison-Wesley | ©2000 | Pearson | Paper


Package ISBN-10: 0321521374 | ISBN-13: 9780321521378
©2009 | Instock
Suggested retail price: $148.00  Buy from myPearsonStore

This package contains:

Triola | ©2007 | Pearson | Cloth Bound with Disk; 948 pp
Velleman | ©2009 | Pearson | Software


Package ISBN-10: 0321473388 | ISBN-13: 9780321473387
©2007 | Instock
Suggested retail price: $141.33  Buy from myPearsonStore

This package contains:

Triola | ©2007 | Pearson | Cloth Bound with Disk; 948 pp
Loyer | ©2007 | Pearson | Paper


Package ISBN-10: 0321476115 | ISBN-13: 9780321476111
©2007 | Instock
Suggested retail price: $141.33  Buy from myPearsonStore

This package contains:

Triola | ©2007 | Pearson | Cloth Bound with Disk; 948 pp
Halsey & Reda | ©2008 | Pearson | Paper


Package ISBN-10: 0321425782 | ISBN-13: 9780321425782
©2009 | Out of Stock
Suggested retail price: $149.33  Buy from myPearsonStore

This package contains:

Triola | ©2007 | Pearson | Cloth Bound with Disk; 948 pp
Velleman | ©2009 | Pearson | Software
  • MyMathLab/MyStatLab Student Access Kit (for ad hoc valuepacks)
Addison-Wesley | ©2005 | Pearson | Paper Package


Package ISBN-10: 0321490800 | ISBN-13: 9780321490803
©2007 | Out of Stock
Suggested retail price: $149.33  Buy from myPearsonStore

This package contains:

Triola | ©2007 | Pearson | Cloth Bound with Disk; 948 pp
Halsey & Reda | ©2008 | Pearson | Paper
  • MyMathLab/MyStatLab Student Access Kit (for ad hoc valuepacks)
Addison-Wesley | ©2005 | Pearson | Paper Package


Package ISBN-10: 0321476549 | ISBN-13: 9780321476548
©2007 | Instock
Suggested retail price: $144.67  Buy from myPearsonStore

This package contains:

Triola | ©2007 | Pearson | Cloth Bound with Disk; 948 pp
Halsey & Reda | ©2008 | Pearson | Paper
Loyer | ©2007 | Pearson | Paper


Package ISBN-10: 0321642864 | ISBN-13: 9780321642868
©2007 | Out of Stock
Suggested retail price: $149.33  Buy from myPearsonStore

This package contains:

Triola | ©2007 | Pearson | Cloth Bound with Disk; 948 pp
  • MyMathLab/MyStatLab Student Access Kit (for ad hoc valuepacks)
Addison-Wesley | ©2005 | Pearson | Paper Package
Pearson | ©2009 | Pearson | Paper


Package ISBN-10: 0321460650 | ISBN-13: 9780321460653
©2007 | Instock
Suggested retail price: $141.33  Buy from myPearsonStore

This package contains:

Triola | ©2007 | Pearson | Cloth Bound with Disk; 948 pp
Halsey & Reda | ©2008 | Pearson | Paper
  • MyMathLab/MyStatLab Student Access Kit (for ad hoc valuepacks)
Addison-Wesley | ©2005 | Pearson | Paper Package
Loyer | ©2007 | Pearson | Paper


Package ISBN-10: 0321590155 | ISBN-13: 9780321590152
©2007 | Out of Stock
Suggested retail price: $149.33  Buy from myPearsonStore

This package contains:

Triola | ©2007 | Pearson | Cloth Bound with Disk; 948 pp
Halsey & Reda | ©2008 | Pearson | Paper
  • MyMathLab/MyStatLab Student Access Kit (for ad hoc valuepacks)
Addison-Wesley | ©2005 | Pearson | Paper Package
Loyer | ©2007 | Pearson | Paper
Humphrey | ©2008 | Pearson | Paper