Statistics for Managers Using Microsoft Excel / Edition 7

Statistics for Managers Using Microsoft Excel / Edition 7

by David M. Levine, David F. Stephan, Kathryn A. Szabat, Mark L Berenson
     
 

View All Available Formats & Editions

ISBN-10: 0133061817

ISBN-13: 9780133061819

Pub. Date: 01/25/2013

Publisher: Pearson

Thoroughly integrating the use of Microsoft Excel, this streamlined volume on business statistics uses an applied approach that focuses on the concepts and applications of statistics to the functional areas of business. Revised to increase the emphasis on concepts and applications and to more seamlessly integrate coverage on Microsoft Excel, it offers detailed,

Overview

Thoroughly integrating the use of Microsoft Excel, this streamlined volume on business statistics uses an applied approach that focuses on the concepts and applications of statistics to the functional areas of business. Revised to increase the emphasis on concepts and applications and to more seamlessly integrate coverage on Microsoft Excel, it offers detailed, step-by-step explanations on the use of Microsoft Excel to perform statistical analysis on every topic covered in the book and integrates numerous illustrations of Excel output and dialog boxes. Concepts and methods covered include data collection and presentation, numerical descriptive measures, probability distributions, interval estimation, hypothesis testing, variance, linear regression and statistical applications in quality and productivity management. For managers in accounting, marketing, management, and economics and finance.

Product Details

ISBN-13:
9780133061819
Publisher:
Pearson
Publication date:
01/25/2013
Edition description:
Older Edition
Pages:
792
Sales rank:
263,219
Product dimensions:
8.70(w) x 10.90(h) x 1.20(d)

Table of Contents

