Amazon no longer offers textbook rentals. We do!

Practical Statistics by Example Using Microsoft Excel

by: Sincich, Terry; Levine, Davidm; Stephan, David

Practical Statistics by Example Using Microsoft Excel

by: Sincich, Terry; Levine, Davidm; Stephan, David

ISBN 13:
9780130960832
ISBN 10:
0130960837
Edition: CD
Format: Hardcover
Copyright: 02/01/1999
Publisher: Pearson College Div
Newer Edition

Rent

Sorry, this item is currently unavailable.

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Extend or Purchase Your Rental at Any Time

Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.

Summary

A practical introduction to statistics that fully incorporates Microsoft Excel as the computational tool for data analysis. Concepts are introduced through real-data based examples with fully worked out solutions. Problems in the exercise sets are graded in level from "Using the Tools" to "Applying the Concepts." Self-test questions appear immediately after important ideas have been introduced to test the student's comprehension of the concepts and to help develop good study habits. Full instruction on using Microsoft Excel is incorporated into the text by means of: a primer on using Windows and Microsoft Excel for the novice, Excel Tutorials with step-by-step instructions and multiple screen shots at the end of each chapter, exercises keyed to data sets contained in Excel Workbooks, and the Prentice Hall Excel add-in disk (packaged free with each copy of the book) that extends the capacity of off-the-shelf Excel and presents many more statistical techniques and procedures through a few simple menus.

Preface

Microsoft Excel Primer

(1)

Overview

(1)

Getting Started with the User Interface

(6)

Getting Familiar with Mouse Operations

(3)

Getting Familiar with the Microsoft Excel Application Window

(1)

Getting Familiar with Menu Conventions and Dialog Boxes

(2)

Getting Started with Microsoft Excel

(14)

Configuring Microsoft Excel

(2)

Specifying Worksheet Locations

(1)

Using Formulas to Perform Calculations

(1)

Entering Data into Worksheets

(1)

Copying Cell Entries and Worksheets

(1)

Opening Workbooks

(1)

Printing Worksheets

(4)

Saving Workbooks

(1)

Enhancing the Appearance of a Worksheet

(2)

Getting Context-Sensitive Help in Microsoft Excel

(2)

Getting Started with Microsoft Excel Wizards and Add-Ins

(6)

Wizards

(2)

Using Add-Ins

(3)

Summary

(1)

Introduction: Statistics and Data

(34)

Real-World Application Obedience to Authority---The Shocking Truth

(28)

What Is Statistics?

(1)

Types of Data

(5)

Descriptive vs. Inferential Statistics

(7)

Collecting Data

(3)

Random Sampling

(4)

Other Types of Samples (Optional)

(2)

Ethical and Other Issues in Statistical Applications

(5)

Real-World Revisited

(5)

Using Microsoft Excel

(1)

Using Microsoft Excel to Select a Random Sample

(1)

Exploring Data with Graphs and Tables

(83)

Real-World Application A Bad Moon Rising

(50)

The Objective of Data Description

(1)

Describing a Single Qualitative Variable: Frequency Tables, Bar Graphs, and Pie Charts

(10)

Describing a Single Quantitative Variable: Frequency Tables, Stem-and-Leaf Displays, and Histograms

(13)

Exploring the Relationship between Two Qualitative Variables: Cross-Classification Tables and Side-by-Side Bar Graphs

(10)

Exploring the Relationship between Two Quantitative Variables: Scatterplots

(9)

Proper Graphical Presentation

104

(7)

Real-World Revisited

111

(14)

Using Microsoft Excel

125

(19)

Using Microsoft Excel to Describe a Single Qualitative Variable

125

(1)

Using Microsoft Excel to Describe a Single Quantitative Variable

126

(8)

Using Microsoft Excel to Explore the Relationship between Two Qualitative Variables

134

(7)

Using Microsoft Excel to Explore the Relationship between Two Quantitative Variables

141

(3)

Exploring Data with Numerical Descriptive Measures

144

(68)

Real-World Application Bid-Collusion in the Highway Contracting Industry

144

(54)

Types of Numerical Descriptive Measures

145

(1)

Summation Notation

146

(2)

Measures of Central Tendency: Mean, Median, and Mode

148

(9)

Measures of Data Variation: Range, Variance, and Standard Deviation

157

(2)

Interpreting the Standard Deviation

159

(14)

Measures of Relative Standing: Percentiles and z Scores

173

(7)

Box-and-Whisker Plots

180

(4)

Methods for Detecting Outliers

184

(6)

A Measure of Association: Correlation

190

(8)

Numerical Descriptive Measures for Populations

198

(1)

Real-World Revisited

198

(11)

Using Microsoft Excel

