Essentials of Modern Business Statistics With Microsoft Excel

Name: Essentials of Modern Business Statistics With Microsoft Excel
Price: 18.38 USD
Availability: InStock
ISBN: 9780324312843

ISBN-10: 0324312849

ISBN-13: 9780324312843

Edition: 3rd 2007

Authors: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams

List price: $346.95

30 day, 100% satisfaction guarantee!

Marketplace

4 new & used from $18.38

what's this?

Rush Rewards U
Members Receive:

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

Description:

From the renowned author team that has been writing market-leading business statistics textbooks for more than 20 years, ESSENTIALS OF MODERN BUSINESS STATISTICS, 3e provides a brief introduction to business statistics that balances a conceptual understanding of statistics with the real-world application of statistical methodology. The latest version of Microsoft Excel is integrated throughout the text, showing step-by-step instructions and screen captures to enhance student learning. The Third Edition contains the same student learning features that have made ASW products best-sellers for years; features include the problem-scenario approach and real-world examples that introduce…

Book details

List price: $346.95
Edition: 3rd
Copyright year: 2007
Publisher: Cengage South-Western
Publication date: 4/7/2006
Binding: Hardcover
Pages: 728
Size: 8.00" wide x 10.25" long x 1.00" tall
Weight: 3.498
Language: English

Stephen Stoker of Weber State University in Ogden, UT, has taught the gamut of introductory chemistry courses, specializing in GOB, for the past 30 years. Weber State has a very large Health Professions school, and GOB is geared at students with little or no experience in chemistry (notably Allied Health and Nursing majors).Dr. David R. Anderson is a textbook author and Professor Emeritus of Quantitative Analysis in the College of Business Administration at the University of Cincinnati. He has served as head of the Department of Quantitative Analysis and Operations Management and as Associate Dean of the College of Business Administration. He was also coordinator of the College's first…

Dr. Dennis J. Sweeney is a textbook author, Professor Emeritus of Quantitative Analysis and founder of the Center for Productivity Improvement at the University of Cincinnati. He also served five years as head of the Department of Quantitative Analysis and four years as Associate Dean of the College of Business Administration. In addition, he has worked in the management science group at Procter & Gamble and has been a visiting professor at Duke University. Professor Sweeney has published more than 30 articles in the area of management science and statistics. The National Science Foundation, IBM, Procter & Gamble, Federated Department Stores, Kroger, and Cincinnati Gas & Electric have…



Preface


About the Authors



Data and Statistics


Statistics in Practice: Business Week



Applications in Business and Economics


Accounting


Finance


Marketing


Production


Economics



Data


Elements, Variables, and Observations


Scales of Measurement


Qualitative and Quantitative Data


Cross-Sectional and Time Series Data



Data Sources


Existing Sources


Statistical Studies


Data Acquisition Errors



Descriptive Statistics



Statistical Inference



Statistical Analysis Using Microsoft Excel


Data Sets and Excel Worksheets


Using Excel for Statistical Analysis


Summary


Glossary


Supplementary Exercises



An Introduction to SWStat+



Descriptive Statistics: Tabular and Graphical Presentations


Statistics in Practice: Colgate-Palmolive Company



Summarizing Qualitative Data


Frequency Distribution


Using Excel's COUNTIF Function to Construct a Frequency Distribution


Relative Frequency and Percent Frequency Distributions


Using Excel to Construct Relative Frequency and Percent Frequency Distributions


Bar Graphs and Pie Charts


Using Excel's Chart Wizard to Construct Bar Graphs and Pie Charts



Summarizing Quantitative Data


Frequency Distribution


Using Excel's FREQUENCY Function to Construct a Frequency Distribution


Relative Frequency and Percent Frequency Distributions


Histogram


Using Excel's Chart Wizard to Construct a Histogram


Cumulative Distributions


Using Excel's Histogram Tool to Construct a Frequency Distribution and Histogram



Exploratory Data Analysis: The Stem-and-Leaf Display



Crosstabulations and Scatter Diagrams


Crosstabulation


Using Excel's PivotTable Report to Construct a Crosstabulation


Simpson's Paradox


Scatter Diagram and Trendline


Using Excel's Chart Wizard to Construct a Scatter Diagram and a Trendline


Summary


Glossary


Key Formulas


Supplementary Exercises


Case Problem Pelican Stores



Descriptive Statistics: Numerical Measures


Statistics in Practice: Small Fry Design



Measures of Location


Mean


Median


Mode


Using Excel to Compute the Mean, Median, and Mode


Percentiles


Quartiles


Using Excel's Rank and Percentile Tool to Compute Percentiles and Quartiles



Measures of Variability


Range


Interquartile Range


Variance


Standard Deviation


Using Excel to Compute the Sample Variance and Sample Standard Deviation


Coefficient of Variation


Using Excel's Descriptive Statistics Tool



Measures of Distribution Shape, Relative Location, and Detecting Outliers


Distribution Shape


z-Scores


Chebyshev's Theorem


Empirical Rule


