Skip to content

Data Analysis with Microsoft Excel Updated for Office 2007

Best in textbook rentals since 2012!

ISBN-10: 0495391786

ISBN-13: 9780495391784

Edition: 3rd 2010 (Revised)

Authors: Kenneth N. Berk, Patrick M. Carey

List price: $149.95
Blue ribbon 30 day, 100% satisfaction guarantee!
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: $149.95
Edition: 3rd
Copyright year: 2010
Publisher: Brooks/Cole
Publication date: 6/18/2009
Binding: Paperback
Pages: 608
Size: 7.25" wide x 9.00" long x 1.00" tall
Weight: 2.046
Language: English

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 designing and analyzing clinical studies. He co-authored his first textbook on using Excel as a statistical tool. Patrick has authored or co-authored over 20 academic and trade texts for the software industry.

Getting Started with Excel
Getting Started
Special Files for This Book
Installing the StatPlus Files
Excel and Spreadsheets
Launching Excel
Viewing the Excel Window
Running Excel Commands
Excel Workbooks and Worksheets
Opening a Workbook
Scrolling through a Workbook
Worksheet Cells
Selecting a Cell
Moving Cells
Printing from Excel
Previewing the Print Job
Setting Up the Page
Printing the Page
Saving Your Work
Excel Add-Ins
Loading the StatPlus Add-In
Loading the Data Analysis ToolPak
Unloading an Add-In
Features of StatPlus
Using StatPlus Modules
Hidden Data
Linked Formulas
Setup Options
Exiting Excel
Working with Data
Data Entry
Entering Data from the Keyboard
Entering Data with Autofill
Inserting New Data
Data Formats
Formulas and Functions
Inserting a Simple Formula
Inserting an Excel Function
Cell References
Range Names
Sorting Data
Querying Data
Using the AutoFilter
Using the Advanced Filter
Using Calculated Values
Importing Data from Text Files
Importing Data from Databases
Using Excel's Database Query Wizard
Specifying Criteria and Sorting Data
Exercises
Working with Charts
Introducing Excel Charts
Introducing Scatter Plots
Editing a Chart
Resizing and Moving an Embedded Chart
Moving a Chart to a Chart Sheet
Working with Chart and Axis Titles
Editing the Chart Axes
Working with Gridlines and Legends
Editing Plot Symbols
Identifying Data Points
Selecting a Data Row
Labeling Data Points
Formatting Labels
Creating Bubble Plots
Breaking a Scatter Plot into Categories
Plotting Several Variables
Exercises
Describing Your Data
Variables and Descriptive Statistics
Frequency Tables
Creating a Frequency Table
Using Bins in a Frequency Table
Defining Your Own Bin Values
Working with Histograms
Creating a Histogram
Shapes of Distributions
Breaking a Histogram into Categories
Working with Stem and Leaf Plots
Distribution Statistics
Percentiles and Quartiles
Measures of the Center: Means, Medians, and the Mode
Measures of Variability
Measures of Shape: Skewness and Kurtosis
Outliers
Working with Boxplots
Concept Tutorials: Boxplots
Exercises
Probability Distributions
Probability
Probability Distributions
Discrete Probability Distributions
Continuous Probability Distributions
Concept Tutorials: PDFs
Random Variables and Random Samples
Concept Tutorials: Random Samples
The Normal Distribution
Concept Tutorials: The Normal Distribution
Excel Worksheet Functions
Using Excel to Generate Random Normal Data
Charting Random Normal Data
The Normal Probability Plot
Parameters and Estimators
The Sampling Distribution
Concept Tutorials: Sampling Distributions
The Standard Error
The Central Limit Theorem
Concept Tutorials: The Central Limit Theorem
Exercises
Statistical Inference
Confidence Intervals
z Test Statistic and z Values
Calculating the Confidence Interval with Excel
Interpreting the Confidence Interval
Concept Tutorials: The Confidence Interval
Hypothesis Testing
Types of Error
An Example of Hypothesis Testing
Acceptance and Rejection Regions
p Values
Concept Tutorials: Hypothesis Testing
Additional Thoughts about Hypothesis Testing
The t Distribution
Concept Tutorials: The t Distribution
Working with the t Statistic
Constructing a t Confidence Interval
The Robustness of t
Applying the t Test to Paired Data
Applying a Nonparametric Test to Paired Data
The Wilcoxon Signed Rank Test
The Sign Test
The Two-Sample t Test
Comparing the Pooled and Unpooled Test Statistics
Working with the Two-Sample t Statistic
Testing for Equality of Variance
Applying the t Test to Two-Sample Data
Applying a Nonparametric Test to Two-Sample Data
Final Thoughts about Statistical Inference
Exercises
Tables
PivotTables
Removing Categories from a PivotTable
Changing the Values Displayed by the PivotTable
Displaying Categorical Data in a Bar Chart
Displaying Categorical Data in a Pie Chart
Two-Way Tables
Computing Expected Counts
The Pearson Chi-Square Statistic
Concept Tutorials: The �<sup>2</sup> Distribution
Working with the �<sup>2</sup> Distribution in Excel
Breaking Down the Chi-Square Statistic
Other Table Statistics
Validity of the Chi-Square Test with Small Frequencies
Tables with Ordinal Variables
Testing for a Relationship between Two Ordinal Variables
Custom Sort Order
Exercises
Regression and Correlation
Simple Linear Regression
The Regression Equation
Fitting the Regression Line
Regression Functions in Excel
Exploring Regression
Performing a Regression Analysis
Plotting Regression Data
Calculating Regression Statistics
Interpreting Regression Statistics
Interpreting the Analysis of Variance Table
Parameter Estimates and Statistics
Residuals and Predicted Values
Checking the Regression Model
Testing the Straight-Line Assumption
Testing for Normal Distribution of the Residuals
Testing for Constant Variance in the Residuals
Testing for the Independence of Residuals
Correlation
Correlation and Slope
Correlation and Causality
Spearman's Rank Correlation Coefficient s
Correlation Functions in Excel
Creating a Correlation Matrix
Correlation with a Two-Valued Variable
Adjusting Multiple p Values with Bonferroni
Creating a Scatter Plot Matrix
Exercises
Multiple Regression
Regression Models with Multiple Parameters
Concept Tutorials: The F Distribution
Using Regression for Prediction
Regression Example: Predicting Grades
Interpreting the Regression Output
Multiple Correlation
Coefficients and the Prediction Equation
t Tests for the Coefficients
Testing Regression Assumptions
Observed versus Predicted Values
Plotting Residuals versus Predicted Values
Plotting Residuals versus Predictor Variables
Normal Errors and the Normal Plot
Summary of Calc Analysis
Regression Example: Sex Discrimination
Regression on Male Faculty
Using a SPLOM to See Relationships
Correlation Matrix of Variables
Multiple Regression
Interpreting the Regression Output
Residual Analysis of Discrimination Data
Normal Plot of Residuals
Are Female Faculty Underpaid?
Drawing Conclusions
Exercises
Analysis of Variance
One-Way Analysis of Variance
Analysis of Variance Example: Comparing Hotel Prices
Graphing the Data to Verify ANOVA Assumptions
Computing the Analysis of Variance
Interpreting the Analysis of Variance Table
Comparing Means
Using the Bonferroni Correction Factor
When to Use Bonferroni
Comparing Means with a Boxplot
One-Way Analysis of Variance and Regression
Indicator Variables
Fitting the Effects Model
Two-Way Analysis of Variance
A Two-Factor Example
Two-Way Analysis Example: Comparing Soft Drinks
Graphing the Data to Verify Assumptions
The Interaction Plot
Using Excel to Perform a Two-Way Analysis of Variance
Interpreting the Analysis of Variance Table
Summary
Exercises
Time Series
Time Series Concepts
Time Series Example: The Rise in Global Temperatures
Plotting the Global Temperature Time Series
Analyzing the Change in Global Temperature
Looking at Lagged Values
The Autocorrelation Function
Applying the ACF to Annual Mean Temperature
Other ACF Patterns
Applying the ACF to the Change in Temperature
Moving Averages
Simple Exponential Smoothing
Forecasting with Exponential Smoothing
Assessing the Accuracy of the Forecast
Concept Tutorials: One-Parameter Exponential Smoothing
Choosing a Value for w
Two-Parameter Exponential Smoothing
Calculating the Smoothed Values
Concept Tutorials: Two-Parameter Exponential Smoothing
Seasonality
Multiplicative Seasonality
Additive Seasonality
Seasonal Example: Liquor Sales
Examining Seasonality with a Boxplot
Examining Seasonality with a Line Plot
Applying the ACF to Seasonal Data
Adjusting for Seasonality
Three-Parameter Exponential Smoothing
Forecasting Liquor Sales
Optimizing the Exponential Smoothing Constant (optional)
Exercises
Quality Control
Statistical Quality Control
Controlled Variation
Uncontrolled Variation
Control Charts
Control Charts and Hypothesis Testing
Variable and Attribute Charts
Using Subgroups
The <$>\bar {x}<$> Chart
Calculating Control Limits When � Is Known
<$>\bar {x}<$> Chart Example: Teaching Scores
Calculating Control Limits When � Is Unknown
<$>\bar {x}<$> Chart Example: A Coating Process
The Range Chart
The C Chart
C Chart Example: Factory Accidents
The P Chart
P Chart Example: Steel Rod Defects
Control Charts for Individual Observations
The Pareto Chart
Exercises
Appendix
Excel Reference
Bibliography
Index