Elementary Statistics Using Excel – 6th
Edition
ST
SOLUTIONS
UV
MANUAL
IA
_A
Mario F. Triola
PP
Comprehensive Solutions Manual for Instructors
RO
and Students
VE
© Mario F. Triola
All rights reserved. Reproduction or distribution without permission is prohibited.
D?
??
©STUDYSTREAM
, CONTENTS
Chapter 1: Introduction To Statistics
ST
Section 1-1: Statistical and Critical Thinking...................................................................1
Section 1-2: Types of Data ...............................................................................................3
Section 1-3: Collecting Sample Data................................................................................4
Section 1-4: Introduction to Excel ....................................................................................5
UV
Chapter Quick Quiz ..........................................................................................................6
Review Exercises ..............................................................................................................6
Cumulative Review Exercises ..........................................................................................7
Chapter 2: Exploring Data with Tables and Graphs
Section 2-1: Frequency Distributions for Organizing and Summarizing Data.................9
IA
Section 2-2: Histograms..................................................................................................14
Section 2-3: Graphs That Enlighten and Graphs That Deceive......................................16
Section 2-4: Scatterplots, Correlation, and Regression ..................................................19
Chapter Quick Quiz ........................................................................................................20
_A
Review Exercises ............................................................................................................21
Cumulative Review Exercises ........................................................................................23
Chapter 3: Describing, Exploring, and Comparing Data
Section 3-1: Measures of Center.....................................................................................25
Section 3-2: Measures of Variation ................................................................................32
PP
Section 3-3: Measures of Relative Standing and Boxplots.............................................39
Chapter Quick Quiz ........................................................................................................44
Review Exercises ............................................................................................................45
Cumulative Review Exercises ........................................................................................46
RO
Chapter 4: Probability
Section 4-1: Basic Concepts of Probability ....................................................................49
Section 4-2: Addition Rule and Multiplication Rule ......................................................51
Section 4-3: Complements, Conditional Probability, and Bayes’ Theorem...................53
Section 4-4: Counting .....................................................................................................55
Chapter Quick Quiz ........................................................................................................58
VE
Review Exercises ............................................................................................................59
Cumulative Review Exercises ........................................................................................60
Chapter 5: Discrete Probability Distributions
Section 5-1: Probability Distributions ............................................................................63
D?
Section 5-2: Binomial Probability Distributions.............................................................65
Section 5-3: Poisson Probability Distributions ...............................................................69
Chapter Quick Quiz ........................................................................................................71
Review Exercises ............................................................................................................71
Cumulative Review Exercises ........................................................................................72
??
, Chapter 6: Normal Probability Distributions
Section 6-1: The Standard Normal Distribution .............................................................75
Section 6-2: Real Applications of Normal Distributions................................................78
ST
Section 6-3: Sampling Distributions and Estimators ......................................................83
Section 6-4: The Central Limit Theorem........................................................................87
Section 6-5: Assessing Normality...................................................................................91
Section 6-6: Normal as Approximation to Binomial ......................................................95
UV
Chapter Quick Quiz ........................................................................................................99
Review Exercises ............................................................................................................99
Cumulative Review Exercises ......................................................................................101
Chapter 7: Estimating Parameters and Determining Sample Sizes
Section 7-1: Estimating a Population Proportion..........................................................105
IA
Section 7-2: Estimating a Population Mean..................................................................111
Section 7-3: Estimating a Population Standard Deviation or Variance........................116
Section 7-4: Bootstrapping: Using Excel for Estimates ...............................................120
Chapter Quick Quiz ......................................................................................................122
_A
Review Exercises ..........................................................................................................123
Cumulative Review Exercises ......................................................................................124
Chapter 8: Hypothesis Testing
Section 8-1: Basics of Hypothesis Testing ...................................................................127
Section 8-2: Testing a Claim About a Proportion.........................................................129
PP
Section 8-3: Testing a Claim About a Mean.................................................................137
Section 8-4: Testing a Claim About a Standard Deviation or Variance .......................144
Chapter Quick Quiz ......................................................................................................148
Review Exercises ..........................................................................................................149
Cumulative Review Exercises ......................................................................................151
RO
Chapter 9: Chapter 9: Inferences from Two Samples
Section 9-1: Two Proportions .......................................................................................153
Section 9-2: Two Means: Independent Samples...........................................................167
Section 9-3: Two Dependent Samples (Matched Pairs) ...............................................178
Section 9-4: Two Variances or Standard Deviations....................................................186
VE
Chapter Quick Quiz ......................................................................................................189
Review Exercises ..........................................................................................................190
Cumulative Review Exercises ......................................................................................192
Chapter 10: Correlation and Regression
D?
Section 10-1: Correlation..............................................................................................197
Section 10-2: Regression ..............................................................................................210
Section 10-3: Prediction Intervals and Variation..........................................................223
Section 10-4: Multiple Regression................................................................................227
Section 10-5: Nonlinear Regression .............................................................................232
??
Chapter Quick Quiz ......................................................................................................237
Review Exercises ..........................................................................................................237
Cumulative Review Exercises ......................................................................................240
, Chapter 11: Goodness-of-Fit and Contingency Tables
Section 11-1: Goodness-of-Fit......................................................................................243
Section 11-2: Contingency Tables ................................................................................251
ST
Chapter Quick Quiz ......................................................................................................258
Review Exercises ..........................................................................................................258
Cumulative Review Exercises ......................................................................................260
Chapter 12: Analysis of Variance
UV
Section 12-1: One-Way ANOVA .................................................................................263
Section 12-2: Two-Way ANOVA ................................................................................265
Chapter Quick Quiz ......................................................................................................267
Review Exercises ..........................................................................................................267
Cumulative Review Exercises ......................................................................................268
IA
Chapter 13: Nonparametric Tests
Section 13-2: Sign Test.................................................................................................271
Section 13-3: Wilcoxon Signed-Ranks Test for Matched Pairs ...................................274
Section 13-4: Wilcoxon Rank-Sum Test for Two Independent samples......................277
_A
Section 13-5: Kruskal-Wallis Test for Three or More Samples ...................................282
Section 13-6: Rank Correlation ....................................................................................284
Section 13-7: Runs Test for Randomness.....................................................................286
Chapter Quick Quiz ......................................................................................................288
Review Exercises ..........................................................................................................289
PP
Cumulative Review Exercises ......................................................................................291
Chapter 14: Statistical Process Control
Section 14-1: Control Charts for Variation and Mean..................................................295
Section 14-2: Control Charts for Attributes..................................................................297
RO
Chapter Quick Quiz ......................................................................................................302
Review Exercises ..........................................................................................................302
Cumulative Review Exercises ......................................................................................304
VE
D?
??
Edition
ST
SOLUTIONS
UV
MANUAL
IA
_A
Mario F. Triola
PP
Comprehensive Solutions Manual for Instructors
RO
and Students
VE
© Mario F. Triola
All rights reserved. Reproduction or distribution without permission is prohibited.
D?
??
©STUDYSTREAM
, CONTENTS
Chapter 1: Introduction To Statistics
ST
Section 1-1: Statistical and Critical Thinking...................................................................1
Section 1-2: Types of Data ...............................................................................................3
Section 1-3: Collecting Sample Data................................................................................4
Section 1-4: Introduction to Excel ....................................................................................5
UV
Chapter Quick Quiz ..........................................................................................................6
Review Exercises ..............................................................................................................6
Cumulative Review Exercises ..........................................................................................7
Chapter 2: Exploring Data with Tables and Graphs
Section 2-1: Frequency Distributions for Organizing and Summarizing Data.................9
IA
Section 2-2: Histograms..................................................................................................14
Section 2-3: Graphs That Enlighten and Graphs That Deceive......................................16
Section 2-4: Scatterplots, Correlation, and Regression ..................................................19
Chapter Quick Quiz ........................................................................................................20
_A
Review Exercises ............................................................................................................21
Cumulative Review Exercises ........................................................................................23
Chapter 3: Describing, Exploring, and Comparing Data
Section 3-1: Measures of Center.....................................................................................25
Section 3-2: Measures of Variation ................................................................................32
PP
Section 3-3: Measures of Relative Standing and Boxplots.............................................39
Chapter Quick Quiz ........................................................................................................44
Review Exercises ............................................................................................................45
Cumulative Review Exercises ........................................................................................46
RO
Chapter 4: Probability
Section 4-1: Basic Concepts of Probability ....................................................................49
Section 4-2: Addition Rule and Multiplication Rule ......................................................51
Section 4-3: Complements, Conditional Probability, and Bayes’ Theorem...................53
Section 4-4: Counting .....................................................................................................55
Chapter Quick Quiz ........................................................................................................58
VE
Review Exercises ............................................................................................................59
Cumulative Review Exercises ........................................................................................60
Chapter 5: Discrete Probability Distributions
Section 5-1: Probability Distributions ............................................................................63
D?
Section 5-2: Binomial Probability Distributions.............................................................65
Section 5-3: Poisson Probability Distributions ...............................................................69
Chapter Quick Quiz ........................................................................................................71
Review Exercises ............................................................................................................71
Cumulative Review Exercises ........................................................................................72
??
, Chapter 6: Normal Probability Distributions
Section 6-1: The Standard Normal Distribution .............................................................75
Section 6-2: Real Applications of Normal Distributions................................................78
ST
Section 6-3: Sampling Distributions and Estimators ......................................................83
Section 6-4: The Central Limit Theorem........................................................................87
Section 6-5: Assessing Normality...................................................................................91
Section 6-6: Normal as Approximation to Binomial ......................................................95
UV
Chapter Quick Quiz ........................................................................................................99
Review Exercises ............................................................................................................99
Cumulative Review Exercises ......................................................................................101
Chapter 7: Estimating Parameters and Determining Sample Sizes
Section 7-1: Estimating a Population Proportion..........................................................105
IA
Section 7-2: Estimating a Population Mean..................................................................111
Section 7-3: Estimating a Population Standard Deviation or Variance........................116
Section 7-4: Bootstrapping: Using Excel for Estimates ...............................................120
Chapter Quick Quiz ......................................................................................................122
_A
Review Exercises ..........................................................................................................123
Cumulative Review Exercises ......................................................................................124
Chapter 8: Hypothesis Testing
Section 8-1: Basics of Hypothesis Testing ...................................................................127
Section 8-2: Testing a Claim About a Proportion.........................................................129
PP
Section 8-3: Testing a Claim About a Mean.................................................................137
Section 8-4: Testing a Claim About a Standard Deviation or Variance .......................144
Chapter Quick Quiz ......................................................................................................148
Review Exercises ..........................................................................................................149
Cumulative Review Exercises ......................................................................................151
RO
Chapter 9: Chapter 9: Inferences from Two Samples
Section 9-1: Two Proportions .......................................................................................153
Section 9-2: Two Means: Independent Samples...........................................................167
Section 9-3: Two Dependent Samples (Matched Pairs) ...............................................178
Section 9-4: Two Variances or Standard Deviations....................................................186
VE
Chapter Quick Quiz ......................................................................................................189
Review Exercises ..........................................................................................................190
Cumulative Review Exercises ......................................................................................192
Chapter 10: Correlation and Regression
D?
Section 10-1: Correlation..............................................................................................197
Section 10-2: Regression ..............................................................................................210
Section 10-3: Prediction Intervals and Variation..........................................................223
Section 10-4: Multiple Regression................................................................................227
Section 10-5: Nonlinear Regression .............................................................................232
??
Chapter Quick Quiz ......................................................................................................237
Review Exercises ..........................................................................................................237
Cumulative Review Exercises ......................................................................................240
, Chapter 11: Goodness-of-Fit and Contingency Tables
Section 11-1: Goodness-of-Fit......................................................................................243
Section 11-2: Contingency Tables ................................................................................251
ST
Chapter Quick Quiz ......................................................................................................258
Review Exercises ..........................................................................................................258
Cumulative Review Exercises ......................................................................................260
Chapter 12: Analysis of Variance
UV
Section 12-1: One-Way ANOVA .................................................................................263
Section 12-2: Two-Way ANOVA ................................................................................265
Chapter Quick Quiz ......................................................................................................267
Review Exercises ..........................................................................................................267
Cumulative Review Exercises ......................................................................................268
IA
Chapter 13: Nonparametric Tests
Section 13-2: Sign Test.................................................................................................271
Section 13-3: Wilcoxon Signed-Ranks Test for Matched Pairs ...................................274
Section 13-4: Wilcoxon Rank-Sum Test for Two Independent samples......................277
_A
Section 13-5: Kruskal-Wallis Test for Three or More Samples ...................................282
Section 13-6: Rank Correlation ....................................................................................284
Section 13-7: Runs Test for Randomness.....................................................................286
Chapter Quick Quiz ......................................................................................................288
Review Exercises ..........................................................................................................289
PP
Cumulative Review Exercises ......................................................................................291
Chapter 14: Statistical Process Control
Section 14-1: Control Charts for Variation and Mean..................................................295
Section 14-2: Control Charts for Attributes..................................................................297
RO
Chapter Quick Quiz ......................................................................................................302
Review Exercises ..........................................................................................................302
Cumulative Review Exercises ......................................................................................304
VE
D?
??
