did-you-know? rent-now

Rent More, Save More! Use code: ECRENTAL

did-you-know? rent-now

Rent More, Save More! Use code: ECRENTAL

5% off 1 book, 7% off 2 books, 10% off 3+ books

9780538494670

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

by ;
  • ISBN13:

    9780538494670

  • ISBN10:

    0538494670

  • Edition: 3rd
  • Format: Paperback
  • Copyright: 2009-08-26
  • Publisher: Duxbury Press

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

Purchase Benefits

List Price: $179.00 Save up to $33.60
  • Rent Book $145.40
    Add to Cart Free Shipping Icon Free Shipping

    TERM
    PRICE
    DUE
    USUALLY SHIPS IN 24-48 HOURS
    *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.

How To: Textbook Rental

Looking to rent a book? Rent Data Analysis with Microsoft Excel Updated for Office 2007 (with Web Site Printed Access Card) [ISBN: 9780538494670] for the semester, quarter, and short term or search our site for other textbooks by Berk, Kenneth N.; Carey, Patrick M.. Renting a textbook can save you up to 90% from the cost of buying.

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.

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program