Cover image for Statistics for managers using Microsoft Excel
Title:
Statistics for managers using Microsoft Excel
Edition:
3rd ed.
Publication Information:
Upper Saddle river, NJ : Prentice Hall, 2002
Physical Description:
1v + 1 CD-ROM
ISBN:
9780130290908

9780130970824
General Note:
Also available in compact disc version : CP 4261

Available:*

Library
Item Barcode
Call Number
Material Type
Item Category 1
Status
Searching...
30000010053273 HD30.215 L43 2002 Open Access Book Book
Searching...
Searching...
30000005178292 HD30.215 L43 2002 Open Access Book Book
Searching...

On Order

Summary

Summary

For one- or two-term courses in Business Statistics at the undergraduate or graduate level. This text integrates the use of Microsoft Excel while focusing 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. There is significant emphasis on using statistical software as a tool, with most examples presented in a spreadsheet environment.


Table of Contents

Preface
1 Introduction and Data Collection
2 Presenting Data in Tables and Charts
3 Numerical Descriptive Measures
4 Basic Probability
5 Some Important Discrete Probability Distributions
6 The Normal Distribution and Other Continuous Distributions
7 Sampling and Sampling Distributions
8 Confidence Interval Estimation
9 Fundamentals of Hypothesis Testing: One-Sample Tests
10 Two-Sample Tests
11 Analysis of Variance
12 Chi-Square Tests and Nonparametric Tests
13 Simple Linear Regression
14 Introduction to Multiple Regression
15 Multiple Regression Model Building
16 Time-Series Forecasting and Index Numbers
17 Decision Making
18 Statistical Applications in Quality Management
Appendices
A Review of Arithmetic, Algebra, and Logarithms
B Summation Notation
C Statistical Symbols and Greek Alphabet
D CD-ROM Contents
E Tables
F Configuring Microsoft Excel and Installing PHStat
Self-Test Solutions and Answers to Selected Even-Numbered Problems
Index
CD-ROM Topics
4.5 Counting Rules
5.6 Using the Poisson Distribution to Approximate the Binomial Distribution
6.6 The Normal Approximation to the Binomial Distribution
7.6 Sampling from Finite Populations
8.7 Estimation and Sample Size Determination for Finite Populations
9.7 The Power of a Test
11.3 The Randomized Block Design
12.7 Chi-Square Test for a Variance or Standard Deviation