Exam (elaborations)
Solution Manual for Elementary Statistics Using Excel, 6th Edition By Mario F. Triola
- Course
- Institution
Solution Manual for Elementary Statistics Using Excel, 6th Edition By Mario F. Triola
[Show more]
Content preview
INSTRUCTOR’SSOLUTIONS MANUAL
JAMES LAPP
Colorado Mesa University
M
ED
ELEMENTARY STATISTICS
CO
USING EXCEL
NN
SIXTH EDITION
OI
Mario F. Triola
SS
Dutchess Community College
EU
R
, 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
M
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
ED
Section 2-4: Scatterplots, Correlation, and Regression ..................................................19
Chapter Quick Quiz ........................................................................................................20
Review Exercises ............................................................................................................21
CO
Cumulative Review Exercises ........................................................................................23
Chapter 3: Describing, Exploring, and Comparing Data
Section 3-1: Measures of Center.....................................................................................25
NN
Section 3-2: Measures of Variation ................................................................................32
Section 3-3: Measures of Relative Standing and Boxplots.............................................39
Chapter Quick Quiz ........................................................................................................44
Review Exercises ............................................................................................................45
OI
Cumulative Review Exercises ........................................................................................46
Chapter 4: Probability
Section 4-1: Basic Concepts of Probability ....................................................................49
SS
Section 4-2: Addition Rule and Multiplication Rule ......................................................51
Section 4-3: Complements, Conditional Probability, and Bayes’ Theorem...................53
Section 4-4: Counting .....................................................................................................55
EU
Chapter Quick Quiz ........................................................................................................58
Review Exercises ............................................................................................................59
Cumulative Review Exercises ........................................................................................60
R
Chapter 5: Discrete Probability Distributions
Section 5-1: Probability Distributions ............................................................................63
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
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
M
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
ED
Section 7-4: Bootstrapping: Using Excel for Estimates ...............................................120
Chapter Quick Quiz ......................................................................................................122
Review Exercises ..........................................................................................................123
CO
Cumulative Review Exercises ......................................................................................124
Chapter 8: Hypothesis Testing
Section 8-1: Basics of Hypothesis Testing ...................................................................127
NN
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
Chapter Quick Quiz ......................................................................................................148
Review Exercises ..........................................................................................................149
OI
Cumulative Review Exercises ......................................................................................151
Chapter 9: Chapter 9: Inferences from Two Samples
SS
Section 9-1: Two Proportions .......................................................................................153
Section 9-2: Two Means: Independent Samples...........................................................167
Section 9-3: Two Dependent Samples (Matched Pairs) ...............................................178
EU
Section 9-4: Two Variances or Standard Deviations....................................................186
Chapter Quick Quiz ......................................................................................................189
Review Exercises ..........................................................................................................190
R
Cumulative Review Exercises ......................................................................................192
Chapter 10: Correlation and Regression
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
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
M
Cumulative Review Exercises ......................................................................................268
Chapter 13: Nonparametric Tests
Section 13-2: Sign Test.................................................................................................271
ED
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
CO
Section 13-6: Rank Correlation ....................................................................................284
Section 13-7: Runs Test for Randomness.....................................................................286
Chapter Quick Quiz ......................................................................................................288
Review Exercises ..........................................................................................................289
NN
Cumulative Review Exercises ......................................................................................291
Chapter 14: Statistical Process Control
Section 14-1: Control Charts for Variation and Mean..................................................295
OI
Section 14-2: Control Charts for Attributes..................................................................297
Chapter Quick Quiz ......................................................................................................302
Review Exercises ..........................................................................................................302
SS
Cumulative Review Exercises ......................................................................................304
EU
R
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller MedConnoisseur. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $19.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
80364 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now