VE
R
IF
INSTRUCTOR’S
IE
SOLUTIONS MANUAL
D
BR
JAMES LAPP
AI
University of Maryland Global Campus
N
BO
E LEMENTARY
O
STATISTICS USING EXCEL
ST
ER
SEVENTH EDITION
Mario F. Triola
VERIFIEDBRAINBOOSTER
, VE
R
IF
IE
D
BR
AI
N
BO
O
ST
Please contact https://support.pearson.com/getsupport/s/ with any queries on this content.
ER
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
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,
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/.
ISBN-10: 0-13-693964-3
ISBN-13: 978-0-13-693964-1
VERIFIEDBRAINBOOSTER
, VE
R
CONTENTS
IF
Chapter 1: Introduction to Statistics
IE
Section 1-1: Statistical and Critical Thinking ...................................................................1
Section 1-2: Types of Data ...............................................................................................3
D
Section 1-3: Collecting Sample Data ................................................................................4
BR
Section 1-4: Introduction to Excel ....................................................................................5
Quick Quiz ........................................................................................................................5
Review Exercises ..............................................................................................................6
AI
Cumulative Review Exercises ..........................................................................................6
Chapter 2: Exploring Data with Tables and Graphs
N
Section 2-1: Frequency Distributions for Organizing and Summarizing Data .................9
BO
Section 2-2: Histograms ..................................................................................................15
Section 2-3: Graphs That Enlighten and Graphs That Deceive ......................................18
Section 2-4: Scatterplots, Correlation, and Regression ..................................................21
O
Quick Quiz ......................................................................................................................23
Review Exercises ............................................................................................................24
ST
Cumulative Review Exercises ........................................................................................25
Chapter 3: Describing, Exploring, and Comparing Data
ER
Section 3-1: Measures of Center .....................................................................................27
Section 3-2: Measures of Variation ................................................................................35
Section 3-3: Measures of Relative Standing and Boxplots .............................................42
Quick Quiz ......................................................................................................................47
Review Exercises ............................................................................................................47
Cumulative Review Exercises ........................................................................................49
Chapter 4: Probability
Section 4-1: Basic Concepts of Probability ....................................................................51
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
Quick Quiz ......................................................................................................................60
Review Exercises ............................................................................................................61
Cumulative Review Exercises ........................................................................................62
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
Cumulative Review Exercises ........................................................................................74
VERIFIEDBRAINBOOSTER
, VE
R
Chapter 6: Normal Probability Distributions
IF
Section 6-1: The Standard Normal Distribution .............................................................77
Section 6-2: Real Applications of Normal Distributions ................................................79
IE
Section 6-3: Sampling Distributions and Estimators ......................................................83
Section 6-4: The Central Limit Theorem ........................................................................87
D
Section 6-5: Assessing Normality ...................................................................................91
Section 6-6: Normal as Approximation to Binomial (Download Only) .........................94
BR
Quick Quiz ......................................................................................................................97
Review Exercises ............................................................................................................98
AI
Cumulative Review Exercises ........................................................................................99
Chapter 7: Estimating Parameters and Determining Sample Sizes
N
Section 7-1: Estimating a Population Proportion..........................................................101
BO
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
O
Quick Quiz ....................................................................................................................117
Review Exercises ..........................................................................................................117
ST
Cumulative Review Exercises ......................................................................................119
Chapter 8: Hypothesis Testing
ER
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
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
Section 9-1: Two Proportions .......................................................................................147
Section 9-2: Two Means: Independent Samples ...........................................................158
Section 9-3: Matched Pairs ...........................................................................................168
Section 9-4: Two Variances or Standard Deviations ....................................................176
Section 9-5: Resampling: Using Technology for Inferences ........................................179
Quick Quiz ....................................................................................................................181
Review Exercises ..........................................................................................................182
Cumulative Review Exercises ......................................................................................185
VERIFIEDBRAINBOOSTER
R
IF
INSTRUCTOR’S
IE
SOLUTIONS MANUAL
D
BR
JAMES LAPP
AI
University of Maryland Global Campus
N
BO
E LEMENTARY
O
STATISTICS USING EXCEL
ST
ER
SEVENTH EDITION
Mario F. Triola
VERIFIEDBRAINBOOSTER
, VE
R
IF
IE
D
BR
AI
N
BO
O
ST
Please contact https://support.pearson.com/getsupport/s/ with any queries on this content.
ER
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
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,
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/.
ISBN-10: 0-13-693964-3
ISBN-13: 978-0-13-693964-1
VERIFIEDBRAINBOOSTER
, VE
R
CONTENTS
IF
Chapter 1: Introduction to Statistics
IE
Section 1-1: Statistical and Critical Thinking ...................................................................1
Section 1-2: Types of Data ...............................................................................................3
D
Section 1-3: Collecting Sample Data ................................................................................4
BR
Section 1-4: Introduction to Excel ....................................................................................5
Quick Quiz ........................................................................................................................5
Review Exercises ..............................................................................................................6
AI
Cumulative Review Exercises ..........................................................................................6
Chapter 2: Exploring Data with Tables and Graphs
N
Section 2-1: Frequency Distributions for Organizing and Summarizing Data .................9
BO
Section 2-2: Histograms ..................................................................................................15
Section 2-3: Graphs That Enlighten and Graphs That Deceive ......................................18
Section 2-4: Scatterplots, Correlation, and Regression ..................................................21
O
Quick Quiz ......................................................................................................................23
Review Exercises ............................................................................................................24
ST
Cumulative Review Exercises ........................................................................................25
Chapter 3: Describing, Exploring, and Comparing Data
ER
Section 3-1: Measures of Center .....................................................................................27
Section 3-2: Measures of Variation ................................................................................35
Section 3-3: Measures of Relative Standing and Boxplots .............................................42
Quick Quiz ......................................................................................................................47
Review Exercises ............................................................................................................47
Cumulative Review Exercises ........................................................................................49
Chapter 4: Probability
Section 4-1: Basic Concepts of Probability ....................................................................51
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
Quick Quiz ......................................................................................................................60
Review Exercises ............................................................................................................61
Cumulative Review Exercises ........................................................................................62
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
Cumulative Review Exercises ........................................................................................74
VERIFIEDBRAINBOOSTER
, VE
R
Chapter 6: Normal Probability Distributions
IF
Section 6-1: The Standard Normal Distribution .............................................................77
Section 6-2: Real Applications of Normal Distributions ................................................79
IE
Section 6-3: Sampling Distributions and Estimators ......................................................83
Section 6-4: The Central Limit Theorem ........................................................................87
D
Section 6-5: Assessing Normality ...................................................................................91
Section 6-6: Normal as Approximation to Binomial (Download Only) .........................94
BR
Quick Quiz ......................................................................................................................97
Review Exercises ............................................................................................................98
AI
Cumulative Review Exercises ........................................................................................99
Chapter 7: Estimating Parameters and Determining Sample Sizes
N
Section 7-1: Estimating a Population Proportion..........................................................101
BO
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
O
Quick Quiz ....................................................................................................................117
Review Exercises ..........................................................................................................117
ST
Cumulative Review Exercises ......................................................................................119
Chapter 8: Hypothesis Testing
ER
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
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
Section 9-1: Two Proportions .......................................................................................147
Section 9-2: Two Means: Independent Samples ...........................................................158
Section 9-3: Matched Pairs ...........................................................................................168
Section 9-4: Two Variances or Standard Deviations ....................................................176
Section 9-5: Resampling: Using Technology for Inferences ........................................179
Quick Quiz ....................................................................................................................181
Review Exercises ..........................................................................................................182
Cumulative Review Exercises ......................................................................................185
VERIFIEDBRAINBOOSTER
