Data Analysis and Decision Making with Microsoft Excel, Revised (with CD-ROM and Decision Tools and Statistic Tools Suite),9780324662443

Data Analysis and Decision Making with Microsoft Excel, Revised (with CD-ROM and Decision Tools and Statistic Tools Suite)

by
Edition: 3rd
ISBN13: 9780324662443
ISBN10: 0324662440
Format: Hardcover
Pub. Date: 2008-06-24
Publisher(s): South-Western College Pub
Upgraded Edition: Click here!
  • Free Shipping Icon

    This Item Qualifies for Free Shipping!*

    *Excludes marketplace orders.

List Price: $356.95

Rent Textbook

Select for Price
Add to Cart
There was a problem. Please try again later.

New Textbook

We're Sorry
Sold Out

Used Textbook

We're Sorry
Sold Out

eTextbook

We're Sorry
Not Available

Buy from our Marketplace starting at $5.50

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

Master data analysis, modeling, and spreadsheet use with DATA ANALYSIS AND DECISION MAKING WITH MICROSOFT EXCEL! With a teach-by-example approach, student-friendly writing style, and complete Excel integration, this quantitative methods text provides you with the tools you need to succeed. Margin notes, boxed-in definitions and formulas in the text, enhanced explanations in the text itself, and stated objectives for the examples found throughout the text make studying easy. Problem sets and cases provide realistic examples that enable you to see the relevance of the material to your future as a business leader. The CD-ROMs packaged with every new book include the following add-ins: the Palisade Decision Tools Suite (@RISK, StatTools, PrecisionTree, TopRank, and RISKOptimizer); and SolverTable, which allows you to do sensitivity analysis. All of these add-ins have been revised for Excel 2007.

Table of Contents

Getting, Describing, and Summarizing Data
Introduction to Data Analysis and Decision Making
Introduction
An Overview of the Book
The Methods
The Software
A Sampling of Examples
Modeling and Models
Conclusion
Describing Data: Graphs and Tables
Introduction
Basic Concepts
Frequency Tables and Histograms
Analyzing Relationships with Scatterplots
Time Series Graphs
Exploring Data with Pivot Tables
Conclusion
Describing Data: Summary Measures
Introduction
Measures of Central Location
Quartiles and Percentiles
Minimum, Maximum, and Range
Measures of Variability: Variance and Standard Deviation
Obtaining Summary Measures with StatTools
Measures of Association: Covariance and Correlation
Describing Data Sets with Boxplots
Applying the Tools
Conclusion
Getting the Right Data
Introduction
Sources of Data
Excel Tables for Filtering, Sorting, and Summarizing
Complex Queries with the Advanced Filter
Importing External Data from Access
Creating Pivot Tables from External Data
Web Queries
Other Data Sources on the Web
Cleansing the Data
Conclusion
Probability, Uncertainty, and Decision Making
Probability and Probability Distributions
Introduction
Probability Essentials
Distribution of a Single Random Variable
An Introduction to Simulation
Distribution of Two Random Variables: Scenario Approach
Distribution of Two Random Variables: Joint Probability Approach
Independent Random Variables
Weighted Sums of Random Variables
Conclusion
Normal, Binomial, Poisson, and Exponential Distributions
Introduction
The Normal Distribution
Applications of the Normal Distribution
The Binomial Distribution
Applications of the Binomial Distribution
The Poisson and Exponential Distributions
Fitting a Probability Distribution to Data: BestFit
Conclusion
Decision Making Under Uncertainty
Introduction
Elements of a Decision Analysis
The PrecisionTree Add-In
Bayes' Rule
Multistage Decision Problems
Incorporating Attitudes Toward Risk
Conclusion
Statistical Inference
Sampling and Sampling Distributions
Introduction
Sampling Terminology
Methods for Selecting Random Samples
An Introduction to Estimation
Conclusion
Confidence Interval Estimation
Introduction
Sampling Distributions
Confidence Interval for a Mean
Confidence Interval for a Total
Confidence Interval for a Proportion
Confidence Interval for a Standard Deviation
Confidence Interval for the Difference Between Means
Confidence Interval for the Difference Between Proportions Controlling Confidence Interval Length
Conclusion
Hypothesis Testing
Introduction
Concepts in Hypothesis Testing
Hypothesis Tests for a Population Mean
Hypothesis Tests for Other Parameters
Tests for Normality
Chi-Square Test for Independence
One-Way ANOVA
Conclusion
Regression, Forecasting, and Time Series
Regression Analysis: Estimating Relationships
Introduction
Scatterplots: Graphing Relationships
Correlations: Indicators of Linear Relationships Simple Linear Regression
Multiple Regression
Modeling Possibilities
Validation of the Fit
Conclusion
Regression Analysis: Statistical Inference Introduction
The Statistical Model
Inferences About the Regression Coefficients
Multicollinearity
Include/Exclude Decisions
Stepwise Regression.The Partial F Test
Outliers
Violations of Regression Assumptions
Prediction
Conclusion
Time Series Analysis and Forecasting
Introduction
Forecasting Methods: An Overview
Testing for Randomness
Regression-Based Trend Models
The Random Walk Model
Autoregression Models
Moving Averages
Exponential Smoothing
Seasonal Models
Winters' Exponential Smoothing Model
Conclusion
Decision Modeling
Introduction to Optimization Modeling
Introduction
Introduction to Optimization
A Two-Variable Model
Sensitivity Analysis Properties of Linear Models
Infeasibility and Unboundedness
A Product Mix Model
A Multiperio
Table of Contents provided by Publisher. All Rights Reserved.

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.