209

(3)

Using Microsoft Excel to Explore Data with Numerical Descriptive Measures

209

(3)

Probability: Basic Concepts

212

(48)

Real-World Application Lottery Buster!

212

(38)

The Role of Probability in Statistics

213

(1)

Experiments, Events, and the Probability of an Event

213

(5)

Probability Rules for Mutually Exclusive Events

218

(12)

The Combinatorial Rule for Counting Simple Events (Optional)

230

(3)

Conditional Probability and Independence

233

(8)

The Additive and Multiplicative Laws of Probability (Optional)

241

(9)

Real-World Revisited

250

(10)

Discrete Probability Distributions

260

(43)

Real-World Application Commitment to the Firm---Stayers vs. Leavers

260

(33)

Random Variables

261

(1)

Probability Models for Discrete Random Variables

262

(8)

The Binomial Probability Distribution

270

(13)

The Poisson Probability Distribution

283

(5)

The Hypergeometric Probability Distribution (Optional)

288

(5)

Real-World Revisited

293

(6)

Using Microsoft Excel

299

(4)

Using Microsoft Excel to Obtain the Expected Value and Variance of a Probability Distribution

299

(1)

Using Microsoft Excel to Obtain Binomial Probabilities

300

(1)

Using Microsoft Excel to Obtain Poisson Probabilities

301

(1)

Using Microsoft Excel to Obtain Hypergeometric Probabilities

302

(1)

Normal Probability Distributions

303

(58)

Real-World Application Detecting Fire Insurance Fraud

303

(44)

Probability Models for Continuous Random Variables

304

(1)

The Normal Probability Distribution

305

(16)

Descriptive Methods for Assessing Normality

321

(9)

Sampling Distributions

330

(8)

The Sampling Distribution of the Mean and the Central Limit Theorem

338

(9)

Real-World Revisited

347

(8)

Using Microsoft Excel

355

(6)

Using Microsoft Excel to Obtain Normal Probabilities

355

(1)

Using Microsoft Excel to Construct Normal Probability Plots

356

(1)

Using Microsoft Excel to Simulate Sampling Distributions

357

(4)

Estimation of Population parameters Using Confidence Intervals: One Sample

361

(55)

Real-World Application Scallops, Sampling, and the Law

361

(40)

Point Estimators

362

(1)

Estimation of a Population Mean: Normal (z) Statistic

362

(13)

Estimation of a Population Mean: Student's t Statistic

375

(8)

Estimation of a Population Proportion

383

(7)

Choosing the Sample Size

390

(5)

Estimation of a Population Variance (Optional)

395

(6)

Real-World Revisited

401

(7)

Using Microsoft Excel

408

(8)

Using Microsoft Excel to Obtain the Confidence Interval Estimate for the Mean (σ known)

408

(1)

Using Microsoft Excel to Obtain the Confidence Interval Estimate for the Mean (&sgma; unknown)

409

(1)

Using Microsoft Excel to Obtain the Confidence Interval Estimate for the Proportion

410

(1)

Using Microsoft Excel to Determine the Sample Size for Estimating the Mean

411

(2)

Using Microsoft Excel to Determine the Sample Size for Estimating the Proportion

413

(1)

Using Microsoft Excel to Obtain the Confidence Interval Estimate for the Population Variance

414

(2)

Testing Hypotheses about Population Parameters: One Sample

416

(62)

Real-World Application Cellular Telephones---Road Hazards?

416

(48)

The Relationship between Hypothesis Tests and Confidence Intervals

417

(1)

Hypothesis-Testing Methodology: Formulating Hypotheses

418

(7)

Hypothesis-Testing Methodology: Test Statistics and Rejection Regions

425

(8)

Guidelines for Determining the Target Parameter

433

(2)

Testing a Population Mean

435

(9)

Reporting Test Results: p-Values

444

(8)

Testing a Population Proportion

452

(5)

Testing a Population Variance (Optional)

457

(4)

Potential Hypothesis-Testing Pitfalls and Ethical Issues

461

(3)

Real-World Revisited

464

(8)

Using Microsoft Excel

472

(6)

Using Microsoft Excel to Perform the Z Test of the Hypothesis for the Mean (σ known)

472

(1)

Using Microsoft Excel to Perform the t Test of the Hypothesis for the Mean (σ unknown)

473

(1)

Using Microsoft Excel to Perform the Z Test of the Hypothesis for the Proportion

474

(1)

Using Microsoft Excel to Perform the Chi-Square Test of the Hypothesis for the Variance

475

(3)

Inferences about Population Parameters: Two Samples

478

(76)

Real-World Application An IQ Comparison of Identical Twins Reared Apart

478

(53)

Determining the Target Parameter

