Amazon no longer offers textbook rentals. We do!

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

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

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

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

ISBN 13:
9780538494670
ISBN 10:
0538494670
Edition: 3rd
Format: Paperback
Copyright: 08/26/2009
Publisher: Duxbury Press

Rent From $143.95

New From $177.22

List Price $179.00 Save

Rent $143.95

TERM	PRICE	DUE
SHORT TERM	$143.95	Jun 07

Added Benefits of Renting

Free Shipping Both Ways
Highlight/Take Notes Like You Own It
Purchase/Extend Before Due Date

Add to Cart

List Price $179.00 Save $1.78

New $177.22

Usually Ships in 24-48 Hours

We Buy This Book Back!

Included with your book

Free Shipping On Every Order

Add to Cart

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

Extend or Purchase Your Rental at Any Time

Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.

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.

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.

Amazon no longer offers textbook rentals. We do!

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

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

9780538494670

0538494670

Summary

Table of Contents

Supplemental Materials

Write a Review

Amazon no longer offers textbook rentals. We do!

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

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

9780538494670

0538494670

Summary

Table of Contents

Supplemental Materials

Write a Review

Related Products