INSTRUCTOR’S
SOLUTIONS MANUAL
JAMES LAPP
Colorado Mesa University
ELEMENTARY STATISTICS
USING EXCEL
@
SIXTH EDITION
Te
Mario F. Triola
st
Dutchess Community College
ba
nk
sm
af
ia
@Testbanksmafia
, CONTENTS
Chapter 1: Introduction To Statistics
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
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
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
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
Section 3-3: Measures of Relative Standing and Boxplots.............................................39
Chapter Quick Quiz ........................................................................................................44
Te
Review Exercises ............................................................................................................45
Cumulative Review Exercises ........................................................................................46
Chapter 4: Probability
Section 4-1: Basic Concepts of Probability ....................................................................49
st
Section 4-2: Addition Rule and Multiplication Rule ......................................................51
Section 4-3: Complements, Conditional Probability, and Bayes’ Theorem...................53
Section 4-4: Counting .....................................................................................................55
ba
Chapter Quick Quiz ........................................................................................................58
Review Exercises ............................................................................................................59
Cumulative Review Exercises ........................................................................................60
Chapter 5: Discrete Probability Distributions
nk
Section 5-1: Probability Distributions ............................................................................63
Section 5-2: Binomial Probability Distributions.............................................................65
Section 5-3: Poisson Probability Distributions ...............................................................69
sm
Chapter Quick Quiz ........................................................................................................71
Review Exercises ............................................................................................................71
Cumulative Review Exercises ........................................................................................72
af
ia
@Testbanksmafia
, Chapter 6: Normal Probability Distributions
Section 6-1: The Standard Normal Distribution .............................................................75
Section 6-2: Real Applications of Normal Distributions................................................78
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
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
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
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
Section 8-3: Testing a Claim About a Mean.................................................................137
Section 8-4: Testing a Claim About a Standard Deviation or Variance .......................144
Te
Chapter Quick Quiz ......................................................................................................148
Review Exercises ..........................................................................................................149
Cumulative Review Exercises ......................................................................................151
Chapter 9: Chapter 9: Inferences from Two Samples
st
Section 9-1: Two Proportions .......................................................................................153
Section 9-2: Two Means: Independent Samples...........................................................167
Section 9-3: Two Dependent Samples (Matched Pairs) ...............................................178
ba
Section 9-4: Two Variances or Standard Deviations....................................................186
Chapter Quick Quiz ......................................................................................................189
Review Exercises ..........................................................................................................190
Cumulative Review Exercises ......................................................................................192
nk
Chapter 10: Correlation and Regression
Section 10-1: Correlation..............................................................................................197
Section 10-2: Regression ..............................................................................................210
Section 10-3: Prediction Intervals and Variation..........................................................223
sm
Section 10-4: Multiple Regression................................................................................227
Section 10-5: Nonlinear Regression .............................................................................232
Chapter Quick Quiz ......................................................................................................237
Review Exercises ..........................................................................................................237
Cumulative Review Exercises ......................................................................................240
af
ia
@Testbanksmafia
, Chapter 11: Goodness-of-Fit and Contingency Tables
Section 11-1: Goodness-of-Fit......................................................................................243
Section 11-2: Contingency Tables ................................................................................251
Chapter Quick Quiz ......................................................................................................258
Review Exercises ..........................................................................................................258
Cumulative Review Exercises ......................................................................................260
Chapter 12: Analysis of Variance
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
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
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
Cumulative Review Exercises ......................................................................................291
Chapter 14: Statistical Process Control
Te
Section 14-1: Control Charts for Variation and Mean..................................................295
Section 14-2: Control Charts for Attributes..................................................................297
Chapter Quick Quiz ......................................................................................................302
Review Exercises ..........................................................................................................302
st
Cumulative Review Exercises ......................................................................................304
ba
nk
sm
af
ia
@Testbanksmafia
SOLUTIONS MANUAL
JAMES LAPP
Colorado Mesa University
ELEMENTARY STATISTICS
USING EXCEL
@
SIXTH EDITION
Te
Mario F. Triola
st
Dutchess Community College
ba
nk
sm
af
ia
@Testbanksmafia
, CONTENTS
Chapter 1: Introduction To Statistics
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
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
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
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
Section 3-3: Measures of Relative Standing and Boxplots.............................................39
Chapter Quick Quiz ........................................................................................................44
Te
Review Exercises ............................................................................................................45
Cumulative Review Exercises ........................................................................................46
Chapter 4: Probability
Section 4-1: Basic Concepts of Probability ....................................................................49
st
Section 4-2: Addition Rule and Multiplication Rule ......................................................51
Section 4-3: Complements, Conditional Probability, and Bayes’ Theorem...................53
Section 4-4: Counting .....................................................................................................55
ba
Chapter Quick Quiz ........................................................................................................58
Review Exercises ............................................................................................................59
Cumulative Review Exercises ........................................................................................60
Chapter 5: Discrete Probability Distributions
nk
Section 5-1: Probability Distributions ............................................................................63
Section 5-2: Binomial Probability Distributions.............................................................65
Section 5-3: Poisson Probability Distributions ...............................................................69
sm
Chapter Quick Quiz ........................................................................................................71
Review Exercises ............................................................................................................71
Cumulative Review Exercises ........................................................................................72
af
ia
@Testbanksmafia
, Chapter 6: Normal Probability Distributions
Section 6-1: The Standard Normal Distribution .............................................................75
Section 6-2: Real Applications of Normal Distributions................................................78
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
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
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
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
Section 8-3: Testing a Claim About a Mean.................................................................137
Section 8-4: Testing a Claim About a Standard Deviation or Variance .......................144
Te
Chapter Quick Quiz ......................................................................................................148
Review Exercises ..........................................................................................................149
Cumulative Review Exercises ......................................................................................151
Chapter 9: Chapter 9: Inferences from Two Samples
st
Section 9-1: Two Proportions .......................................................................................153
Section 9-2: Two Means: Independent Samples...........................................................167
Section 9-3: Two Dependent Samples (Matched Pairs) ...............................................178
ba
Section 9-4: Two Variances or Standard Deviations....................................................186
Chapter Quick Quiz ......................................................................................................189
Review Exercises ..........................................................................................................190
Cumulative Review Exercises ......................................................................................192
nk
Chapter 10: Correlation and Regression
Section 10-1: Correlation..............................................................................................197
Section 10-2: Regression ..............................................................................................210
Section 10-3: Prediction Intervals and Variation..........................................................223
sm
Section 10-4: Multiple Regression................................................................................227
Section 10-5: Nonlinear Regression .............................................................................232
Chapter Quick Quiz ......................................................................................................237
Review Exercises ..........................................................................................................237
Cumulative Review Exercises ......................................................................................240
af
ia
@Testbanksmafia
, Chapter 11: Goodness-of-Fit and Contingency Tables
Section 11-1: Goodness-of-Fit......................................................................................243
Section 11-2: Contingency Tables ................................................................................251
Chapter Quick Quiz ......................................................................................................258
Review Exercises ..........................................................................................................258
Cumulative Review Exercises ......................................................................................260
Chapter 12: Analysis of Variance
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
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
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
Cumulative Review Exercises ......................................................................................291
Chapter 14: Statistical Process Control
Te
Section 14-1: Control Charts for Variation and Mean..................................................295
Section 14-2: Control Charts for Attributes..................................................................297
Chapter Quick Quiz ......................................................................................................302
Review Exercises ..........................................................................................................302
st
Cumulative Review Exercises ......................................................................................304
ba
nk
sm
af
ia
@Testbanksmafia
