Statistics for Managers Using Microsoft Excel and Student CD Package

by Levine, David M.; Stephan, David; Krehbiel, Timothy C.; Berenson, Mark L.

• ISBN13: 9780131073890
• ISBN10: 0131073893
• Edition: 4th
• Format: Hardcover
• Copyright: 2005-01-01
• Publisher: Prentice Hall

Summary

This book was the first to thoroughly integrate the use of Microsoft Excel as a tool for statistical analysis.The book focuses on the concepts of statistics with applications to the functional areas of business. It is rich in applications from accounting, finance, marketing, management and economics, covering data collection, tables and charts, probability, estimation, and more.For professionals, particularly managers, making financial analyses and decisions.

Table of Contents

Introduction and Data Collection

What is Statistics

The Growth of Statistics and Information Technology

Microsoft Excel: The Solution to a Problem or a Problem Itself

Learning about Business Statistics

Learning Statistics with Microsoft Excel

Using Microsoft Excel in the Best Way Possible

Learning Business Statistics using this Text

How this Text is Organized

The Importance of Collecting Data

Identifying Sources of Data

Types of Survey Sampling Methods

Types of Data

Evaluating Survey Worthiness

Presenting Data in Tables and Charts

Organizing Numerical Data

Tables and Charts for Numerical Data

Graphing Bivariate Numerical Data

Tables and Charts for Categorical Data

Tabulating and Graphing Bivariate Categorical Data

Graphical Excellence

Numerical Descriptive Measures

Exploring Numerical Data and Their Properties

Measures of Central Tendency, Variation, and Shape

Obtaining Descriptive Summary Measures from a Population

Exploratory Data Analysis

The Coefficient of Correlation

Pitfalls in Numerical Descriptive Measures and Ethical Issues

CD-ROM Topic Obtaining Descriptive Summary Measures from a Frequency Distribution

Basic Probability

Basic Probability Concepts

Conditional Probability

Bayes' Theorem

Ethical Issues and Probability

CD-ROM Topic: Counting Rules

Some Important Discrete Probability Distributions

The Probability Distribution for a Discrete Random Variable

Covariance and Its Application in Finance

Binomial Distribution

Hypergeometric Distribution

Poisson Distribution

CD ROM TopicUsing the Poisson Distribution to Approximate the Binomial Distribution

The Normal Distribution and Other Continuous Distributions and Sampling Distributions

The Normal Distribution

Evaluating the Normality Assumption

The Uniform Distribution

The Exponential Distribution

Introduction to Sampling Distributions

Sampling Distribution of the Mean

Sampling Distribution of the Proportion

CD ROM TopicThe Normal Approximation to the Binomial Distribution

CD ROM TopicSampling from Finite Populations

Confidence Interval Estimation

Confidence Interval Estimation of the Mean (sigma; Known)

Confidence Interval Estimation of the Mean (sigma; Unknown)

Confidence Interval Estimation for the Proportion

Determining Sample Size

Applications of Confidence Interval Estimation in Auditing

Confidence Interval Estimation and Ethical Issues

CD ROM TopicEstimation and Sample Size Determination for Finite Populations

Fundamentals of Hypothesis Testing

Hypothesis-Testing Methodology

ZTest of Hypothesis for the Mean (sigma; Known)

One-Tailed Tests

tTest of Hypothesis for the Mean (sigma; Unknown)

ZTest of Hypothesis for the Proportion

Potential Hypothesis-Testing Pitfalls and Ethical Issues

CD ROM TopicThe Power of a Test

Two Sample Tests

Comparing Two Independent Samples: Tests for Differences in Two Means

Comparing Two Related Samples: Tests for the Mean Difference

ZTest for the Difference between Two Proportions

FTest for Differences in Two Variances

Analysis of Variance

The Completely Randomized Design: One-Way Analysis of Variance

The Factorial Design: Two-Way Analysis of Variance

CD ROM TopicThe Randomized Block Design

Chi-Square Tests and Nonparametric Tests

Table of Contents provided by Publisher. All Rights Reserved.