Applied Statistics for Engineers and Scientists Using Microsoft Excel and Minitab

Name: Applied Statistics for Engineers and Scientists Using Microsoft Excel and Minitab
Price: 13.38 USD
Availability: InStock
ISBN: 9780134888019

ISBN-10: 0134888014

ISBN-13: 9780134888019

Edition: 2001

Authors: David Levine, Patricia Ramsey, Robert Smidt

List price: $146.65

30 day, 100% satisfaction guarantee!

Sell

Get cash fast!

Marketplace

4 new & used from $13.38

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

For courses in Probability and Statistics. This applied text for engineers and scientists, written in a non-theoretical manner, focuses on underlying principles that are important to students 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 (Microsoft Excel and Minitab) as well as in-depth coverage of quality and experimental design complete this treatment of statistics.

Book details

List price: $146.65
Copyright year: 2001
Publisher: Pearson Education
Publication date: 9/8/2000
Binding: Paperback
Pages: 736
Size: 8.00" wide x 9.90" long x 1.70" tall
Weight: 3.586
Language: English



Preface



Introduction to Statistics and Quality Improvement



What Is Statistics?



Why Study Statistics?



Statistical Thinking: Understanding and Managing Variability



Variables, Types of Data, and Levels of Measurement



Operational Definitions



Sampling



Statistical and Spreadsheet Software



Introduction to Quality



A History of Quality and Productivity



Themes of Quality Management



The Connection between Quality and Statistics


Whitney Gourmet Cat Food Company Case



Basics of the Windows User Interface



Introduction to Microsoft Excel



Introduction to MINITAB



Tables and Charts



Introduction and the History of Graphics



Some Tools for Studying a Process: Process Flow Diagrams and Cause-and-Effect Diagrams



The Importance of the Time-Order Plot



Tables and Charts for Numerical Data



Checksheets and Summary Tables



Concentration Diagrams



Graphing Categorical Data



Tables and Charts for Bivariate Categorical Data



Graphical Excellence


Whitney Gourmet Cat Food Company Case



Using Microsoft Excel for Tables and Charts



Using MINITAB for Tables and Charts



Describing and Summarizing Data



Introduction: What's Ahead



Measures of Central Tendency, Variation, and Shape



The Box-and-Whisker Plot


Whitney Gourmet Cat Food Company Case



Using Microsoft Excel for Descriptive Statistics



Using MINITAB for Descriptive Statistics



Probability and Discrete Probability Distributions



Introduction



Some Rules of Probability



The Probability Distribution



The Binomial Distribution



The Hypergeometric Distribution



The Negative Binomial and Geometric Distributions



The Poisson Distribution



Summary and Overview



Using Microsoft Excel for Probability and Probability Distributions



Using MINITAB for Probability and Probability Distributions



Continuous Probability Distributions and Sampling Distributions



Introduction to Continuous Probability Distributions



The Uniform Distribution



The Normal Distribution



The Standard Normal Distribution As An Approximation to the Binomial and Poisson Distributions



The Normal Probability Plot



The Lognormal Distribution



The Exponential Distribution



The Weibull Distribution



Sampling Distribution of the Mean



Sampling Distribution of the Proportion



Summary


Whitney Gourmet Cat Food Company Case



Using Microsoft Excel for Continuous Probability Distributions and Sampling Distributions



Using MINITAB for Continuous Probability Distributions and Sampling Distributions



Statistical Process Control Charts I: Basic Concepts and Attributes Charts



Introduction to Control Charts and Their Applications



Introduction to the Theory of Control Charts



Introduction to Attributes Control Charts



np and p charts



Area of Opportunity Charts (c Charts and u Charts)



Summary


The Whitney Gourmet Cat Food Company Case


The Mariphil Farms Dairy Case



Using Microsoft Excel for Attribute Control Charts



Using MINITAB for Attribute Control Charts



Statistical Process Control Charts II: Variables Control Charts



Introduction to Variables Control Charts



Rational Subgroups and Sampling Decisions



Control Charts for Central Tendency (X Charts) and Variation (R and s Charts)



Control Charts for Individual Values (X Charts)