Detecting Outliers



Exploratory Data Analysis


Five-Number Summary


Box Plot



Measures of Association Between Two Variables


Covariance


Interpretation of the Covariance


Correlation Coefficient


Interpretation of the Correlation Coefficient


Using Excel to Compute the Covariance and Correlation Coefficient



The Weighted Mean and Working with Grouped Data


Weighted Mean


Grouped Data


Summary


Glossary


Key Formulas


Supplementary Exercises



Pelican Stores



National Health Care Association



Business Schools of Asia-Pacific



Constructing a Box Plot Using SWStat+



Introduction to Probability


Statistics in Practice: Morton International



Experiments, Counting Rules, and Assigning Probabilities


Counting Rules, Combinations, and Permutations


Assigning Probabilities


Probabilities for the KP&L Project



Events and Their Probabilities



Some Basic Relationships of Probability


Complement of an Event


Addition Law



Conditional Probability


Independent Events


Multiplication Law



Bayes' Theorem


Tabular Approach


Using Excel to Compute Posterior Probabilities


Summary


Glossary


Key Formulas


Supplementary Exercises


Case Problem Hamilton County Judges



Discrete Probability Distributions


Statistics in Practice: Citibank



Random Variables


Discrete Random Variables


Continuous Random Variables



Discrete Probability Distributions



Expected Value and Variance


Expected Value


Variance


Using Excel to Compute the Expected Value, Variance, and Standard Deviation



Binomial Probability Distribution


A Binomial Experiment


Martin Clothing Store Problem


Using Excel to Compute Binomial Probabilities


Expected Value and Variance for the Binomial Probability Distribution



Poisson Probability Distribution


An Example Involving Time Intervals


An Example Involving Length or Distance Intervals


Using Excel to Compute Poisson Probabilities



Hypergeometric Probability Distribution


Using Excel to Compute Hypergeometric Probabilities


Summary


Glossary


Key Formulas


Supplementary Exercises



Continuous Probability Distributions


Statistics in Practice: Procter & Gamble



Uniform Probability Distribution


Area as a Measure of Probability



Normal Probability Distribution


Normal Curve


Standard Normal Probability Distrbution


Computing Probabilities for Any Normal Probability Distribution


Grear Tire Company Problem


Using Excel to Compute Normal Probabilities



Exponential Probability Distribution


Computing Probabilities for the Exponential Distribution


Relationship Between the Poisson and Exponential Distributions


Using Excel to Compute Exponential Probabilities


Summary


Glossary


Key Formulas


Supplementary Exercises


Case Problem Specialty Toys



Sampling and Sampling Distributions


Statistics in Practice: MeadWestvaco Corporation



The Electronics Associates Sampling Problem



Simple Random Sampling


Sampling from a Finite Population


Sampling from an Infinite Population



Point Estimation



Introduction to Sampling Distributions



Sampling Distribution of x


Expected Value of x


Standard Deviation of x


Form of the Sampling Distribution of x


Sampling Distribution of x for the EAI Problem


Practical Value of the Sampling Distribution of x


Relationship Between Sample Size and the Sampling Distribution of x



Sampling Distribution of p


Expected Value of p


Standard Deviation of p


Form of the Sampling Distribution of p


Practical Value of the Sampling Distribution of p



Sampling Methods


Stratified Random Sampling


Cluster Sampling


Systematic Sampling


Convenience Sampling


Judgment Sampling


Summary


Glossary


Key Formulas


Supplementary Exercises



Interval Estimation


Statistics in Practice: Food Lion



Population Mean: [sigma] Known


Margin of Error and the Interval Estimate


Using Excel


Practical Advice



Population Mean: [sigma] Unknown


Margin of Error and the Interval Estimate


Using Excel


Practical Advice


Using a Small Sample


Summary of Interval Estimation Procedures



Determining the Sample Size



Population Proportion


Using Excel


Determining the Sample Size


Summary


Glossary


Key Formulas


Supplementary Exercises



Bock Investment Services



Gulf Real Estate Properties



Metropolitan Research, Inc.



Hypothesis Tests


Statistics in Practice: John Morrell & Company



Developing Null and Alternative Hypotheses


Testing Research Hypotheses


Testing the Validity of a Claim


Testing in Decision-Making Situations


Summary of Forms for Null and Alternative Hypotheses



Type I and Type II Errors



Population Mean: [sigma] Known


One-Tailed Test


Two-Tailed Test


Using Excel


Summary and Practical Advice


Relationship Between Interval Estimation and Hypothesis Testing



Population Mean: [sigma] Unknown


One-Tailed Test


Two-Tailed Test


Using Excel


Summary and Practical Advice



Population Proportion


Using Excel


Summary


Summary


Glossary


Key Formulas


Supplementary Exercises



Quality Associates, Inc.



Unemployment Study



Comparisons Involving Means


Statistics in Practice: Fisons Corporation



Inferences About the Difference Between Two Population Means: [sigma subscript 1] and [sigma subscript 2] Known