479

(1)

Comparing Two Population Means: Independent Samples

480

(14)

Comparing Two Population Means: Matched Pairs

494

(10)

Comparing Two Population Proportions: Independent Samples

504

(7)

Comparing Population Proportions: Contingency Tables

511

(12)

Comparing Two Population Variances (Optional)

523

(8)

Real-World Revisited

531

(12)

Using Microsoft Excel

543

(11)

Using Microsoft Excel to Compare Two Population Means: Independent Samples

543

(2)

Using Microsoft Excel to Compare Two Population Means: Matched Pairs

545

(1)

Using Microsoft Excel to Compare Two Population Proportions

546

(2)

Using Microsoft Excel to Analyze Contingency Tables

548

(2)

Using Microsoft Excel to Perform the F Test for Differences in Two Variances

550

(4)

Regression Analysis

554

(115)

Real-World Application The S.O.B. Effect among College Administrators

554

(90)

Introduction to Regression Models

555

(2)

The Straight-Line Model: Simple Linear Regression

557

(3)

Estimating and Interpreting the Model Parameters

560

(12)

Model Assumptions

572

(2)

Measuring Variability around the Least Squares Line

574

(2)

Inferences about the Slope

576

(9)

Inferences about the Correlation Coefficient (Optional)

585

(7)

The Coefficient of Determination

592

(4)

Using the Model for Estimation and Prediction

596

(8)

Computations in Simple Linear Regression (Optional)

604

(8)

Residual Analysis: Checking the Assumptions (Optional)

612

(12)

Multiple Regression Models (Optional)

624

(17)

Pitfalls in Regression and Ethical Issues

641

(3)

Real-World Revisited

644

(17)

Using Microsoft Excel

661

(8)

Using Microsoft Excel to Generate Scatter Diagrams and a Regression Line

661

(2)

Using Microsoft Excel for Simple Linear Regression

663

(2)

Using Microsoft Excel to Test for the Existence of Correlation

665

(2)

Using Microsoft Excel for Multiple Regression (Optional)

667

(2)

Analysis of Variance

669

(67)

Real-World Application Reluctance to Transmit Bad News---The MUM Effect

669

(49)

Experimental Design

670

(3)

ANOVA Fundamentals

673

(2)

Completely Randomized Designs: One-Way ANOVA

675

(11)

Factorial Designs: Two-Way ANOVA

686

(14)

Follow-Up Analysis: Multiple Comparisons of Means

700

(10)

Checking ANOVA Assumptions

710

(2)

Calculation Formulas for ANOVA (Optional)

712

(6)

Real-World Revisited

718

(13)

Using Microsoft Excel

731

(5)

Using Microsoft Excel for a One-Way ANOVA

731

(1)

Using Microsoft Excel for a Two-Way ANOVA

732

(1)

Using Microsoft Excel for Multiple Comparisons

733

(3)

Nonparametric Statistics

736

(55)

Real-World Application Do Women Really Understand the Benefit of a Mammography?

736

(42)

Distribution-Free Tests

737

(1)

Testing for Location of a Single Population

738

(7)

Comparing Two Populations: Independent Random Samples

745

(9)

Comparing Two Populations: Matched-Pairs Design

754

(8)

Comparing Three or More Populations: Completely Randomized Design

762

(7)

Testing for Rank Correlation

769

(9)

Real-World Revisited

778

(8)

Using Microsoft Excel

786

(5)

Using Microsoft Excel for the Sign Test

786

(2)

Using Microsoft Excel to Perform the Wilcoxon Rank Sum Test for Differences in Two Medians

788

(1)

Using Microsoft Excel to Perform the Kruskal-Wallis H Test for Differences in c Medians

789

(2)

Appendix A Review of Arithmetic and Algebra

791

(8)

Appendix B Statistical Tables

799

(20)

Appendix C Documentation for Microsoft Excel Diskette Files

819

(5)

Appendix D Installation Instructions for the PHStat Add-In for Microsoft Excel and the Data Files on the CD-ROM

824

(1)

Answers to Self-Test Problems

825

(2)

Answers to Selected Problems

827

(7)

References

834

(3)

Excel Index

837

(2)

Subject Index

839

Amazon no longer offers textbook rentals. We do!

Practical Statistics by Example Using Microsoft Excel

Practical Statistics by Example Using Microsoft Excel

9780130960832

0130960837

Summary

Table of Contents

Supplemental Materials

Write a Review

Amazon no longer offers textbook rentals. We do!

Practical Statistics by Example Using Microsoft Excel

Practical Statistics by Example Using Microsoft Excel

9780130960832

0130960837

Summary

Table of Contents

Supplemental Materials

Write a Review

Related Products