INSTRUCTOR’S
M
SOLUTIONS MANUAL
PR
JAMES LAPP
University of Maryland Global Campus
ES
E LEMENTARY
STATISTICS USING EXCEL
SI
SEVENTH EDITION
VE
Mario F. Triola
G
R
AD
ES
,M
PR
ES
Please contact https://support.pearson.com/getsupport/s/ with any queries on this content.
SI
The author and publisher of this book have used their best efforts in preparing this book. These efforts include the
development, research, and testing of the theories and programs to determine their effectiveness. The author and
publisher make no warranty of any kind, expressed or implied, with regard to these programs or the documentation
VE
contained in this book. The author and publisher shall not be liable in any event for incidental or consequential
damages in connection with, or arising out of, the furnishing, performance, or use of these programs.
Copyright © 2022, 2018, 2014 by Pearson Education, Inc. or its affiliates, 221 River Street, Hoboken, NJ 07030. All
Rights Reserved. Manufactured in the United States of America. This publication is protected by copyright, and
permission should be obtained from the publisher prior to any prohibited reproduction, storage in a retrieval system,
G
or transmission in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise. For
information regarding permissions, request forms, and the appropriate contacts within the Pearson Education Global
Rights and Permissions department, please visit www.pearsoned.com/permissions/.
R
AD
ISBN-10: 0-13-693964-3
ISBN-13: 978-0-13-693964-1
ES
, CONTENTS
Chapter 1: Introduction to Statistics
M
Section 1-1: Statistical and Critical Thinking ...................................................................1
Section 1-2: Types of Data ...............................................................................................3
Section 1-3: Collecting Sample Data ................................................................................4
PR
Section 1-4: Introduction to Excel ....................................................................................5
Quick Quiz ........................................................................................................................5
Review Exercises ..............................................................................................................6
Cumulative Review Exercises ..........................................................................................6
Chapter 2: Exploring Data with Tables and Graphs
Section 2-1: Frequency Distributions for Organizing and Summarizing Data .................9
ES
Section 2-2: Histograms ..................................................................................................15
Section 2-3: Graphs That Enlighten and Graphs That Deceive ......................................18
Section 2-4: Scatterplots, Correlation, and Regression ..................................................21
Quick Quiz ......................................................................................................................23
Review Exercises ............................................................................................................24
Cumulative Review Exercises ........................................................................................25
SI
Chapter 3: Describing, Exploring, and Comparing Data
Section 3-1: Measures of Center .....................................................................................27
Section 3-2: Measures of Variation ................................................................................35
Section 3-3: Measures of Relative Standing and Boxplots .............................................42
VE
Quick Quiz ......................................................................................................................47
Review Exercises ............................................................................................................47
Cumulative Review Exercises ........................................................................................49
Chapter 4: Probability
Section 4-1: Basic Concepts of Probability ....................................................................51
G
Section 4-2: Addition Rule and Multiplication Rule ......................................................52
Section 4-3: Complements, Conditional Probability, and Bayes’ Theorem ...................55
Section 4-4: Counting .....................................................................................................57
Section 4-5: Simulations for Hypotheses Tests ..............................................................60
R
Quick Quiz ......................................................................................................................60
Review Exercises ............................................................................................................61
Cumulative Review Exercises ........................................................................................62
AD
Chapter 5: Discrete Probability Distributions
Section 5-1: Probability Distributions ............................................................................65
Section 5-2: Binomial Probability Distributions.............................................................67
Section 5-3: Poisson Probability Distributions ...............................................................70
Quick Quiz ......................................................................................................................72
Review Exercises ............................................................................................................73
ES
Cumulative Review Exercises ........................................................................................74
, Chapter 6: Normal Probability Distributions
Section 6-1: The Standard Normal Distribution .............................................................77
M
Section 6-2: Real Applications of Normal Distributions ................................................79
Section 6-3: Sampling Distributions and Estimators ......................................................83
Section 6-4: The Central Limit Theorem ........................................................................87
Section 6-5: Assessing Normality ...................................................................................91
PR
Section 6-6: Normal as Approximation to Binomial (Download Only) .........................94
Quick Quiz ......................................................................................................................97
Review Exercises ............................................................................................................98
Cumulative Review Exercises ........................................................................................99
Chapter 7: Estimating Parameters and Determining Sample Sizes
Section 7-1: Estimating a Population Proportion..........................................................101
ES
Section 7-2: Estimating a Population Mean..................................................................106
Section 7-3: Estimating a Population Standard Deviation or Variance ........................111
Section 7-4: Bootstrapping: Using Excel for Estimates ...............................................115
Quick Quiz ....................................................................................................................117
Review Exercises ..........................................................................................................117
Cumulative Review Exercises ......................................................................................119
SI
Chapter 8: Hypothesis Testing
Section 8-1: Basics of Hypothesis Testing ...................................................................121
Section 8-2: Testing a Claim About a Proportion .........................................................123
Section 8-3: Testing a Claim About a Mean .................................................................131
VE
Section 8-4: Testing a Claim About a Standard Deviation or Variance .......................136
Section 8-5: Resampling: Using Excel for Hypothesis Testing....................................140
Quick Quiz ....................................................................................................................141
Review Exercises ..........................................................................................................142
Cumulative Review Exercises ......................................................................................143
Chapter 9: Inferences from Two Samples
G
Section 9-1: Two Proportions .......................................................................................147
Section 9-2: Two Means: Independent Samples ...........................................................158
Section 9-3: Matched Pairs ...........................................................................................168
R
Section 9-4: Two Variances or Standard Deviations ....................................................176
Section 9-5: Resampling: Using Technology for Inferences ........................................179
Quick Quiz ....................................................................................................................181
AD
Review Exercises ..........................................................................................................182
Cumulative Review Exercises ......................................................................................185
ES
M
SOLUTIONS MANUAL
PR
JAMES LAPP
University of Maryland Global Campus
ES
E LEMENTARY
STATISTICS USING EXCEL
SI
SEVENTH EDITION
VE
Mario F. Triola
G
R
AD
ES
,M
PR
ES
Please contact https://support.pearson.com/getsupport/s/ with any queries on this content.
SI
The author and publisher of this book have used their best efforts in preparing this book. These efforts include the
development, research, and testing of the theories and programs to determine their effectiveness. The author and
publisher make no warranty of any kind, expressed or implied, with regard to these programs or the documentation
VE
contained in this book. The author and publisher shall not be liable in any event for incidental or consequential
damages in connection with, or arising out of, the furnishing, performance, or use of these programs.
Copyright © 2022, 2018, 2014 by Pearson Education, Inc. or its affiliates, 221 River Street, Hoboken, NJ 07030. All
Rights Reserved. Manufactured in the United States of America. This publication is protected by copyright, and
permission should be obtained from the publisher prior to any prohibited reproduction, storage in a retrieval system,
G
or transmission in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise. For
information regarding permissions, request forms, and the appropriate contacts within the Pearson Education Global
Rights and Permissions department, please visit www.pearsoned.com/permissions/.
R
AD
ISBN-10: 0-13-693964-3
ISBN-13: 978-0-13-693964-1
ES
, CONTENTS
Chapter 1: Introduction to Statistics
M
Section 1-1: Statistical and Critical Thinking ...................................................................1
Section 1-2: Types of Data ...............................................................................................3
Section 1-3: Collecting Sample Data ................................................................................4
PR
Section 1-4: Introduction to Excel ....................................................................................5
Quick Quiz ........................................................................................................................5
Review Exercises ..............................................................................................................6
Cumulative Review Exercises ..........................................................................................6
Chapter 2: Exploring Data with Tables and Graphs
Section 2-1: Frequency Distributions for Organizing and Summarizing Data .................9
ES
Section 2-2: Histograms ..................................................................................................15
Section 2-3: Graphs That Enlighten and Graphs That Deceive ......................................18
Section 2-4: Scatterplots, Correlation, and Regression ..................................................21
Quick Quiz ......................................................................................................................23
Review Exercises ............................................................................................................24
Cumulative Review Exercises ........................................................................................25
SI
Chapter 3: Describing, Exploring, and Comparing Data
Section 3-1: Measures of Center .....................................................................................27
Section 3-2: Measures of Variation ................................................................................35
Section 3-3: Measures of Relative Standing and Boxplots .............................................42
VE
Quick Quiz ......................................................................................................................47
Review Exercises ............................................................................................................47
Cumulative Review Exercises ........................................................................................49
Chapter 4: Probability
Section 4-1: Basic Concepts of Probability ....................................................................51
G
Section 4-2: Addition Rule and Multiplication Rule ......................................................52
Section 4-3: Complements, Conditional Probability, and Bayes’ Theorem ...................55
Section 4-4: Counting .....................................................................................................57
Section 4-5: Simulations for Hypotheses Tests ..............................................................60
R
Quick Quiz ......................................................................................................................60
Review Exercises ............................................................................................................61
Cumulative Review Exercises ........................................................................................62
AD
Chapter 5: Discrete Probability Distributions
Section 5-1: Probability Distributions ............................................................................65
Section 5-2: Binomial Probability Distributions.............................................................67
Section 5-3: Poisson Probability Distributions ...............................................................70
Quick Quiz ......................................................................................................................72
Review Exercises ............................................................................................................73
ES
Cumulative Review Exercises ........................................................................................74
, Chapter 6: Normal Probability Distributions
Section 6-1: The Standard Normal Distribution .............................................................77
M
Section 6-2: Real Applications of Normal Distributions ................................................79
Section 6-3: Sampling Distributions and Estimators ......................................................83
Section 6-4: The Central Limit Theorem ........................................................................87
Section 6-5: Assessing Normality ...................................................................................91
PR
Section 6-6: Normal as Approximation to Binomial (Download Only) .........................94
Quick Quiz ......................................................................................................................97
Review Exercises ............................................................................................................98
Cumulative Review Exercises ........................................................................................99
Chapter 7: Estimating Parameters and Determining Sample Sizes
Section 7-1: Estimating a Population Proportion..........................................................101
ES
Section 7-2: Estimating a Population Mean..................................................................106
Section 7-3: Estimating a Population Standard Deviation or Variance ........................111
Section 7-4: Bootstrapping: Using Excel for Estimates ...............................................115
Quick Quiz ....................................................................................................................117
Review Exercises ..........................................................................................................117
Cumulative Review Exercises ......................................................................................119
SI
Chapter 8: Hypothesis Testing
Section 8-1: Basics of Hypothesis Testing ...................................................................121
Section 8-2: Testing a Claim About a Proportion .........................................................123
Section 8-3: Testing a Claim About a Mean .................................................................131
VE
Section 8-4: Testing a Claim About a Standard Deviation or Variance .......................136
Section 8-5: Resampling: Using Excel for Hypothesis Testing....................................140
Quick Quiz ....................................................................................................................141
Review Exercises ..........................................................................................................142
Cumulative Review Exercises ......................................................................................143
Chapter 9: Inferences from Two Samples
G
Section 9-1: Two Proportions .......................................................................................147
Section 9-2: Two Means: Independent Samples ...........................................................158
Section 9-3: Matched Pairs ...........................................................................................168
R
Section 9-4: Two Variances or Standard Deviations ....................................................176
Section 9-5: Resampling: Using Technology for Inferences ........................................179
Quick Quiz ....................................................................................................................181
AD
Review Exercises ..........................................................................................................182
Cumulative Review Exercises ......................................................................................185
ES