Prefacexiii
1Introduction and Data Collection1
1.1Why a Manager Needs to Know About Statistics2
1.2The Growth and Development of Modern Statistics4
1.3What Every Manager Needs to Know About Using Electronic Worksheets4
1.4What You Need to Know About Using the Software for This Textbook5
1.5Why Are Data Needed6
1.6Sources of Data7
1.7Types of Data9
1.8Types of Sampling Methods11
1.9Evaluating Survey Worthiness17
Excel Primer27
EP.1Working with Windows and Microsoft Excel28
EP.2Common Workbook Operations32
EP.3Basic Worksheet Concepts and Operations36
EP.4Enhancing Worksheet Appearance39
EP.5Using Microsoft Excel Wizards40
EP.6Using Add-Ins43
2Presenting Data in Tables and Charts45
2.1Organizing Numerical Data46
2.2Tables and Charts for Numerical Data51
2.3Graphing Bivariate Numerical Data62
2.4Tables and Charts for Categorical Data65
2.5Tabulating and Graphing Bivariate Categorical Data73
2.6Graphical Excellence79
3Numerical Descriptive Measures107
3.1Exploring Numerical Data and Their Properties108
3.2Measures of Central Tendency, Variation, and Shape109
3.3Exploratory Data Analysis129
3.4Obtaining Descriptive Summary Measures from a Population134
3.5The Coefficient of Correlation138
3.6Pitfalls in Numerical Descriptive Measures and Ethical Issues143
4Basic Probability and Discrete Probability Distribution159
4.1Basic Probability Concepts161
4.2Conditional Probability170
4.3Bayes' Theorem178
4.4The Probability Distribution for a Discrete Random Variable182
4.5Covariance and Its Application in Finance186
4.6Binomial Distribution191
4.7Poisson Distribution200
4.8Hypergeometric Distribution204
4.9Ethical Issues and Probability207
5The Normal Distribution and Sampling Distributions223
5.1The Normal Distribution224
5.2Evaluating the Normality Assumption242
5.3The Exponential Distribution250
5.4Introduction to Sampling Distributions253
5.5Sampling Distribution of the Mean253
5.6Sampling Distribution of the Proportion266
5.7Sampling from Finite Populations (CD-ROM Topic)270
6Confidence Interval Estimation283
6.1Confidence Interval Estimation of the Mean ([sigma] Known)285
6.2Confidence Interval Estimation of the Mean ([sigma] Unknown)290
6.3Confidence Interval Estimation for the Proportion297
6.4Determining Sample Size301
6.5Applications of Confidence Interval Estimation in Auditing309
6.6Confidence Interval Estimation and Ethical Issues317
6.7Estimation and Sample Size Determination for Finite Populations (CD-ROM Topic)319
7Fundamentals of Hypothesis Testing: One-Sample Tests333
7.1Hypothesis-Testing Methodology334
7.2Z Test of Hypothesis for the Mean ([sigma] Known)339
7.3One-Tail Tests347
7.4tTest of Hypothesis for the Mean ([sigma] Unknown)350
7.5Z Test of Hypothesis for the Proportion357
7.6Potential Hypothesis-Testing Pitfalls and Ethical Issues361
8Two-Sample Tests with Numerical Data373
8.1Comparing Two Independent Samples: t Tests for Differences Between Two Means374
8.2F Test for Differences Between Two Variances385
8.3Comparing Two Related Samples: t Test for the Mean Difference394
8.4Wilcoxon Rank Sum Test for Differences Between Two Medians402
9Analysis of Variance421
9.1The Completely Randomized Design: One-Way Analysis of Variance422
9.2The Two-Factor Factorial Design: Two-Way Analysis of Variance437
9.3The Kruskal-Wallis Rank Test for Differences Between Medians450
10Tests for Two or More Samples with Categorical Data469
10.1Z Test for the Difference Between Two Proportions470
10.2x[superscript 2] Test for the Difference Between Two Proportions477
10.3x[superscript 2] Test for Differences Between More Than Two Proportions485
10.4x[superscript 2] Test of Independence492
11Simple Linear Regression511
11.1Types of Regression Models512
11.2Determining the Simple Linear Regression Equation514
11.3Measures of Variation524
11.4Assumptions529
11.5Residual Analysis530
11.6Measuring Autocorrelation: The Durbin-Watson Statistic535
11.7Inferences About the Slope and Correlation Coefficient541
11.8Estimation of Mean and Prediction of Individual Values547
11.9Pitfalls in Regression and Ethical Issues552
11.10Computations in Simple Linear Regression556
12Multiple Regression581
12.1Developing the Multiple Regression Model582
12.2Residual Analysis for the Multiple Regression Model591
12.3Testing for the Significance of the Multiple Regression Model594
12.4Inferences Concerning the Population Regression Coefficients596
12.5Testing Portions of the Multiple Regression Model600
12.6The Quadratic Regression Model606
12.7Dummy Variable Models615
12.8Using Transformations in Regression Models624
12.9Collinearity628
12.10Model Building630
12.11Pitfalls in Multiple Regression and Ethical Issues641
13Time-Series Analysis653
13.1The Importance of Business Forecasting654
13.2Component Factors of the Classical Multiplicative Time-Series Model655
13.3Smoothing the Annual Time Series657
13.4Least-Squares Trend Fitting and Forecasting668
13.5Autoregressive Modeling for Trend Fitting and Forecasting684
13.6Choosing an Appropriate Forecasting Model694
13.7Time-Series Forecasting of Monthly or Quarterly Data700
13.8Pitfalls Concerning Time-Series Analysis708
13.9Index Numbers (CD-ROM Topic)709
14Decision Making719
14.1The Payoff Table and Decision Trees720
14.2Criteria for Decision Making725
14.3Decision Making with Sample Information734
14.4Utility739
15Statistical Applications in Quality and Productivity Management749
15.1Quality and Productivity: A Historical Perspective751
15.2Deming's 14 Points: A Theory of Management751
15.3The Theory of Control Charts754
15.4Control Charts for the Proportion of Nonconforming Items: p Charts756
15.5The Red Bead Experiment: Understanding Process Variability762
15.6Control Charts for the Range and the Mean765
15.7Process Capability772
Answers to Selected Problems792
Appendices805
A.Review of Arithmetic, Algebra, and Logarithms805
B.Summation Notation809
C.Statistical Symbols and the Greek Alphabet815
D.CD-ROM Contents817
E.Tables831
F.Microsoft Excel Configuration and Customization863
G.More About PHStat2869
Index873
CD-ROM Topics
5.7Sampling from Finite Populations1
6.7Estimation and Sample Size Determination for Finite Populations1
13.9Index Numbers1

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >