Skip to content

Data Analysis with Microsoft� Excel� 2007

Spend $50 to get a free movie!

ISBN-10: 0538494670

ISBN-13: 9780538494670

Edition: 3rd 2010 (Revised)

Authors: Kenneth N. Berk, Partrick Carey

List price: $178.95
Blue ribbon 30 day, 100% satisfaction guarantee!
Out of stock
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Customers also bought

Book details

List price: $178.95
Edition: 3rd
Copyright year: 2010
Publisher: Brooks/Cole
Publication date: 8/26/2009
Binding: Paperback
Pages: 608
Size: 7.50" wide x 9.50" long x 0.75" tall
Weight: 2.112

Jay Devore received a B.S. in Engineering Science from the University of California, Berkeley, and a Ph.D. in Statistics from Stanford University. He previously taught at the University of Florida and Oberlin College, and has had visiting positions at Stanford, Harvard, the University of Washington, New York University, and Columbia. He has been at California Polytechnic State University, San Luis Obispo, since 1977, where he was chair of the Department of Statistics for seven years and recently achieved the exalted status of Professor Emeritus.Jay has previously authored or coauthored �ve other books, including Probability and Statistics for Engineering and the Sciences, which won a…    

Patrick Carey received his M.S. in Biostatistics from the University of Wisconsin where he worked as a researcher in the General Clinical Research Center designing and analyzing clinical studies. He co-authored his first textbook with Kenneth Berk on using Excel as a statistical tool. He and his wife Joan founded Carey Associates, Inc., a software textbook development company. He has since authored or co-authored over 20 academic and trade texts for the software industry. Besides books on data analysis, Carey has written on the Windows operating system, Web page design, database management, the Internet, browsers, and presentation graphics software. Patrick, Joan, and their six children…    

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