|

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:  Addison-Wesley
Copyright:  2007
Format:  Cloth Bound with Disk; 948 pp
Published:  06/19/2006
New edition available
  This item has been replaced by Elementary Statistics Using Excel, 4/E.



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 | Addison-Wesley | Cloth Bound w/CD-ROM; 928 pp | Instock
    ISBN-10: 0321564960 | ISBN-13: 9780321564962
    Brief Description | Buy from myPearsonStore

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 | Addison-Wesley | On-line Supplement | Instock
ISBN-10: 032141098X | ISBN-13: 9780321410986


MyStatLab/MyMathLab Online Course for Elementary Statistics Using Excel, 3/E
Triola
©2007 | Addison-Wesley | On-line Supplement | Instock
ISBN-10: 0321365151 | ISBN-13: 9780321365156
URLhttp://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 | Addison-Wesley | On-line Supplement | Instock
ISBN-10: 0321369076 | ISBN-13: 9780321369079
URLhttp://www.aw-bc.com/triola
  View Downloadable Files



Companion Website for Elementary Statistics, 10/E
Triola
©2007 | Addison-Wesley | On-line Supplement | Instock
ISBN-10: 0321369076 | ISBN-13: 9780321369079
URLhttp://www.aw-bc.com/triola
  View Downloadable Files



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



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



MathXL Course, 3/E
Triola
©2007 | Addison-Wesley | On-line Supplement | Instock
ISBN-10: 032141098X | ISBN-13: 9780321410986


MyStatLab/MyMathLab Online Course for Elementary Statistics Using Excel, 3/E
Triola
©2007 | Addison-Wesley | On-line Supplement | Instock
ISBN-10: 0321365151 | ISBN-13: 9780321365156
URLhttp://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 | Addison-Wesley | 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 | Addison-Wesley | Paper; 298 pp | Instock
ISBN-10: 0321369149 | ISBN-13: 9780321369147
  View Downloadable Files



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



Companion Website for Elementary Statistics, 10/E
Triola
©2007 | Addison-Wesley | On-line Supplement | Instock
ISBN-10: 0321369076 | ISBN-13: 9780321369079
URLhttp://www.aw-bc.com/triola
  View Downloadable Files



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


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


MathXL Course, 3/E
Triola
©2007 | Addison-Wesley | On-line Supplement | Instock
ISBN-10: 032141098X | ISBN-13: 9780321410986


MathXL Digital Student Access Code (24-month)
Addison-Wesley
©2008 | Addison-Wesley | Digital Access Code | Instock
ISBN-10: 0321488660 | ISBN-13: 9780321488664
URLhttp://www.mypearsonstore.com/title/0321488660


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

Availability: Now! | Student Access Type: Access Code Required
Request Content       Take a Tour


Statistics Study Card
Triola
©2008 | Addison-Wesley | Study Card; 6 pp | Instock
ISBN-10: 0321293150 | ISBN-13: 9780321293152
Buy from myPearsonStore


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


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


For Introductory Statistics - Algebra-Based

Excel 2007 with DDXL Study Card for Statistics
Priestly
©2009 | Addison-Wesley | Study Card; 6 pp | Instock
ISBN-10: 0321592808 | ISBN-13: 9780321592804


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


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


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


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


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


MathXL Course, 3/E
Triola
©2007 | Addison-Wesley | On-line Supplement | Instock
ISBN-10: 032141098X | ISBN-13: 9780321410986


MyStatLab/MyMathLab Online Course for Elementary Statistics Using Excel, 3/E
Triola
©2007 | Addison-Wesley | On-line Supplement | Instock
ISBN-10: 0321365151 | ISBN-13: 9780321365156
URLhttp://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 | Addison-Wesley | On-line Supplement | Instock
ISBN-10: 0321369076 | ISBN-13: 9780321369079
URLhttp://www.aw-bc.com/triola
  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.

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 | Addison-Wesley | Cloth Bound with Disk; 948 pp
Allyn & Bacon | ©2006 | Addison-Wesley | 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 | Addison-Wesley | Cloth Bound with Disk; 948 pp
  • MathXL 12-month Student Access Kit (for valuepacks), 2/E
Addison-Wesley | ©2000 | Addison-Wesley | Paper


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

Triola | ©2007 | Addison-Wesley | Cloth Bound with Disk; 948 pp
Velleman | ©2009 | Addison-Wesley | Software


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

Triola | ©2007 | Addison-Wesley | Cloth Bound with Disk; 948 pp
Loyer | ©2007 | Addison-Wesley | Paper


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

Triola | ©2007 | Addison-Wesley | Cloth Bound with Disk; 948 pp
Halsey & Reda | ©2008 | Addison-Wesley | 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 | Addison-Wesley | Cloth Bound with Disk; 948 pp
Velleman | ©2009 | Addison-Wesley | Software
  • MyMathLab/MyStatLab Student Access Kit (for ad hoc valuepacks)
Addison-Wesley | ©2005 | Addison-Wesley | 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 | Addison-Wesley | Cloth Bound with Disk; 948 pp
Halsey & Reda | ©2008 | Addison-Wesley | Paper
  • MyMathLab/MyStatLab Student Access Kit (for ad hoc valuepacks)
Addison-Wesley | ©2005 | Addison-Wesley | Paper Package


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

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


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

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