Data Analysis with Microsoft Excel Updated for Office 2007 (with Web Site Printed Access Card)

by Berk, Kenneth N.; Carey, Patrick M.

• ISBN13: 9780538494670
• ISBN10: 0538494670
• Edition: 3rd
• Format: Paperback
• Copyright: 2009-08-26
• Publisher: Duxbury Press

Summary

This popular best-selling book shows students and professionals how to do data analysis with Microsoft? Excel. DATA ANALYSIS WITH MICROSOFT EXCEL teaches the fundamental concepts of statistics and how to use Microsoft Excel to solve the kind of data-intensive problems that arise in business and elsewhere. Even students with no previous experience using spreadsheets will find that this text?s step-by-step approach, extensive tutorials, and examples make it easy to learn how to use Excel for analyzing data. A downloadable StatPlus? add-in for Microsoft Excel, data sets for exercises, and interactive concept tutorials are available on the Book Companion Website.

Table of Contents

Getting Started with Excel

Special Files for This Book

Excel and Spreadsheets

Excel Workbooks and Worksheets

Worksheet Cells

Printing from Excel

Saving Your Work

Excel Add-Ins

Features of Statplus

Exiting Excel

Working with Data

Data entry

Data Formats

Formulas and Functions

Cell References

Range Names

Sorting Data

Querying Data

Importing Data from Text Files

Importing Data from Databases

Exercises

Working with Charts

Working with Excel Charts

Introducing Scatterplots

Creating Charts with the Chart Wizard

Editing a Chart

Identifying Data Points

Creating Bubble Plots

Breaking a Scatterplot into Categories

Plotting Several Variables

Exercises

Fundamentals of Statistics

Describing Your Data

Variables and Descriptive Statistics

Looking at Distributions with Frequency Tables

Working with Histograms

Working with Stem and Leaf Plots

Distribution Statistics

Working with Boxplots

Exercises

Probability Distributions

Probability

Probability Distributions

Random Variables and Random Samples

The Normal Distribution

Parameters and Estimators

The Sampling Distribution

The Central Limit Theorem

Exercises

Statistical Inference

Confidence Intervals

Hypothesis Testing

The t-Distribution

Applying the t-Test to Paired Data

Applying a Nonparametric Test to Paired Data

The Two-Sample t-Test

Applying the t-Test to Two-Sample Data

Applying a Nonparametric Test to Two-Sample Data

Final Thoughts about Statistical Inference

Exercises

Tables

Pivot Tables

Two-Way Tables

Computing Expected Counts

The Pearson Chi-Square Statistic

Other Table Statistics

Validity of the Chi-Square Test with Small Frequencies

Tables with Ordinal Variables

Exercises

Statistical Methods

Regression and Correlation

Simple Linear Regression

Regression Functions in Excel

Performing a Regression on Analysis

Checking the Regression Model

Correlation

Creating a Correlation Matrix

Creating a Scatterplot Matrix

Exercises

Multiple Regression

Regression Models with Multiple Parameters

Regression Example: Predicting Grades

Testing Regression Assumptions

Plotting Residuals s

Predicted Values

Regression Example: Sex Discrimination

Exercises

Analysis of Variance

One-Way Analysis of Variance

Analysis of Variance Example: Comparing Hotel Prices

Comparing Means

Using the Bonferroni Correction Factor

When to Use Bonferroni

One-Way Analysis of Variance and Regression

Two-Way Analysis of Variance

A Two-Factor Example

Two-Way Analysis Example: Comparing Soft Drinks

Exercises

Time Series

Time Series Concepts

Time Series Example: The Dow in the 1980s

The Autocorrelation Function

Moving Averages

Simple Exponential Smoothing

Two-Parameter Exponential Smoothing

Seasonality

Seasonal Example: Beer Production

Three-Parameter Exponential

Smoothing

Optimizing the Exponential

Smoothing Constant (Optional)

Exercises

Quality Control

Statistical Quality Control

Control Charts

The Chi [Overbar] Chart

The Range Chart

The C-Chart

The P-Chart

Control Charts for Individual Observations

The Pareto Chart

Exercises

Appendix

Excel Reference

Bibliography

Index

Table of Contents provided by Publisher. All Rights Reserved.