Special Considerations with Variables Charts



The Cumulative Sum (CUSUM) and Exponentially Weighted Moving Average (EWMA) Charts



Process Capability



Summary


The Whitney Gourmet Cat Food Company Case


Harnswell Sewing Machine Company Case


Antelope Pass Mining Company Case



Using Microsoft Excel for Variables Control Charts



Using MINITAB for Variables Control Charts



Estimation Procedures



Introduction



Properties of Estimators



Confidence Interval Estimation of the Mean



Confidence Interval Estimation for the Variance



Prediction Interval Estimate for a Future Individual Value



Tolerance Intervals



Confidence Interval Estimation for the Proportion



Summary


Whitney Gourmet Cat Food Company Case



Using Microsoft Excel for Confidence Interval Estimation



Using MINITAB for Confidence Interval Estimation



Introduction to Hypothesis Testing



Introduction



Basic Concepts of Hypothesis-Testing



One-Sample Tests for the Mean



t Test for the Difference between the Means of Two Independent Groups



Testing for the Difference between Two Variances



The Repeated Measures or Paired t Test



Chi-Square Test for the Differences among Proportions in Two or More Groups



x[superscript 2] Test of Hypothesis for the Variance or Standard Deviation (Optional Topic)



Wilcoxon Rank Sum Test for the Difference between Two Medians (Optional Topic)



Summary


Whitney Gourmet Cat Food Company Case



Using Microsoft Excel for Hypothesis Testing



Using MINITAB for Hypothesis Testing



The Design of Experiments: One Factor and Randomized Block Experiments



Introduction and Rationale



Historical Background



The Concept of Randomization



The One-Way Analysis of Variance (ANOVA)



The Randomized Block Model



Kruskal-Wallis Rank Test for Differences in c Medians (Optional Topic)


Whitney Gourmet Cat Food Company Case



Using Microsoft Excel for the Analysis of Variance



Using MINITAB for the Analysis of Variance



The Design of Experiments: Factorial Designs



Two-Factor Factorial Designs



Factorial Designs Involving Three or More Factors



The Fractional Factorial Design



The Taguchi Approach



Summary and Overview


Whitney Gourmet Cat Food Company Case



Using Microsoft Excel for the Two-Factor Factorial Design



Using MINITAB for Factorial Designs



Simple Linear Regression and Correlation



Introduction



Types of Regression Models



Determining the Simple Linear Regression Equation



Measures of Variation in Regression and Correlation



Assumptions of Regression and Correlation



Residual Analysis



Inferences About the Slope



Confidence and Prediction Interval Estimation



Pitfalls in Regression and Ethical Issues



Computations in Simple Linear Regression



Correlation--Measuring the Strength of the Association


Whitney Gourmet Cat Food Company Case



Using Microsoft Excel for Simple Linear Regression and Correlation



Using MINITAB for Simple Linear Regression and Correlation



Multiple Regression



Developing the Multiple-Regression Model



Residual Analysis for the Multiple-Regression Model



Testing for the Significance of the Multiple-Regression Model



Inferences Concerning the Population Regression Coefficients



Testing Portions of the Multiple-Regression Model



The Quadratic Curvilinear Regression Model



Dummy-Variable Models



Using Transformations in Regression Models



Collinearity



Model-Building



Pitfalls in Multiple Regression



Using Microsoft Excel for Multiple-Regression Models



Using MINITAB for Multiple Models Regression


Appendices



Tables



Table of Random Numbers



The Standard Normal Distribution



Control Chart Factors



Critical Values of t



K[subscript 2] Factors for Normal Distributions



K[subscript 1] Factors for One-Sided Tolerance Intervals for Normal Distributions



Critical Values of x[superscript 2]



Critical Values of F



Lower and Upper Critical Values T[subscript 1] of Wilcoxon Rank Sum Test



Critical Values of the Studentized Range Q



Statistical Forms



Normal Probability Paper



Sample form for Data Collection and Construction of Attribute Control Charts



Documentation for the Data Files



Installing the PHStat Microsoft Excel Add-In



Answers to Selected Odd Problems


Index