Applied statistics for engineers and scientists : using Microsoft Excel and MINITAB / David M. Levine, Patricia P. Ramsey, Robert K. Smidt.
Material type: TextPublication details: Upper Saddle River, N.J. : Prentice Hall, c2001.Description: 1 v. (various pagings) : ill. ; 26 cm. + 1 computer optical disc (4 3/4 in.)ISBN:- 0134888014
- 519.5 LEV
Item type | Current library | Call number | Copy number | Status | Date due | Barcode | |
---|---|---|---|---|---|---|---|
Standard Loan | Moylish Library Main Collection | 519.5 LEV (Browse shelf(Opens below)) | 1 | Available | 39002000345679 | ||
Standard Loan | Moylish Library Main Collection | 519.5 LEV (Browse shelf(Opens below)) | 2 | Available | 39002000378092 | ||
Standard Loan | Moylish Library Main Collection | 519.5 LEV (Browse shelf(Opens below)) | 3 | Available | 39002000377532 | ||
Standard Loan | Moylish Library Main Collection | 519.5 LEV (Browse shelf(Opens below)) | 4 | Available | 39002000350448 | ||
Standard Loan | Moylish Library Main Collection | 519.5 LEV (Browse shelf(Opens below)) | 5 | Available | 39002000350315 | ||
Standard Loan | Moylish Library Main Collection | 519.5 LEV (Browse shelf(Opens below)) | 6 | Available | 39002000343088 | ||
Standard Loan | Moylish Library Main Collection | 519.5 LEV (Browse shelf(Opens below)) | 7 | Available | 39002000367020 | ||
Standard Loan | Moylish Library Main Collection | 519.5 LEV (Browse shelf(Opens below)) | 9 | Available | 39002100348516 | ||
Standard Loan | Moylish Library Main Collection | 519.5 LEV (Browse shelf(Opens below)) | 10 | Available | 39002100394064 |
Browsing Moylish Library shelves, Shelving location: Main Collection Close shelf browser (Hides shelf browser)
Enhanced descriptions from Syndetics:
This applied book for engineers and scientists, written in a non-theoretical manner, focuses on underlying principles that are important in a wide range of disciplines. It emphasizes the interpretation of results, the presentation and evaluation of assumptions, and the discussion of what should be done if the assumptions are violated. Integration of spreadsheet and statistical software complete this treatment of statistics. KEY TOPICS: Chapter topics include describing and summarizing data; probability and discrete probability distributions; continuous probability distributions and sampling distributions; process control charts; estimation procedures; hypothesis testing; the design of experiments; and simple linear and multiple regression models. For individuals interested in learning statistics-without a high level of mathematical sophistication.
Please Note: The CD-ROM originally included is no longer available. However, the data files can be downloaded at www.prenhall.com/sincich . And the PHStat2 content can be purchased standalone.Includes index.
System requirements: Microsoft Excel 7.0 (also known as Excel 95), Excel 97 or Excel 2000.
Table of contents provided by Syndetics
- Preface (p. xi)
- Chapter 1 Introduction to Statistics and Quality Improvement (p. 1)
- 1.1 What Is Statistics? (p. 1)
- 1.2 Why Study Statistics? (p. 2)
- 1.3 Statistical Thinking: Understanding and Managing Variability (p. 4)
- 1.4 Variables, Types of Data, and Levels of Measurement (p. 4)
- 1.5 Operational Definitions (p. 8)
- 1.6 Sampling (p. 10)
- 1.7 Statistical and Spreadsheet Software (p. 15)
- 1.8 Introduction to Quality (p. 16)
- 1.9 A History of Quality and Productivity (p. 18)
- 1.10 Themes of Quality Management (p. 21)
- 1.11 The Connection between Quality and Statistics (p. 26)
- Whitney Gourmet Cat Food Company Case (p. 28)
- Appendix 1.1 Basics of the Windows User Interface (p. 31)
- Appendix 1.2 Introduction to Microsoft Excel (p. 33)
- Appendix 1.3 Introduction to MINITAB (p. 41)
- Chapter 2 Tables and Charts (p. 44)
- 2.1 Introduction and the History of Graphics (p. 44)
- 2.2 Some Tools for Studying a Process: Process Flow Diagrams and Cause-and-Effect Diagrams (p. 45)
- 2.3 The Importance of the Time-Order Plot (p. 52)
- 2.4 Tables and Charts for Numerical Data (p. 56)
- 2.5 Checksheets and Summary Tables (p. 69)
- 2.6 Concentration Diagrams (p. 70)
- 2.7 Graphing Categorical Data (p. 72)
- 2.8 Tables and Charts for Bivariate Categorical Data (p. 78)
- 2.9 Graphical Excellence (p. 81)
- Whitney Gourmet Cat Food Company Case (p. 93)
- Appendix 2.1 Using Microsoft Excel for Tables and Charts (p. 96)
- Appendix 2.2 Using MINITAB for Tables and Charts (p. 101)
- Chapter 3 Describing and Summarizing Data (p. 103)
- 3.1 Introduction: What's Ahead (p. 103)
- 3.2 Measures of Central Tendency, Variation, and Shape (p. 104)
- 3.3 The Box-and-Whisker Plot (p. 123)
- Whitney Gourmet Cat Food Company Case (p. 133)
- Appendix 3.1 Using Microsoft Excel for Descriptive Statistics (p. 133)
- Appendix 3.2 Using MINITAB for Descriptive Statistics (p. 134)
- Chapter 4 Probability and Discrete Probability Distributions (p. 135)
- 4.1 Introduction (p. 135)
- 4.2 Some Rules of Probability (p. 138)
- 4.3 The Probability Distribution (p. 144)
- 4.4 The Binomial Distribution (p. 150)
- 4.5 The Hypergeometric Distribution (p. 158)
- 4.6 The Negative Binomial and Geometric Distributions (p. 162)
- 4.7 The Poisson Distribution (p. 167)
- 4.8 Summary and Overview (p. 172)
- Appendix 4.1 Using Microsoft Excel for Probability and Probability Distributions (p. 176)
- Appendix 4.2 Using MINITAB for Probability and Probability Distributions (p. 179)
- Chapter 5 Continuous Probability Distributions and Sampling Distributions (p. 180)
- 5.1 Introduction to Continuous Probability Distributions (p. 180)
- 5.2 The Uniform Distribution (p. 181)
- 5.3 The Normal Distribution (p. 184)
- 5.4 The Standard Normal Distribution As An Approximation to the Binomial and Poisson Distributions (p. 196)
- 5.5 The Normal Probability Plot (p. 199)
- 5.6 The Lognormal Distribution (p. 206)
- 5.7 The Exponential Distribution (p. 209)
- 5.8 The Weibull Distribution (p. 211)
- 5.9 Sampling Distribution of the Mean (p. 213)
- 5.10 Sampling Distribution of the Proportion (p. 218)
- 5.11 Summary (p. 220)
- Whitney Gourmet Cat Food Company Case (p. 224)
- Appendix 5.1 Using Microsoft Excel for Continuous Probability Distributions and Sampling Distributions (p. 225)
- Appendix 5.2 Using MINITAB for Continuous Probability Distributions and Sampling Distributions (p. 228)
- Chapter 6 Statistical Process Control Charts I: Basic Concepts and Attributes Charts (p. 230)
- 6.1 Introduction to Control Charts and Their Applications (p. 230)
- 6.2 Introduction to the Theory of Control Charts (p. 233)
- 6.3 Introduction to Attributes Control Charts (p. 239)
- 6.4 np and p charts (p. 240)
- 6.5 Area of Opportunity Charts (c Charts and u Charts) (p. 256)
- 6.6 Summary (p. 267)
- The Whitney Gourmet Cat Food Company Case (p. 279)
- The Mariphil Farms Dairy Case (p. 282)
- Appendix 6.1 Using Microsoft Excel for Attribute Control Charts (p. 284)
- Appendix 6.2 Using MINITAB for Attribute Control Charts (p. 285)
- Chapter 7 Statistical Process Control Charts II: Variables Control Charts (p. 287)
- 7.1 Introduction to Variables Control Charts (p. 287)
- 7.2 Rational Subgroups and Sampling Decisions (p. 288)
- 7.3 Control Charts for Central Tendency (X Charts) and Variation (R and s Charts) (p. 290)
- 7.4 Control Charts for Individual Values (X Charts) (p. 311)
- 7.5 Special Considerations with Variables Charts (p. 325)
- 7.6 The Cumulative Sum (CUSUM) and Exponentially Weighted Moving Average (EWMA) Charts (p. 326)
- 7.7 Process Capability (p. 332)
- 7.8 Summary (p. 339)
- The Whitney Gourmet Cat Food Company Case (p. 351)
- Harnswell Sewing Machine Company Case (p. 353)
- Antelope Pass Mining Company Case (p. 357)
- Appendix 7.1 Using Microsoft Excel for Variables Control Charts (p. 358)
- Appendix 7.2 Using MINITAB for Variables Control Charts (p. 363)
- Chapter 8 Estimation Procedures (p. 365)
- 8.1 Introduction (p. 365)
- 8.2 Properties of Estimators (p. 365)
- 8.3 Confidence Interval Estimation of the Mean (p. 367)
- 8.4 Confidence Interval Estimation for the Variance (p. 376)
- 8.5 Prediction Interval Estimate for a Future Individual Value (p. 379)
- 8.6 Tolerance Intervals (p. 381)
- 8.7 Confidence Interval Estimation for the Proportion (p. 384)
- 8.8 Summary (p. 386)
- Whitney Gourmet Cat Food Company Case (p. 388)
- Appendix 8.1 Using Microsoft Excel for Confidence Interval Estimation (p. 389)
- Appendix 8.2 Using MINITAB for Confidence Interval Estimation (p. 390)
- Chapter 9 Introduction to Hypothesis Testing (p. 392)
- 9.1 Introduction (p. 392)
- 9.2 Basic Concepts of Hypothesis-Testing (p. 393)
- 9.3 One-Sample Tests for the Mean (p. 398)
- 9.4 t Test for the Difference between the Means of Two Independent Groups (p. 413)
- 9.5 Testing for the Difference between Two Variances (p. 422)
- 9.6 The Repeated Measures or Paired t Test (p. 427)
- 9.7 Chi-Square Test for the Differences among Proportions in Two or More Groups (p. 433)
- 9.8 x[superscript 2] Test of Hypothesis for the Variance or Standard Deviation (Optional Topic) (p. 447)
- 9.9 Wilcoxon Rank Sum Test for the Difference between Two Medians (Optional Topic) (p. 450)
- 9.10 Summary (p. 457)
- Whitney Gourmet Cat Food Company Case (p. 461)
- Appendix 9.1 Using Microsoft Excel for Hypothesis Testing (p. 462)
- Appendix 9.2 Using MINITAB for Hypothesis Testing (p. 467)
- Chapter 10 The Design of Experiments: One Factor and Randomized Block Experiments (p. 469)
- 10.1 Introduction and Rationale (p. 469)
- 10.2 Historical Background (p. 470)
- 10.3 The Concept of Randomization (p. 471)
- 10.4 The One-Way Analysis of Variance (ANOVA) (p. 472)
- 10.5 The Randomized Block Model (p. 486)
- 10.6 Kruskal-Wallis Rank Test for Differences in c Medians (Optional Topic) (p. 497)
- Whitney Gourmet Cat Food Company Case (p. 508)
- Appendix 10.1 Using Microsoft Excel for the Analysis of Variance (p. 509)
- Appendix 10.2 Using MINITAB for the Analysis of Variance (p. 511)
- Chapter 11 The Design of Experiments: Factorial Designs (p. 513)
- 11.1 Two-Factor Factorial Designs (p. 513)
- 11.2 Factorial Designs Involving Three or More Factors (p. 525)
- 11.3 The Fractional Factorial Design (p. 541)
- 11.4 The Taguchi Approach (p. 550)
- 11.5 Summary and Overview (p. 557)
- Whitney Gourmet Cat Food Company Case (p. 563)
- Appendix 11.1 Using Microsoft Excel for the Two-Factor Factorial Design (p. 565)
- Appendix 11.2 Using MINITAB for Factorial Designs (p. 566)
- Chapter 12 Simple Linear Regression and Correlation (p. 567)
- 12.1 Introduction (p. 567)
- 12.2 Types of Regression Models (p. 568)
- 12.3 Determining the Simple Linear Regression Equation (p. 570)
- 12.4 Measures of Variation in Regression and Correlation (p. 577)
- 12.5 Assumptions of Regression and Correlation (p. 581)
- 12.6 Residual Analysis (p. 582)
- 12.7 Inferences About the Slope (p. 587)
- 12.8 Confidence and Prediction Interval Estimation (p. 591)
- 12.9 Pitfalls in Regression and Ethical Issues (p. 596)
- 12.10 Computations in Simple Linear Regression (p. 599)
- 12.11 Correlation--Measuring the Strength of the Association (p. 603)
- Whitney Gourmet Cat Food Company Case (p. 612)
- Appendix 12.1 Using Microsoft Excel for Simple Linear Regression and Correlation (p. 613)
- Appendix 12.2 Using MINITAB for Simple Linear Regression and Correlation (p. 615)
- Chapter 13 Multiple Regression (p. 616)
- 13.1 Developing the Multiple-Regression Model (p. 616)
- 13.2 Residual Analysis for the Multiple-Regression Model (p. 624)
- 13.3 Testing for the Significance of the Multiple-Regression Model (p. 626)
- 13.4 Inferences Concerning the Population Regression Coefficients (p. 628)
- 13.5 Testing Portions of the Multiple-Regression Model (p. 631)
- 13.6 The Quadratic Curvilinear Regression Model (p. 638)
- 13.7 Dummy-Variable Models (p. 646)
- 13.8 Using Transformations in Regression Models (p. 651)
- 13.9 Collinearity (p. 654)
- 13.10 Model-Building (p. 655)
- 13.11 Pitfalls in Multiple Regression (p. 664)
- Appendix 13.1 Using Microsoft Excel for Multiple-Regression Models (p. 668)
- Appendix 13.2 Using MINITAB for Multiple Models Regression (p. 670)
- Appendices
- A. Tables (p. 1)
- A.1 Table of Random Numbers (p. 2)
- A.2 The Standard Normal Distribution (p. 4)
- A.3 Control Chart Factors (p. 5)
- A.4 Critical Values of t (p. 6)
- A.5a K[subscript 2] Factors for Normal Distributions (p. 8)
- A.5b K[subscript 1] Factors for One-Sided Tolerance Intervals for Normal Distributions (p. 9)
- A.6 Critical Values of x[superscript 2] (p. 10)
- A.7 Critical Values of F (p. 11)
- A.8 Lower and Upper Critical Values T[subscript 1] of Wilcoxon Rank Sum Test (p. 15)
- A.9 Critical Values of the Studentized Range Q
- B. Statistical Forms (p. 1)
- B.1 Normal Probability Paper (p. 1)
- B.2 Sample form for Data Collection and Construction of Attribute Control Charts (p. 2)
- C. Documentation for the Data Files (p. 1)
- D. Installing the PHStat Microsoft Excel Add-In (p. 1)
- E. Answers to Selected Odd Problems (p. 1)
- Index (p. 1)