Solutions Manual for Elementary Statistics Using Excel, 7th Edition by Mario F. Triola
Solutions Manual for Elementary Statistics Using Excel, 7th Edition by Mario F. Triola
,Solutions Manual for Elementary Statistics Using Excel, 7th Edition by Mario F. Triola
SOLUTIONS MANUAL
Elementary Statistics Using Excel, 7th Edition By
SOLUTION MANUAL FORMario Triola
Elementary Statistics Using Excel, 7th Edition By Mario F. Triola Chapter 1-15
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
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
Section 2-2: Histograms .................................................................................................. 15
Section 2-3: Graphs That Enlighten and Graphs That Deceive ...................................... 18
Section 2-4: Scatterplots, Correlation, and Regression ................................................... 21
Quick Quiz ...................................................................................................................... 23
Review Exercises ............................................................................................................ 24
Cumulative Review Exercises ......................................................................................... 25
Chapter 3: Describing, Exploring, and Comparing Data
Section 3-1: Measures of Center ..................................................................................... 27
Section 3-2: Measures of Variation ................................................................................. 35
Section 3-3: Measures of Relative Standing and Boxplots ............................................. 42
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
Solutions Manual for Elementary Statistics Using Excel, 7th Edition by Mario F. Triola
,Solutions Manual for Elementary Statistics Using Excel, 7th Edition by Mario F. Triola
Section 5-2: Binomial Probability Distributions ............................................................. 67
Section 5-3: Poisson Probability Distributions................................................................ 70
Quick Quiz ...................................................................................................................... 72
Review Exercises ............................................................................................................ 73
Cumulative Review Exercises ......................................................................................... 74
Solutions Manual for Elementary Statistics Using Excel, 7th Edition by Mario F. Triola
, Solutions Manual for Elementary Statistics Using Excel, 7th Edition by Mario F. Triola
Chapter 6: Normal Probability Distributions
Section 6-1: The Standard Normal Distribution .............................................................. 77
Section 6-2: Real Applications of Normal Distributions................................................. 79
Section 6-3: Sampling Distributions and Estimators....................................................... 83
Section 6-4: The Central Limit Theorem ........................................................................ 87
Section 6-5: Assessing Normality ................................................................................... 91
Section 6-6: Normal as Approximation to Binomial (Download Only) ......................... 94
Quick Quiz ...................................................................................................................... 97
Review Exercises ............................................................................................................ 98
Cumulative Review Exercises ......................................................................................... 99
Chapter 7: Estimating Parameters and Determining Sample Sizes
Section 7-1: Estimating a Population Proportion .......................................................... 101
Section 7-2: Estimating a Population Mean .................................................................. 106
Section 7-3: Estimating a Population Standard Deviation or Variance......................... 111
Section 7-4: Bootstrapping: Using Excel for Estimates ................................................ 115
Quick Quiz .................................................................................................................... 117
Review Exercises .......................................................................................................... 117
Cumulative Review Exercises ....................................................................................... 119
Chapter 8: Hypothesis Testing
Section 8-1: Basics of Hypothesis Testing .................................................................... 121
Section 8-2: Testing a Claim About a Proportion ......................................................... 123
Section 8-3: Testing a Claim About a Mean ................................................................. 131
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
Chapter 10: Correlation and Regression
Section 10-1: Correlation ..............................................................................................189
Solutions Manual for Elementary Statistics Using Excel, 7th Edition by Mario F. Triola
Solutions Manual for Elementary Statistics Using Excel, 7th Edition by Mario F. Triola
,Solutions Manual for Elementary Statistics Using Excel, 7th Edition by Mario F. Triola
SOLUTIONS MANUAL
Elementary Statistics Using Excel, 7th Edition By
SOLUTION MANUAL FORMario Triola
Elementary Statistics Using Excel, 7th Edition By Mario F. Triola Chapter 1-15
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
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
Section 2-2: Histograms .................................................................................................. 15
Section 2-3: Graphs That Enlighten and Graphs That Deceive ...................................... 18
Section 2-4: Scatterplots, Correlation, and Regression ................................................... 21
Quick Quiz ...................................................................................................................... 23
Review Exercises ............................................................................................................ 24
Cumulative Review Exercises ......................................................................................... 25
Chapter 3: Describing, Exploring, and Comparing Data
Section 3-1: Measures of Center ..................................................................................... 27
Section 3-2: Measures of Variation ................................................................................. 35
Section 3-3: Measures of Relative Standing and Boxplots ............................................. 42
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
Solutions Manual for Elementary Statistics Using Excel, 7th Edition by Mario F. Triola
,Solutions Manual for Elementary Statistics Using Excel, 7th Edition by Mario F. Triola
Section 5-2: Binomial Probability Distributions ............................................................. 67
Section 5-3: Poisson Probability Distributions................................................................ 70
Quick Quiz ...................................................................................................................... 72
Review Exercises ............................................................................................................ 73
Cumulative Review Exercises ......................................................................................... 74
Solutions Manual for Elementary Statistics Using Excel, 7th Edition by Mario F. Triola
, Solutions Manual for Elementary Statistics Using Excel, 7th Edition by Mario F. Triola
Chapter 6: Normal Probability Distributions
Section 6-1: The Standard Normal Distribution .............................................................. 77
Section 6-2: Real Applications of Normal Distributions................................................. 79
Section 6-3: Sampling Distributions and Estimators....................................................... 83
Section 6-4: The Central Limit Theorem ........................................................................ 87
Section 6-5: Assessing Normality ................................................................................... 91
Section 6-6: Normal as Approximation to Binomial (Download Only) ......................... 94
Quick Quiz ...................................................................................................................... 97
Review Exercises ............................................................................................................ 98
Cumulative Review Exercises ......................................................................................... 99
Chapter 7: Estimating Parameters and Determining Sample Sizes
Section 7-1: Estimating a Population Proportion .......................................................... 101
Section 7-2: Estimating a Population Mean .................................................................. 106
Section 7-3: Estimating a Population Standard Deviation or Variance......................... 111
Section 7-4: Bootstrapping: Using Excel for Estimates ................................................ 115
Quick Quiz .................................................................................................................... 117
Review Exercises .......................................................................................................... 117
Cumulative Review Exercises ....................................................................................... 119
Chapter 8: Hypothesis Testing
Section 8-1: Basics of Hypothesis Testing .................................................................... 121
Section 8-2: Testing a Claim About a Proportion ......................................................... 123
Section 8-3: Testing a Claim About a Mean ................................................................. 131
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
Chapter 10: Correlation and Regression
Section 10-1: Correlation ..............................................................................................189
Solutions Manual for Elementary Statistics Using Excel, 7th Edition by Mario F. Triola
