Elementary Statistics Using Excel – 7th
Edition
ST
INSTRUCTOR’S
UV
SOLUTIONS
IA
_A
MANUAL
PP
Mario F. Triola
RO
Comprehensive Solutions Manual for Instructors
VE
and Students
D?
© Mario F. Triola
All rights reserved. Reproduction or distribution without permission is prohibited.
??
©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
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
IA
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
_A
Review Exercises ............................................................................................................24
Cumulative Review Exercises ........................................................................................25
Chapter 3: Describing, Exploring, and Comparing Data
Section 3-1: Measures of Center .....................................................................................27
Section 3-2: Measures of Variation ................................................................................35
PP
Section 3-3: Measures of Relative Standing and Boxplots .............................................42
Quick Quiz ......................................................................................................................47
Review Exercises ............................................................................................................47
Cumulative Review Exercises ........................................................................................49
RO
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
VE
Quick Quiz ......................................................................................................................60
Review Exercises ............................................................................................................61
Cumulative Review Exercises ........................................................................................62
Chapter 5: Discrete Probability Distributions
D?
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
, Chapter 6: Normal Probability Distributions
Section 6-1: The Standard Normal Distribution .............................................................77
Section 6-2: Real Applications of Normal Distributions ................................................79
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 (Download Only) .........................94
UV
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
IA
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
_A
Review Exercises ..........................................................................................................117
Cumulative Review Exercises ......................................................................................119
Chapter 8: Hypothesis Testing
Section 8-1: Basics of Hypothesis Testing ...................................................................121
Section 8-2: Testing a Claim About a Proportion .........................................................123
PP
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
RO
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
VE
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
D?
??
, Chapter 10: Correlation and Regression
Section 10-1: Correlation ..............................................................................................189
Section 10-2: Regression ..............................................................................................198
ST
Section 10-3: Prediction Intervals and Variation ..........................................................210
Section 10-4: Multiple Regression................................................................................213
Section 10-5: Nonlinear Regression .............................................................................217
Quick Quiz ....................................................................................................................222
UV
Review Exercises ..........................................................................................................223
Cumulative Review Exercises ......................................................................................224
Chapter 11: Goodness-of-Fit and Contingency Tables
Section 11-1: Goodness-of-Fit ......................................................................................229
Section 11-2: Contingency Tables ................................................................................235
IA
Quick Quiz ....................................................................................................................241
Review Exercises ..........................................................................................................242
Cumulative Review Exercises ......................................................................................243
Chapter 12: Analysis of Variance
_A
Section 12-1: One-Way ANOVA .................................................................................247
Section 12-2: Two-Way ANOVA ................................................................................249
Quick Quiz ....................................................................................................................251
Review Exercises ..........................................................................................................251
Cumulative Review Exercises ......................................................................................252
PP
Chapter 13: Nonparametric Tests
Section 13-2: Sign Test .................................................................................................255
Section 13-3: Wilcoxon Signed-Ranks Test for Matched Pairs ...................................257
Section 13-4: Wilcoxon Rank-Sum Test for Two Independent Samples .....................259
RO
Section 13-5: Kruskal-Wallis Test for Three or More Samples ...................................263
Section 13-6: Rank Correlation ....................................................................................266
Section 13-7: Runs Test for Randomness .....................................................................270
Quick Quiz ....................................................................................................................271
Review Exercises ..........................................................................................................272
Cumulative Review Exercises ......................................................................................274
VE
Chapter 14: Statistical Process Control
Section 14-1: Control Charts for Variation and Mean ..................................................277
Section 14-2: Control Charts for Attributes ..................................................................279
Quick Quiz ....................................................................................................................284
D?
Review Exercises ..........................................................................................................284
Cumulative Review Exercises ......................................................................................286
Chapter 15: Holistic Statistics
Holistic Statistics Exercises ..........................................................................................289
??
Edition
ST
INSTRUCTOR’S
UV
SOLUTIONS
IA
_A
MANUAL
PP
Mario F. Triola
RO
Comprehensive Solutions Manual for Instructors
VE
and Students
D?
© Mario F. Triola
All rights reserved. Reproduction or distribution without permission is prohibited.
??
©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
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
IA
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
_A
Review Exercises ............................................................................................................24
Cumulative Review Exercises ........................................................................................25
Chapter 3: Describing, Exploring, and Comparing Data
Section 3-1: Measures of Center .....................................................................................27
Section 3-2: Measures of Variation ................................................................................35
PP
Section 3-3: Measures of Relative Standing and Boxplots .............................................42
Quick Quiz ......................................................................................................................47
Review Exercises ............................................................................................................47
Cumulative Review Exercises ........................................................................................49
RO
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
VE
Quick Quiz ......................................................................................................................60
Review Exercises ............................................................................................................61
Cumulative Review Exercises ........................................................................................62
Chapter 5: Discrete Probability Distributions
D?
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
, Chapter 6: Normal Probability Distributions
Section 6-1: The Standard Normal Distribution .............................................................77
Section 6-2: Real Applications of Normal Distributions ................................................79
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 (Download Only) .........................94
UV
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
IA
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
_A
Review Exercises ..........................................................................................................117
Cumulative Review Exercises ......................................................................................119
Chapter 8: Hypothesis Testing
Section 8-1: Basics of Hypothesis Testing ...................................................................121
Section 8-2: Testing a Claim About a Proportion .........................................................123
PP
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
RO
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
VE
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
D?
??
, Chapter 10: Correlation and Regression
Section 10-1: Correlation ..............................................................................................189
Section 10-2: Regression ..............................................................................................198
ST
Section 10-3: Prediction Intervals and Variation ..........................................................210
Section 10-4: Multiple Regression................................................................................213
Section 10-5: Nonlinear Regression .............................................................................217
Quick Quiz ....................................................................................................................222
UV
Review Exercises ..........................................................................................................223
Cumulative Review Exercises ......................................................................................224
Chapter 11: Goodness-of-Fit and Contingency Tables
Section 11-1: Goodness-of-Fit ......................................................................................229
Section 11-2: Contingency Tables ................................................................................235
IA
Quick Quiz ....................................................................................................................241
Review Exercises ..........................................................................................................242
Cumulative Review Exercises ......................................................................................243
Chapter 12: Analysis of Variance
_A
Section 12-1: One-Way ANOVA .................................................................................247
Section 12-2: Two-Way ANOVA ................................................................................249
Quick Quiz ....................................................................................................................251
Review Exercises ..........................................................................................................251
Cumulative Review Exercises ......................................................................................252
PP
Chapter 13: Nonparametric Tests
Section 13-2: Sign Test .................................................................................................255
Section 13-3: Wilcoxon Signed-Ranks Test for Matched Pairs ...................................257
Section 13-4: Wilcoxon Rank-Sum Test for Two Independent Samples .....................259
RO
Section 13-5: Kruskal-Wallis Test for Three or More Samples ...................................263
Section 13-6: Rank Correlation ....................................................................................266
Section 13-7: Runs Test for Randomness .....................................................................270
Quick Quiz ....................................................................................................................271
Review Exercises ..........................................................................................................272
Cumulative Review Exercises ......................................................................................274
VE
Chapter 14: Statistical Process Control
Section 14-1: Control Charts for Variation and Mean ..................................................277
Section 14-2: Control Charts for Attributes ..................................................................279
Quick Quiz ....................................................................................................................284
D?
Review Exercises ..........................................................................................................284
Cumulative Review Exercises ......................................................................................286
Chapter 15: Holistic Statistics
Holistic Statistics Exercises ..........................................................................................289
??