Interval Estimation of [mu subscript 1] - [mu subscript 2]


Using Excel to Construct a Confidence Interval


Hypothesis Tests About [mu subscript 1] - [mu subscript 2]


Using Excel to Conduct a Hypothesis Test


Practical Advice



Inferences About the Difference Between Two Population Means: [sigma subscript 1] and [sigma subscript 2] Unknown


Interval Estimation of [mu subscript 1] - [mu subscript 2]


Using Excel to Construct a Confidence Interval


Hypothesis Tests About [mu subscript 1] - [mu subscript 2]


Using Excel to Conduct a Hypothesis Test


Practical Advice



Inferences About the Difference Between Two Population Means: Matched Samples


Using Excel to Conduct a Hypothesis Test



Introduction to Analysis of Variance


Assumptions for Analysis of Variance


Conceptual Overview



Analysis of Variance: Testing for the Equality of k Population Means


Between-Treatments Estimate of Population Variance


Within-Treatments Estimate of Population Variance


Comparing the Variance Estimates: The F Test


ANOVA Table


Using Excel


Summary


Glossary


Key Formulas


Supplementary Exercises



Par, Inc.



Wentworth Medical Center



Compensation for ID Professionals



Comparisons Involving Proportions and a Test of Independence


Statistics in Practice: United Way



Inferences About the Difference Between Two Population Proportions


Interval Estimation of p[subscript 1] - p[subscript 2]


Using Excel to Construct a Confidence Interval


Hypothesis Tests About p[subscript 1] - p[subscript 2]


Using Excel to Conduct a Hypothesis Test



Hypothesis Test for Proportions of a Multinomial Population


Using Excel to Conduct a Goodness of Fit Test



Test of Independence


Using Excel to Conduct a Test of Independence


Summary


Glossary


Key Formulas


Supplementary Exercises


Case Problem A Bipartisan Agenda for Change



Simple Linear Regression


Statistics in Practice: Alliance Data Systems



Simple Linear Regression Model


Regression Model and Regression Equation


Estimated Regression Equation



Least Squares Method


Using Excel to Develop a Scatter Diagram and Compute the Estimated Regression Equation



Coefficient of Determination


Using Excel to Compute the Coefficient of Determination


Correlation Coefficient



Model Assumptions



Testing for Significance


Estimate of [sigma superscript 2]


t Test


Confidence Interval for [beta subscript 1]


F Test


Some Cautions About the Interpretation of Significance Tests



Excel's Regression Tool


Using Excel's Regression Tool for the Armand's Pizza Parlors Problem


Interpretation of Estimated Regression Equation Output


Interpretation of ANOVA Output


Interpretation of Regression Statistics Output



Using the Estimated Regression Equation for Estimation and Prediction


Point Estimation


Interval Estimation


Confidence Interval Estimate of the Mean Value of y


Prediction Interval Estimate of an Individual Value of y


Using Excel to Develop Confidence and Prediction Interval Estimates



Residual Analysis: Validating Model Assumptions


Residual Plot Against x


Residual Plot Against y


Using Excel's Regression Tool to Construct a Residual Plot


Summary


Glossary


Key Formulas


Supplementary Exercises



Spending and Student Achievement



U.S. Department of Transportation



Alumni Giving



Major League Baseball Teams Values



Regression Analysis with SWStat+



Multiple Regression


Statistics in Practice: International Paper



Multiple Regression Model


Regression Model and Regression Equation


Estimated Multiple Regression Equation



Least Squares Method


An Example: Butler Trucking Company


Using Excel's Regression Tool to Develop the Estimated Multiple Regression Equation


Note on Interpretation of Coefficients



Multiple Coefficient of Determination



Model Assumptions



Testing for Significance


F Test


t Test


Multicollinearity



Using the Estimated Regression Equation for Estimation and Prediction



Qualitative Independent Variables


An Example: Johnson Filtration, Inc.


Interpreting the Parameters


More Complex Qualitative Variables


Summary


Glossary


Key Formulas


Supplementary Exercises



Consumer Research, Inc.



Predicting Student Proficiency Test Scores



Alumni Giving



Multiple Regression Analysis with SWStat+



Statistical Methods for Quality Control


Statistics in Practice: Dow Chemical



Philosophies and Frameworks


Malcolm Baldrige National Quality Award


ISO 9000


Six Sigma



Statistical Process Control


Control Charts


x Chart: Process Mean and Standard Deviation Known


x Chart: Process Mean and Standard Deviation Unknown


R Chart


Using Excel to Construct an R Chart and an x Chart


p Chart


np Chart


Interpretation of Control Charts



Acceptance Sampling


KALI, Inc.: An Example of Acceptance Sampling


Computing the Probability of Accepting a Lot


Selecting an Acceptance Sampling Plan


Multiple Sampling Plans


Summary


Glossary


Key Formulas


Supplementary Exercises



References and Bibliography



Tables



Summation Notation



Self-Test Solutions and Answers to Even-Numbered Exercises



Using Excel Functions


Index