SALE

Test Bank for Elementary Statistics Using Excel, 4th Edition: Mario F. Triola

Original price was: $35.00.Current price is: $26.50.

Test Bank for Elementary Statistics Using Excel, 4th Edition: Mario F. Triola Digital Instant Download

Category:

This is completed downloadable of Test Bank for Elementary Statistics Using Excel, 4th Edition: Mario F. Triola

Product Details:

  • ISBN-10 ‏ : ‎ 0321564960
  • ISBN-13 ‏ : ‎ 978-0321564962
  • Author:  Mario F. Triola

Normal 0 false false false KEY BENEFIT: Elementary Statistics Using Excel, Fourth Edition, offers a complete introduction to basic statistics, featuring extensive instruction on the use of Excel spreadsheets for data analysis. Extensive Excel instructions are provided along with typical displays of results, as well as information about Excel’s limitations and alternative approaches to problem-solving. Real data in many examples help readers see the prevalence of statistics in the real world. KEY TOPICS: Introduction to Statistics; Summarizing and Graphing Data; Statistics for Describing, Exploring, and Comparing Data; Probability; Probability Distributions; Normal Probability Distributions; Estimates and Sample Sizes; Hypothesis Testing; Inferenc

 

Table of Content:

  1. Chapter 1 Introduction to Statistics
  2. Chapter Objectives
  3. 1-1 Statistical and Critical Thinking
  4. Prepare
  5. Analyze
  6. Conclude
  7. Analyzing Data: Potential Pitfalls
  8. 1-1 Basic Skills and Concepts
  9. Statistical Literacy and Critical Thinking
  10. 1-1 Beyond the Basics
  11. 1-2 Types of Data
  12. Part 1 Basic Types of Data
  13. Parameter / Statistic
  14. Quantitative / Categorical
  15. Discrete / Continuous
  16. Levels of Measurement
  17. Solution
  18. Part 2 Big Data and Missing Data: Too Much and Not Enough
  19. Big Data
  20. Missing Data
  21. 1-2 Basic Skills and Concepts
  22. Statistical Literacy and Critical Thinking
  23. 1-2 Beyond the Basics
  24. 1-3 Collecting Sample Data
  25. Design of Experiments
  26. Sampling Errors
  27. 1-3 Basic Skills and Concepts
  28. Statistical Literacy and Critical Thinking
  29. 1-3 Beyond the Basics
  30. 1-4 Introduction to Excel
  31. Excel 2016 and Excel 2016 for Mac
  32. Excel 2013
  33. Excel 2010
  34. Excel for Mac 2011
  35. Creating an Excel Worksheet
  36. Getting Help
  37. Undoing Your Work
  38. Saving an Excel File
  39. Opening Appendix B Data Sets in Excel
  40. Calculations with Excel
  41. Sorting Rows with Excel
  42. Printing an Excel Worksheet
  43. Closing Excel
  44. Using Excel for Statistical Functions
  45. Excel Add-Ins Installation
  46. 1-4 Basic Skills and Concepts
  47. Statistical Literacy and Critical Thinking
  48. 1-4 Beyond the Basics
  49. Chapter Quick Quiz
  50. Review Exercises
  51. Cumulative Review Exercises
  52. Excel Project
  53. Cooperative Group Activities
  54. 2 Exploring Data with Tables and Graphs
  55. Chapter Objectives
  56. 2-1 Frequency Distributions for Organizing and Summarizing Data
  57. Procedure for Constructing a Frequency Distribution
  58. Solution
  59. Relative Frequency Distribution
  60. Cumulative Frequency Distribution
  61. Critical Thinking: Using Frequency Distributions to Understand Data
  62. Normal Distribution
  63. Analysis of Last Digits
  64. Gaps
  65. Comparisons
  66. 2-1 Basic Skills and Concepts
  67. Statistical Literacy and Critical Thinking
  68. 2-1 Beyond the Basics
  69. 2-2 Histograms
  70. Relative Frequency Histogram
  71. Critical Thinking: Interpreting Histograms
  72. Common Distribution Shapes
  73. Normal Distribution
  74. Uniform Distribution
  75. Skewness
  76. Using Excel for Histograms
  77. Using XLSTAT to Generate Histograms
  78. Using Excel to Generate Histograms
  79. 2-3 Graphs That Enlighten and Graphs That Deceive
  80. Graphs That Enlighten
  81. Dotplots
  82. Stemplots
  83. Using XLSTAT for Stemplots
  84. Time-Series Graph
  85. Using Excel to Create Time-Series Graphs
  86. Bar Graphs
  87. Using Excel to Create Bar Graphs
  88. Pareto Charts
  89. Using Excel to Create Pareto Charts
  90. Pie Charts
  91. Using Excel to Create Pie Charts
  92. Frequency Polygon
  93. Using Excel to Create Frequency Polygons
  94. Graphs That Deceive
  95. Nonzero Vertical Axis
  96. Pictographs
  97. Concluding Thoughts
  98. 2-3 Basic Skills and Concepts
  99. Statistical Literacy and Critical Thinking
  100. 2-3 Beyond the Basics
  101. 2-4 Scatterplots, Correlation, and Regression
  102. Chapter Quick Quiz
  103. Review Exercises
  104. Cumulative Review Exercises
  105. Cooperative Group Activities
  106. 3 Describing, Exploring, and Comparing Data
  107. 3-1 Measures of Center
  108. Using Excel to Generate Descriptive Statistics
  109. 3-2 Measures of Variation
  110. Using Excel to Calculate Variance
  111. Why Is Standard Deviation Defined as in Formula 3-4?
  112. Why Not Use the Mean Absolute Deviation Instead of the Standard Deviation?
  113. Why Divide by n − 1?
  114. How Do We Make Sense of a Value of Standard Deviation?
  115. Empirical (or 68-95-99.7) Rule for Data with a Bell-Shaped Distribution
  116. Solution
  117. Chebyshev’s Theorem
  118. Solution
  119. Comparing Variation in Different Samples or Populations
  120. Solution
  121. Biased and Unbiased Estimators
  122. 3-2 Basic Skills and Concepts
  123. Statistical Literacy and Critical Thinking
  124. 3-2 Beyond the Basics
  125. 3-3 Measures of Relative Standing and Boxplots
  126. Using Excel to Find z Scores
  127. Solution
  128. Interpretation
  129. Percentiles
  130. Solution
  131. Interpretation
  132. Using Excel to Find Percentile Values
  133. Solution
  134. Solution
  135. Quartiles
  136. Using Excel to Find Quartiles
  137. Using XLSTAT for Quartiles
  138. Using Excel’s Quartile.Inc Function for Quartiles
  139. 5-Number Summary and Boxplot
  140. Solution
  141. Using Excel for a 5-Number Summary
  142. Using XLSTAT for a 5-Number Summary
  143. Using Excel’s QUARTILE.INC Function For a 5-Number Summary
  144. Solution
  145. Solution
  146. Outliers
  147. Identifying Outliers for Modified Boxplots
  148. Modified Boxplots
  149. Solution
  150. Using Excel to Generate Modified Boxplots
  151. Using XLSTAT for Modified Boxplots
  152. 3-3 Basic Skills and Concepts
  153. Statistical Literacy and Critical Thinking
  154. 3-3 Beyond the Basics
  155. Chapter Quick Quiz
  156. Review Exercises
  157. Cumulative Review Exercises
  158. Excel Project
  159. Cooperative Group Activities
  160. 4 Probability
  161. 4-1 Basic Concepts of Probability
  162. Excel Demonstration of the Law of Large Numbers
  163. Solution
  164. Solution
  165. Solution
  166. Solution
  167. Interpretation
  168. Solution
  169. Complementary Events
  170. Solution
  171. Interpretation
  172. Identifying Significant Results with Probabilities: The Rare Event Rule for Inferential Statistics
  173. Probability Review
  174. 4-2 Addition Rule and Multiplication Rule
  175. Addition Rule
  176. Notation for Addition Rule
  177. solution
  178. Disjoint Events and the Addition Rule
  179. Complementary Events and the Addition Rule
  180. Solution
  181. Multiplication Rule
  182. Notation for Multiplication Rule
  183. Independence and the Multiplication Rule
  184. Solution
  185. solution
  186. Solution
  187. Redundancy: Important Application of Multiplication Rule
  188. Solution
  189. Interpretation
  190. Rationale for the Multiplication Rule
  191. Summary of Addition Rule and Multiplication Rule
  192. 4-2 Basic Skills and Concepts
  193. Statistical Literacy and Critical Thinking
  194. 4-2 Beyond the Basics
  195. 4-3 Complements, Conditional Probability, and Bayes’ Theorem
  196. Confusion of the Inverse
  197. 4-4 Counting
  198. Using Excel to Calculate Factorials, Permutations, and Combinations
  199. Factorials
  200. Permutations Rule (When All of the Items Are Different)
  201. Combinations Rule
  202. 4-4 Basic Skills and Concepts
  203. Statistical Literacy and Critical Thinking
  204. 4-4 Beyond the Basics
  205. 4-5 Probabilities Through Simulations (available at www.TriolaStats.com)
  206. Chapter Quick Quiz
  207. Review Exercises
  208. Cumulative Review Exercises
  209. Excel Project
  210. Cooperative Group Activities
  211. 5 Discrete Probability Distributions
  212. 5-1 Probability Distributions
  213. Parameters of a Probability Distribution
  214. Expected Value
  215. Solution
  216. Interpretation
  217. Using Excel to Calculate μ, σ, and σ2 for a Probability Distribution
  218. Making Sense of Results: Significant Values
  219. Identifying Significant Results with the Range Rule of Thumb
  220. Solution
  221. Interpretation
  222. Identifying Significant Results with Probabilities:
  223. The Rare Event Rule for Inferential Statistics
  224. Solution
  225. Interpretation
  226. Expected Value
  227. Solution
  228. Interpretation
  229. Rationale for Formulas 5-1 Through 5-4
  230. 5-1 Basic Skills and Concepts
  231. Statistical Literacy and Critical Thinking
  232. 5-1 Beyond the Basics
  233. 5-2 Binomial Probability Distributions
  234. Methods for Finding Binomial Probabilities
  235. Rationale for the Binomial Probability Formula
  236. 5-2 Basic Skills and Concepts
  237. Statistical Literacy and Critical Thinking
  238. 5-2 Beyond the Basics
  239. 5-3 Poisson Probability Distributions
  240. Solution
  241. Poisson Distribution as Approximation to Binomial
  242. Solution
  243. Using Excel for Finding Poisson Probabilities
  244. 5-3 Basic Skills and Concepts
  245. Statistical Literacy and Critical Thinking
  246. 5-3 Beyond the Basics
  247. Chapter Quick Quiz
  248. Review Exercises
  249. Cumulative Review Exercises
  250. Excel Project
  251. Cooperative Group Activities
  252. 6 Normal Probability Distributions
  253. 6-1 The Standard Normal Distribution
  254. Normal Distributions
  255. Uniform Distributions
  256. Solution
  257. Interpretation
  258. Standard Normal Distribution
  259. Finding Probabilities When Given z Scores
  260. Solution
  261. Using Excel to Find Normal Distribution Areas
  262. Interpretation
  263. Solution
  264. Interpretation
  265. Solution
  266. Interpretation
  267. Finding z Scores from Known Areas
  268. 6-2 Real Applications of Normal Distributions
  269. Solution
  270. Interpretation
  271. Solution
  272. Interpretation
  273. Finding Values from Known Areas
  274. Solution
  275. Interpretation
  276. Significance
  277. Solution
  278. Interpretation
  279. 6-2 Basic Skills and Concepts
  280. Statistical Literacy and Critical Thinking
  281. 6-2 Beyond the Basics
  282. 6-3 Sampling Distributions and Estimators
  283. Sampling Distribution of Sample Proportion
  284. Solution
  285. Sampling Distribution of the Sample Mean
  286. Solution
  287. Interpretation
  288. Solution
  289. Sampling Distribution of the Sample Variance
  290. Solution
  291. Estimators: Unbiased and Biased
  292. 6-4 The Central Limit Theorem
  293. Interpretation
  294. Applying the Central Limit Theorem
  295. Solution
  296. Interpretation
  297. Introduction to Hypothesis Testing
  298. Identifying Significant Results with Probabilities: The Rare Event Rule for Inferential Statistics
  299. Solution
  300. Interpretation
  301. Correction for a Finite Population
  302. 6-4 Basic Skills and Concepts
  303. Statistical Literacy and Critical Thinking
  304. 6-4 Beyond the Basics
  305. 6-5 Assessing Normality
  306. 6-6 Normal as Approximation to Binomial
  307. Review Exercises
  308. Review Exercises
  309. Cumulative Review Exercises
  310. Excel Projects
  311. Cooperative Group Activities
  312. 7 Estimating Parameters and Determining Sample Sizes
  313. 7-1 Estimating a Population Proportion
  314. Point Estimate
  315. Solution
  316. Confidence Interval
  317. Interpreting a Confidence Interval
  318. Critical Values
  319. Solution
  320. Using Excel to Find Critical Values
  321. Margin of Error
  322. Using Excel for a Confidence Interval Estimate of p
  323. Solution
  324. Finding the Point Estimate and E from a Confidence Interval
  325. Solution
  326. Using Confidence Intervals for Hypothesis Tests
  327. Determining Sample Size
  328. Solution
  329. Interpretation
  330. Disadvantage of Wald Confidence Interval
  331. Better-Performing Confidence Intervals
  332. Plus Four Method
  333. Wilson Score
  334. Clopper-Pearson Method
  335. 7-1 Basic Skills and Concepts
  336. Statistical Literacy and Critical Thinking
  337. 7-1 Beyond the Basics
  338. 7-2 Estimating a Population Mean
  339. Using Excel to Construct a Confidence Interval Estimate of μ
  340. Excel—Working with Summary Statistics
  341. Solution
  342. Interpretation
  343. Interpreting the Confidence Interval
  344. Finding a Point Estimate and Margin of Error E from a Confidence Interval
  345. Using Confidence Intervals to Describe, Explore, or Compare Data
  346. Determining Sample Size
  347. Solution
  348. Interpretation
  349. Choosing the Appropriate Distribution
  350. 7-2 Basic Skills and Concepts
  351. Statistical Literacy and Critical Thinking
  352. 7-2 Beyond the Basics
  353. 7-3 Estimating a Population Standard Deviation or Variance
  354. Using Excel to Find Critical Values of χ2
  355. Procedure for Constructing a Confidence Interval for σ or σ2
  356. Using Confidence Intervals for Comparisons or Hypothesis Tests
  357. Solution
  358. Interpretation
  359. Rationale for the Confidence Interval
  360. Determining Sample Size
  361. Solution
  362. 7-3 Basic Skills and Concepts
  363. Statistical Literacy and Critical Thinking
  364. 7-3 Beyond the Basics
  365. 7-4 Bootstrapping: Using Excel for Estimates
  366. Using XLSTAT for Bootstrap Resampling
  367. 7-4 Basic Skills and Concepts
  368. Statistical Literacy and Critical Thinking
  369. 7-4 Beyond the Basics
  370. Chapter Quick Quiz
  371. Review Exercises
  372. Cumulative Review Exercises
  373. Excel Project
  374. Cooperative Group Activities
  375. 8 Hypothesis Testing
  376. 8-1 Basics of Hypothesis Testing
  377. Steps 1, 2, 3: Use the Original Claim to Create a Null Hypothesis H0 and an Alternative Hypothesis H1
  378. Step 4: Select the Significance Level α
  379. Step 5: Identify the Statistic Relevant to the Test and Determine Its Sampling Distribution (such as normal, t, or χ2)
  380. Step 6: Find the Value of the Test Statistic, Then Find Either the P-Value or the Critical Value(s)
  381. Two-Tailed, Left-Tailed, Right-Tailed
  382. P-Value Method
  383. P-Value and Hypothesis Testing Controversy
  384. Critical Value Method
  385. Step 7: Make a Decision to Either Reject H0 or Fail to Reject H0
  386. Step 8: Restate the Decision Using Simple and Nontechnical Terms
  387. Confidence Intervals for Hypothesis Tests
  388. Equivalent Methods
  389. Power and the Design of Experiments
  390. 8-1 Basic Skills and Concepts
  391. Statistical Literacy and Critical Thinking
  392. 8-1 Beyond the Basics
  393. 8-2 Testing a Claim About a Proportion
  394. Claim: Most Consumers Uncomfortable with Drone Deliveries
  395. Solution: P-Value Method
  396. Solution: Critical Value Method
  397. Solution: Confidence Interval Method
  398. Finding the Number of Successes x
  399. Solution
  400. Solution
  401. Interpretation
  402. 8-3 Testing a Claim About a Mean
  403. Part 1 Testing a Claim About μ with σ Not Known
  404. Equivalent Methods
  405. Requirement of Normality or n > 30
  406. Important Properties of the Student t Distribution
  407. P-Value Method with Excel
  408. Using Excel to Test a Claim About μ
  409. Excel: Working with Summary Statistics
  410. Solution
  411. Interpretation
  412. P-Value Method Without Technology
  413. Critical Value Method
  414. Confidence Interval Method
  415. Solution
  416. Interpretation
  417. Alternative Methods Used When Population Is Not Normal and n  30
  418. Solution
  419. Interpretation
  420. 8-4 Testing a Claim About a Standard Deviation or Variance
  421. Using Excel for Testing Claims About σ or σ2
  422. Excel: Working with Summary Statistics
  423. Solution
  424. Interpretation
  425. Critical Value Method
  426. Confidence Interval Method
  427. Solution
  428. Alternative Method Used When Population Is Not Normal
  429. 8-4 Basic Skills and Concepts
  430. Statistical Literacy and Critical Thinking
  431. 8-4 Beyond the Basics
  432. Chapter Quick Quiz
  433. Cumulative Review Exercises
  434. Cumulative Review Exercises
  435. Excel Project
  436. Cooperative Group Activities
  437. 9 Inferences from Two Samples
  438. 9-1 Two Proportions
  439. Using Excel for Inferences About Two Proportions
  440. Hypothesis Tests
  441. Confidence Intervals
  442. Hypothesis Tests
  443. P-Value Method
  444. Solution
  445. Interpretation
  446. Critical Value Method
  447. Confidence Intervals
  448. Solution
  449. Interpretation
  450. What Can We Do When the Requirements Are Not Satisfied?
  451. Rationale: Why Do the Procedures of This Section Work?
  452. 9-1 Basic Skills and Concepts
  453. Statistical Literacy and Critical Thinking
  454. 9-1 Beyond the Basics
  455. 9-2 Two Means: Independent Samples
  456. Using Excel for Inferences About Means of Two Independent Samples
  457. Using XLSTAT for Hypothesis Tests
  458. Using XLSTAT for Confidence Intervals
  459. Using Excel (Instead of XLSTAT) for Hypothesis Tests (not available in Excel for Mac 2011)
  460. P-Value Method
  461. Solution
  462. Interpretation
  463. Critical Value Method
  464. Confidence Intervals
  465. Solution
  466. Interpretation
  467. Alternative Method: Assume That σ1 = σ2 and Pool the Sample Variances
  468. Alternative Method Used When σ1 and σ2 Are Known
  469. Recommended Strategy for Two Independent Means
  470. 9-2 Basic Skills and Concepts
  471. Statistical Literacy and Critical Thinking
  472. 9-2 Beyond the Basics
  473. 9-3 Two Dependent Samples (Matched Pairs)
  474. Good Experimental Design
  475. Procedures for Inferences with Dependent Samples
  476. Equivalent Methods
  477. Using Excel for Inferences About Means of Differences from Two Dependent Samples
  478. Using XLSTAT for Hypothesis Tests
  479. Using XLSTAT for Confidence Intervals
  480. Using Excel (Instead of XLSTAT) for Hypothesis Tests (not available in Excel for Mac 2011)
  481. Solution
  482. Interpretation
  483. Solution
  484. Interpretation
  485. Alternative Method Used When Population Is Not Normal and n ≥ 30
  486. 9-3 Basic Skills and Concepts
  487. Statistical Literacy and Critical Thinking
  488. 9-3 Beyond the Basics
  489. 9-4 Two Variances or Standard Deviations
  490. Using Excel for Hypothesis Tests with Two Variances or Two Standard Deviations
  491. Using XLSTAT for Hypothesis Tests
  492. Using Excel for Hypothesis Tests (not available in Excel for Mac 2011)
  493. F Distribution
  494. Interpreting the Value of the F Test Statistic
  495. solution
  496. Interpretation
  497. Count Five
  498. Levene-Brown-Forsythe Test
  499. 9-4 Basic Skills and Concepts
  500. Statistical Literacy and Critical Thinking
  501. 9-4 Beyond the Basics
  502. Chapter Quick Quiz
  503. Review Exercises
  504. Cumulative Review Exercises
  505. Excel Project
  506. Cooperative Group Activities
  507. 10 Correlation and Regression
  508. 10-1 Correlation
  509. Explore!
  510. Interpreting Scatterplots
  511. Measure the Strength of the Linear Correlation with r
  512. Properties of the Linear Correlation Coefficient r
  513. Calculating the Linear Correlation Coefficient r
  514. Using XLSTAT for the Linear Correlation Coefficient r
  515. Using Excel for the Linear Correlation Coefficient r
  516. Using Excel for a Scatterplot
  517. Solution
  518. Solution
  519. Solution
  520. Is There a Linear Correlation?
  521. Solution
  522. Interpretation
  523. Interpreting r: Explained Variation
  524. Solution
  525. Interpretation
  526. Interpreting r with Causation: Don’t Go There!
  527. Common Errors Involving Correlation
  528. 10-2 Regression
  529. Using Excel for Regression
  530. Using XLSTAT for the Equation of the Regression Line
  531. Using Excel for the Equation of the Regression Line (not available in Excel for Mac 2011)
  532. Solution
  533. Solution
  534. Solution
  535. Making Predictions
  536. Solution
  537. Interpretation
  538. Interpreting the Regression Equation: Marginal Change
  539. Outliers and Influential Points
  540. Residuals and the Least-Squares Property
  541. Residual Plots
  542. 10-2 Basic Skills and Concepts
  543. Statistical Literacy and Critical Thinking
  544. 10-2 Beyond the Basics
  545. 10-3 Prediction Intervals and Variation
  546. Using Excel to Construct a Prediction Interval
  547. Using XLSTAT for a Prediction Interval
  548. Using Excel for a Prediction Interval (not available in Excel for Mac 2011)
  549. Solution
  550. Interpretation
  551. Explained and Unexplained Variation
  552. Coefficient of Determination
  553. Solution
  554. Interpretation
  555. 10-3 Basic Skills and Concepts
  556. Statistical Literacy and Critical Thinking
  557. 10-3 Beyond the Basics
  558. 10-4 Multiple Regression
  559. Using Excel for Multiple Regression
  560. Using XLSTAT for Multiple Regression
  561. Using Excel for Multiple Regression (not available in Excel for Mac 2011)
  562. Solution
  563. R2 and Adjusted R2
  564. P-Value
  565. Finding the Best Multiple Regression Equation
  566. Guidelines for Finding the Best Multiple Regression Equation
  567. Solution
  568. Interpretation
  569. Tests of Regression Coefficients
  570. Predictions With Multiple Regression
  571. Dummy Variable as a Predictor Variable
  572. solution
  573. Logistic Regression
  574. 10-4 Basic Skills and Concepts
  575. Statistical Literacy and Critical Thinking
  576. 10-4 Beyond the Basics
  577. 10-5 Nonlinear Regression
  578. Using Excel for Nonlinear Regression
  579. Solution
  580. solution
  581. 10-5 Basic Skills and Concepts
  582. Statistical Literacy and Critical Thinking
  583. 10-5 Beyond the Basics
  584. Chapter Quick Quiz
  585. Review Exercises
  586. Cumulative Review Exercises
  587. Excel Project
  588. Analyzing the Results
  589. Cooperative Group Activities
  590. 11 Goodness-of-Fit and Contingency Tables
  591. 11-1 Goodness-of-Fit
  592. 11-2 Contingency Tables
  593. Test of Homogeneity
  594. Fisher’s Exact Test
  595. McNemar’s Test for Matched Pairs
  596. 11-2 Basic Skills and Concepts
  597. Statistical Literacy and Critical Thinking
  598. 11-2 Beyond the Basics
  599. Chapter Quick Quiz
  600. Review Exercises
  601. Cumulative Review Exercises
  602. Excel Project
  603. Cooperative Group Activities
  604. 12 Analysis of Variance
  605. 12-1 One-Way ANOVA
  606. F Distribution
  607. Using Excel for One-Way Analysis of Variance
  608. Using XLSTAT for One-Way ANOVA
  609. Using Excel for One-Way ANOVA (not available in Excel for Mac 2011)
  610. Solution
  611. Interpretation
  612. How is the P-Value Related to the Test Statistic?
  613. Test Statistic for One-Way ANOVA: F = variance between samples / variance within samples
  614. Why Not Just Test Two Samples at a Time?
  615. Part 2 Calculations and Identifying Means That Are Different
  616. Calculating the Test Statistic F with Equal Sample Sizes n
  617. Finding the Critical Value
  618. Understanding the Effect of a Mean on the F Test Statistic
  619. Calculations with Unequal Sample Sizes
  620. Designing Experiments
  621. Identifying Which Means Are Different
  622. Bonferroni Multiple Comparison Test
  623. Solution
  624. Interpretation
  625. 12-1 Basic Skills and Concepts
  626. Statistical Literacy and Critical Thinking
  627. 12-1 Beyond the Basics
  628. 12-2 Two-Way ANOVA
  629. Explore Data with Means and an Interaction Graph
  630. Using Excel for Two-Way Analysis of Variance
  631. Using XLSTAT for Two-Way ANOVA
  632. Using Excel for Two-Way ANOVA (not available in Excel for Mac 2011)
  633. solution
  634. Interpretation
  635. 12-2 Basic Skills and Concepts
  636. Statistical Literacy and Critical Thinking
  637. 12-2 Beyond the Basics
  638. Chapter Quick Quiz
  639. Review Exercises
  640. Cumulative Review Exercises
  641. Excel Project
  642. Cooperative Group Activities
  643. 13 Nonparametric Tests
  644. 13-1 Basics of Nonparametric Tests
  645. 13-2 Sign Test
  646. Using Excel to Find Sign Test P-values
  647. Using XLSTAT to Find Sign Test P-values
  648. Using Excel (Instead of XLSTAT) to Find Sign Test P-values
  649. Interpretation
  650. Claims About Matched Pairs
  651. solution
  652. Interpretation
  653. Claims Involving Nominal Data with Two Categories
  654. Solution
  655. Interpretation
  656. Claims About the Median of a Single Population
  657. Solution
  658. Interpretation
  659. 13-3 Wilcoxon Signed-Ranks Test for Matched Pairs
  660. Claims Involving Matched Pairs
  661. Using Excel to Find Wilcoxon Signed-Ranks Test P-Values
  662. Solution
  663. Interpretation
  664. Claims About the Median of a Single Population
  665. Solution
  666. 13-4 Wilcoxon Rank-Sum Test for Two Independent Samples
  667. Using Excel to Find Wilcoxon Rank-Sum Test P-Values
  668. Solution
  669. Interpretation
  670. 13-4 Basic Skills and Concepts
  671. Statistical Literacy and Critical Thinking
  672. 13-4 Beyond the Basics
  673. 13-5 Kruskal-Wallis Test for Three or More Samples
  674. Using Excel to Find Kruskal-Wallis P-Values
  675. Solution
  676. Interpretation
  677. 13-6 Rank Correlation
  678. Using Excel to Find the Rank Correlation Coefficient
  679. Using XLSTAT to Find the Rank Correlation Coefficient
  680. Using Excel (Instead of XLSTAT) to Find the Rank Correlation Coefficient
  681. Solution
  682. Solution
  683. Detecting Nonlinear Patterns
  684. 13-6 Basic Skills and Concepts
  685. Statistical Literacy and Critical Thinking
  686. 13-6 Beyond the Basics
  687. 13-7 Runs Test for Randomness
  688. Fundamental Principle of the Runs Test
  689. Solution
  690. Solution
  691. Interpretation
  692. Testing for Randomness Above and Below the Mean or Median
  693. 13-7 Basic Skills and Concepts
  694. Statistical Literacy and Critical Thinking
  695. 13-7 Beyond the Basics
  696. Chapter Quick Quiz
  697. Review Exercises
  698. Cumulative Review Exercises
  699. Excel Project
  700. Cooperative Group Activities
  701. 14 Statistical Process Control
  702. 14-1 Control Charts for Variation and Mean
  703. Process Data
  704. Run Chart
  705. Solution
  706. Interpretation
  707. Interpreting Run Charts
  708. Causes of Variation
  709. Control Charts
  710. Control Chart for Monitoring Variation: The R Chart
  711. Solution
  712. Interpreting Control Charts
  713. Out-of-Control-Criteria
  714. Solution
  715. Interpretation
  716. Control Chart for Monitoring Means: The x Chart
  717. Solution
  718. Interpretation
  719. Using Excel to Create Run Charts, R Charts, and x Charts
  720. 14-2 Control Charts for Attributes
  721. Using XLSTAT to Create p Charts
  722. solution
  723. Interpretation
  724. 14-2 Basic Skills and Concepts
  725. Statistical Literacy and Critical Thinking
  726. 14-2 Beyond the Basics
  727. Chapter Quick Quiz
  728. Review Exercises
  729. Cumulative Review Exercises
  730. Excel Project
  731. Cooperative Group Activities
  732. 15 Ethics in Statistics
  733. IV. Enforcing Ethics
  734. Discussion Points
  735. Appendix A Tables
  736. Negative z Scores
  737. Positive z Scores
  738. Appendix B Data Sets
  739. Data Set 1: Body Data
  740. Data Set 2: Foot and Height
  741. Data Set 3: Body Temperatures
  742. Data Set 4: Births
  743. Data Set 5: Family Heights
  744. Data Set 6: Freshman 15
  745. Data Set 7: IQ and Lead
  746. Data Set 8: IQ and Brain Size
  747. Data Set 9: Bear Measurements
  748. Data Set 10: Manatee Deaths
  749. Data Set 11: Alcohol and Tobacco in Movies
  750. Data Set 12: Passive and Active Smoke
  751. Data Set 13: Cigarette Contents
  752. Data Set 14: Oscar Winner Age
  753. Data Set 15: Presidents
  754. Data Set 16: Nobel Laureates and Chocolate
  755. Data Set 17: Course Evaluations
  756. Data Set 18: Speed Dating
  757. Data Set 19: Car Crash Tests
  758. Data Set 20: Car Measurements
  759. Data Set 21: Earthquakes
  760. Data Set 22: Tornadoes
  761. Data Set 23: Old Faithful
  762. Data Set 24: Word Counts
  763. Data Set 25: Fast Food
  764. Data Set 26: Cola Weights and Volumes
  765. Data Set 27: M&M Weights
  766. Data Set 28: Chocolate Chip Cookies
  767. Data Set 29: Coin Weights
  768. Data Set 30: Aluminum Cans
  769. Data Set 31: Garbage Weight
  770. Data Set 32: Airport Data Speeds
  771. Appendix C Websites and Bibliography of Books
  772. Appendix D Answers to Odd-Numbered Section Exercises, plus Answers to All Chapter Quick Quizzes, Chapter Review Exercises, and Cumulative Review Exercises
  773. Chapter 1 Answers
  774. Section 1-1
  775. Section 1-2
  776. Section 1-3
  777. Section 1-4
  778. Chapter 1 : Quick Quiz
  779. Chapter 1 : Review Exercises
  780. Chapter 1 : Cumulative Review Exercises
  781. Chapter 2 Answers
  782. Section 2-1
  783. Section 2-2
  784. Section 2-3
  785. Section 2-4
  786. Chapter 2 : Quick Quiz
  787. Chapter 2 : Review Exercises
  788. Chapter 2 : Cumulative Review Exercises
  789. Chapter 3 Answers
  790. Section 3-1
  791. Section 3-2
  792. Section 3-3
  793. Chapter 3 : Quick Quiz
  794. Chapter 3 : Review Exercises
  795. Chapter 3 : Cumulative Review Exercises
  796. Chapter 4 Answers
  797. Section 4-1
  798. Section 4-2
  799. Section 4-3
  800. Section 4-4
  801. Chapter 4 : Quick Quiz
  802. Chapter 4 : Review Exercises
  803. Chapter 4 : Cumulative Review Exercises
  804. Chapter 5 Answers
  805. Section 5-1
  806. Section 5-2
  807. Section 5-3
  808. Chapter 5 : Quick Quiz
  809. Chapter 5 : Review Exercises
  810. Chapter 5 : Cumulative Review Exercises
  811. Chapter 6 Answers
  812. Section 6-1
  813. Section 6-2
  814. Section 6-3
  815. Section 6-4
  816. Section 6-5
  817. Section 6-6
  818. Chapter 6: Quick Quiz
  819. Chapter 6 : Review Exercises
  820. Chapter 6 : Cumulative Review Exercises
  821. Chapter 7 Answers
  822. Section 7-1
  823. Section 7-2
  824. Section 7-3
  825. Section 7-4
  826. Chapter 7 : Quick Quiz
  827. Chapter 7 : Review Exercises
  828. Chapter 7 : Cumulative Review Exercises
  829. Chapter 8 Answers
  830. Section 8-1
  831. Section 8-2
  832. Section 8-3
  833. Section 8-4
  834. Chapter 8 : Quick Quiz
  835. Chapter 8 : Review Exercises
  836. Chapter 8 : Cumulative Review Exercises
  837. Chapter 9 Answers
  838. Section 9-1
  839. Section 9-2
  840. Section 9-3
  841. Section 9-4
  842. Chapter 9 : Quick Quiz
  843. Chapter 9 : Review Exercises
  844. Chapter 9 : Cumulative Review Exercises
  845. Chapter 10 Answers
  846. Section 10-1
  847. Section 10-2
  848. Section 10-3
  849. Section 10-4
  850. Section 10-5
  851. Chapter 10 : Quick Quiz
  852. Chapter 10 : Review Exercises
  853. Chapter 10 : Cumulative Review Exercises
  854. Chapter 11 Answers
  855. Section 11-1
  856. Section 11-2
  857. Chapter 11 : Quick Quiz
  858. Chapter 11 : Review Exercises
  859. Chapter 11 : Cumulative Review Exercises
  860. Chapter 12 Answers
  861. Section 12-1
  862. Section 12-2
  863. Chapter 12 : Chapter Quick Quiz
  864. Chapter 12 : Review Exercises
  865. Chapter 12 : Cumulative Review Exercises
  866. Chapter 13 Answers
  867. Section 13-1
  868. Section 13-3
  869. Section 13-4
  870. Section 13-5
  871. Section 13-6
  872. Section 13-7
  873. Chapter 13 : Quick Quiz
  874. Chapter 13 : Review Exercises
  875. Chapter 13 : Cumulative Review Exercises
  876. Chapter 14 Answers
  877. Section 14-1
  878. Section 14-2
  879. Chapter 14 : Quick Quiz
  880. Chapter 14: Review Exercises
  881. Chapter 14 : Cumulative Review Exercises
  882. Credits
  883. Photos
  884. Chapter 1
  885. Chapter 2
  886. Chapter 3
  887. Chapter 4
  888. Chapter 5
  889. Chapter 6
  890. Chapter 7
  891. Chapter 8
  892. Chapter 9
  893. Chapter 10
  894. Chapter 11
  895. Chapter 12
  896. Chapter 13
  897. Chapter 14
  898. Chapter 15
  899. Cover
  900. FM
  901. Text
  902. Chapter 1
  903. Chapter 2
  904. Chapter 3
  905. Chapter 4
  906. Chapter 5
  907. Chapter 6
  908. Chapter 7
  909. Chapter 8
  910. Chapter 9
  911. Chapter 10
  912. Chapter 11
  913. Chapter 12
  914. Chapter 13
  915. Chapter 14
  916. Appendix A
  917. Appendix B
  918. Barrelfold
  919. Index
  920. A
  921. B
  922. C
  923. D
  924. E
  925. F
  926. G
  927. H
  928. I
  929. J
  930. K
  931. L
  932. M
  933. N
  934. O
  935. P
  936. Q
  937. R
  938. S
  939. T
  940. U
  941. V
  942. W
  943. X
  944. Y
  945. Z
  946. Excel Quick References

Related products