Preface | p. ix |
About the Authors | p. xiii |
Introduction to Business Statistics with Excel | p. 1 |
Business Statistics Applications | p. 2 |
Basic Statistical Concepts | p. 3 |
Data | p. 6 |
Statistical Analysis Using Excel | p. 11 |
Data Analysis Tools | p. 11 |
Statistical Functions | p. 12 |
The Chart Wizard | p. 13 |
The Trendline Feature | p. 17 |
FAST [characters not reproducible] STAT Add-in Macros | p. 19 |
Descriptive Charts and Graphs | p. 27 |
Frequency Distributions | p. 28 |
Graphic Depiction of Data | p. 34 |
Descriptive Statistics | p. 47 |
Measures of Central Tendency | p. 48 |
Measures of Variabilit...y | p. 58 |
Measures of Shape | p. 76 |
Summary Statistics in Excel | p. 83 |
Probability | p. 91 |
Introduction to Probability | p. 92 |
Methods of Assigning Probabilities | p. 93 |
Structure of Probability | p. 94 |
Marginal, Union, Joint, and Conditional Probabilities | p. 101 |
Law of Addition | p. 102 |
Law of Multiplication | p. 112 |
Law of Conditional Probability | p. 119 |
Revision of Probabilities: Bayes' Rule | p. 128 |
Discrete Probability Distributions | p. 139 |
Discrete Versus Continuous Distributions | p. 140 |
Binomial Distribution | p. 141 |
Poisson Distribution | p. 153 |
Hypergeometric Distribution | p. 162 |
Continuous Probability Distributions | p. 173 |
The Uniform Distribution | p. 174 |
Normal Distribution | p. 181 |
Using the Normal Curve to Work Binomial Distribution Problems | p. 195 |
Exponential Distribution | p. 203 |
Sampling and Sampling Distributions | p. 215 |
Sampling | p. 216 |
Sampling Distribution of X | p. 227 |
Sampling Distribution of p | p. 239 |
Estimation with Single Samples | p. 249 |
Estimating the Population Mean with Large Sample Sizes | p. 250 |
Estimating the Population Mean: Small Sample Sizes, [sigma] Unknown | p. 260 |
Estimating the Population Proportion | p. 268 |
Estimating Sample Size | p. 274 |
Hypothesis Testing with Single Samples | p. 287 |
Introduction to Hypothesis Testing | p. 288 |
Testing Hypotheses about a Single Mean Using Large Samples | p. 295 |
Testing Hypotheses about a Single Mean Using Small Samples: [sigma] Unknown | p. 304 |
Testing Hypotheses about a Proportion | p. 311 |
Hypothesis Testing with Two Samples | p. 323 |
Hypothesis Testing about the Difference in Two Means: Large, Independent Samples | p. 324 |
Hypothesis Testing about the Difference in Two Population Means: Small Independent Samples | p. 334 |
Hypothesis Testing about the Mean Difference in Two Related Populations | p. 343 |
Hypothesis Testing About the Difference in Two Population Proportions | p. 352 |
Hypothesis Testing about the Difference in Two Population Variances | p. 360 |
Analysis of Variance and Chi-Square Applications | p. 379 |
Introduction to Design of Experiments | p. 380 |
The Completely Randomized Design (One-Way ANOVA) | p. 382 |
The Randomized Block Design | p. 393 |
A Factorial Design (Two-Way ANOVA) | p. 405 |
Chi-Square Goodness-of-Fit Test | p. 419 |
Contingency Analysis: Chi-Square Test of Independence | p. 430 |
Simple Regression and Correlation Analysis | p. 449 |
Introduction to Simple Regression Analysis | p. 450 |
Determining the Equation of the Regression Line | p. 452 |
Analyzing the Fit of the Regression Line: Residuals, r[superscript 2], and Standard Error of the Estimate | p. 461 |
Hypothesis Tests for the Slope of the Regression Model and Testing the Overall Model | p. 474 |
Estimation | p. 480 |
Measures of Association | p. 487 |
Multiple Regression Analysis | p. 501 |
The Multiple Regression Model | p. 502 |
Evaluating the Multiple Regression Model | p. 511 |
Indicator (Dummy) Variables | p. 525 |
More Complex Regression Models | p. 531 |
Model-Building: Search Procedures | p. 544 |
Multicollinearity | p. 554 |
Time Series Forecasting | p. 567 |
Introduction to Forecasting | p. 568 |
Time Series Components | p. 570 |
Time Series Forecasting Procedure | p. 576 |
Stationary Forecasting Methods | p. 593 |
Trend Forecasting Methods | p. 603 |
Seasonal Forecasting Methods | p. 630 |
Statistical Quality Control | p. 655 |
Introduction to Quality Control | p. 656 |
Process Analysis | p. 663 |
Control Charts | p. 668 |
Tables | p. 1 |
Random Numbers | p. 2 |
Binomial Probability Distribution | p. 3 |
Poisson Probabilities | p. 10 |
The e[superscript -x] Table | p. 15 |
Areas of the Standard Normal Distribution (also on front endsheet) | p. 16 |
Critical Values of t (also on front endsheet) | p. 17 |
Percentage Points of the F Distribution | p. 18 |
The Chi-Square Table | p. 28 |
Critical Values for the Durbin-Watson Test | p. 29 |
Factors for Control Charts | p. 31 |
Answers to Selected Odd-Numbered Quantitative Problems | p. 1 |
Glossary | p. 1 |
Index | p. 1 |
Table of Contents provided by Syndetics. All Rights Reserved. |