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

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

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

ISBN: 9780538494670 | 0538494670
Cover: Paperback
Copyright: 8/26/2009

Rent

(Recommended)

$166.40

Term

Due

Price

Semester

Aug 2

$166.40

*This item is part of an exclusive publisher rental program and requires an additional convenience fee. This fee will be reflected in the shopping cart.
Buy New

Currently Available, Usually Ships in 24-48 Hours

$176.33

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.

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.

Please wait while the item is added to your bag...

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

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

Summary

Table of Contents

Supplemental Materials