Addison-Wesley / Prentice Hall

Statistics



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

ISBN-10: 0321365135
ISBN-13: 9780321365132

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

Suggested retail price: $137.33
Buy from myPearsonStore



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    

 

 

 

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.

View a Sample Chapter PDF:

 

ActivStats: Learn More!


  • Interwrite Personal Response System
    EduCue, Addison-Wesley & Benjamin Cummings
    © 2004 | Benjamin Cummings | Electronic Supplement | Instock
    ISBN-10: 0321267354 | ISBN-13: 9780321267351


  • iClicker Classroom Response System
    iClicker, Addison-Wesley & Benjamin Cummings
    © 2008 | Benjamin Cummings | Electronic Supplement | Instock
    ISBN-10: 032153705X | ISBN-13: 9780321537058


For Introductory Statistics - Algebra-Based


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.

This title is a member of the MyStatLab Series, which also contains the titles below . You can also visit the MyStatLab Series page.

  • 0321422090Elementary Statistics, 7/E
    Weiss
    © 2008 | Addison-Wesley | Cloth Bound w/CD-ROM; 780 pages | Instock
    ISBN-10: 0321422090 | ISBN-13: 9780321422095
    Brief Description | Buy from myPearsonStore

  • 0321365135Elementary Statistics Using Excel, 3/E
    Triola
    © 2007 | Addison-Wesley | Cloth Bound with Disk; 948 pages | Instock
    ISBN-10: 0321365135 | ISBN-13: 9780321365132
    Brief Description | Buy from myPearsonStore

  • 0321462572Elementary Statistics Using the TI-83/84 Plus Calculator, 2/E
    Triola
    © 2008 | Addison-Wesley | Cloth Bound w/CD-ROM; 936 pages | Instock
    ISBN-10: 0321462572 | ISBN-13: 9780321462572
    Brief Description | Buy from myPearsonStore

  • 0321460928Elementary Statistics With Multimedia Study Guide, 10/E
    Triola
    © 2008 | Addison-Wesley | Cloth Bound w/CD-ROM; 912 pages | Instock
    ISBN-10: 0321460928 | ISBN-13: 9780321460929
    Brief Description | Buy from myPearsonStore

  • 0132424339Elementary Statistics: Picturing the World, 4/E
    Larson & Farber
    © 2009 | Prentice Hall | Cloth Bound w/CD-ROM; 792 pages | Instock
    ISBN-10: 0132424339 | ISBN-13: 9780132424332
    Brief Description | Buy from myPearsonStore

  • 0321434250Essentials of Statistics, 3/E
    Triola
    © 2008 | Addison-Wesley | Paper Bound w/CD-ROM; 672 pages | Instock
    ISBN-10: 0321434250 | ISBN-13: 9780321434258
    Brief Description | Buy from myPearsonStore

  • 0136152597First Course in Statistics, A, 10/E
    McClave & Sincich
    © 2009 | Prentice Hall | Paper; 624 pages | Instock
    ISBN-10: 0136152597 | ISBN-13: 9780136152590
    Brief Description | Buy from myPearsonStore

  • 0131569872Fundamentals of Statistics, 2/E
    Sullivan
    © 2008 | Prentice Hall | Paper; 600 pages | Instock
    ISBN-10: 0131569872 | ISBN-13: 9780131569874
    Brief Description | Buy from myPearsonStore

  • 0321500458Intro Stats, 3/E
    De Veaux, Velleman & Bock
    © 2009 | Addison-Wesley | Cloth Bound w/CD-ROM; 864 pages | Instock
    ISBN-10: 0321500458 | ISBN-13: 9780321500458
    Brief Description | Buy from myPearsonStore

  • 0321393619Introductory Statistics, 8/E
    Weiss
    © 2008 | Addison-Wesley | Cloth Bound w/CD-ROM; 976 pages | Instock
    ISBN-10: 0321393619 | ISBN-13: 9780321393616
    Brief Description | Buy from myPearsonStore

  • 0321571622MYSTATLAB: Simplicity, dependability, choice...proven success!
    Addison-Wesley
    © 2008 | Addison-Wesley | On-line Supplement | Estimated Availability: 02/22/2008
    ISBN-10: 0321571622 | ISBN-13: 9780321571625
    URL: http://www.mystatlab.com
    Brief Description

  • 0321286723Statistical Reasoning for Everyday Life, 3/E
    Bennett, Briggs & Triola
    © 2009 | Addison-Wesley | Paper; 512 pages | Instock
    ISBN-10: 0321286723 | ISBN-13: 9780321286727
    Brief Description | Buy from myPearsonStore

  • 0132069512Statistics, 11/E
    McClave, Sincich & Mendenhall
    © 2009 | Prentice Hall | Cloth Bound w/CD-ROM; 864 pages | Instock
    ISBN-10: 0132069512 | ISBN-13: 9780132069519
    Brief Description | Buy from myPearsonStore

  • 0132409356Statistics for Business & Economics, 10/E
    McClave, Benson & Sincich
    © 2008 | Prentice Hall | Cloth Bound w/CD-ROM; 944 pages | Instock
    ISBN-10: 0132409356 | ISBN-13: 9780132409353
    Brief Description | Buy from myPearsonStore

  • 0131871498Statistics: Informed Decisions Using Data, 2/E
    Sullivan
    © 2007 | Prentice Hall | Cloth; 928 pages | Instock
    ISBN-10: 0131871498 | ISBN-13: 9780131871496
    Brief Description | Buy from myPearsonStore

  • 0130083690Statistics: The Art and Science of Learning From Data
    Agresti & Franklin
    © 2007 | Prentice Hall | Cloth; 768 pages | Instock
    ISBN-10: 0130083690 | ISBN-13: 9780130083692
    Brief Description

  • 0135131995Statistics: The Art and Science of Learning from Data, 2/E
    Agresti & Franklin
    © 2009 | Prentice Hall | Cloth Bound w/CD-ROM; 848 pages | Instock
    ISBN-10: 0135131995 | ISBN-13: 9780135131992
    Brief Description | Buy from myPearsonStore

  • 0321433793Stats: Data and Models, 2/E
    De Veaux, Velleman & Bock
    © 2008 | Addison-Wesley | Cloth Bound w/CD-ROM; 800 pages | Instock
    ISBN-10: 0321433793 | ISBN-13: 9780321433794
    Brief Description | Buy from myPearsonStore

  • 0321375599Stats: Modeling the World, 2/E
    Bock, Velleman & De Veaux
    © 2007 | Addison-Wesley | Cloth Bound w/CD-ROM; 792 pages | Instock
    ISBN-10: 0321375599 | ISBN-13: 9780321375599
    Brief Description | Buy from myPearsonStore

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.