Predictive Analytics Microsoft Excel

ISBN-10: 0789749416

ISBN-13: 9780789749413

Edition: 2013 (Revised)

Authors: Conrad Carlberg

List price: $39.99 Buy it from $14.15
eBook available
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy


"Moneyball" helped make predictive analytics famous, but companies of all types are discovering these techniques' immense value for improving decision-making and profitability. Not everyone has access to expensive predictive analytics tools such as SAS, but virtually every business professional does have software that can serve the purpose admirably: Microsoft Excel. In this complete, hands-on tutorial, Microsoft Excel MVP Conrad Carlberg shows business professionals exactly how to solve real-world business problems with Excel predictive analytics, in areas ranging from sales and marketing to operations. Building on skills they already have, experienced Excel users will master techniques ranging from least squares regression and moving averages through smoothing, ARIMA, and logistic regression. Carlberg helps Excel users avoid pitfalls associated with simply "plugging" numbers into Excel's Data Analysis add-in (formerly "Analysis ToolPak"), showing how to create more credible, reliable forecasts. His forecasting coverage is more thorough and sophisticated than that of any other book. Carlberg also provides downloadable Excel workbooks that can be easily adapted to readers' unique requirements. This book's techniques are highly prized by companies seeking to increase revenues, reduce costs, and improve productivity; businesspeople who master these skills will have a major competitive advantage.
Used Starting from $14.15
New Starting from $34.44
eBooks Starting from $31.99
Buy eBooks
what's this?
Rush Rewards U
Members Receive:
You have reached 400 XP and carrot coins. That is the daily max!
Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Customers also bought

Book details

List price: $39.99
Copyright year: 2013
Publisher: Pearson Education
Publication date: 7/2/2012
Binding: Paperback
Pages: 304
Size: 7.00" wide x 9.00" long x 0.75" tall
Weight: 1.100
Language: English

Building a Collector
Planning an Approach
A Meaningful Variable
Identifying Sales
Planning the Workbook Structure
Query Sheets
Summary Sheets
Snapshot Formulas
More Complicated Breakdowns
The VBA Code
The DoltAgain Subroutine
The GetNewData Subroutine
The GetRank Function
The GetUnitsLeft Function
The RefreshSheets Subroutine
The Analysis Sheets
Defining a Dynamic Range Name
Using the Dynamic Range Name
Linear Regression
Correlation and Regression
Charting the Relationship
Calculating Pearson's Correlation Coefficient
Correlation Is Not Causation
Simple Regression
Array-Entering Formulas
Array-Entering LINEST()
Multiple Regression
Creating the Composite Variable
Analyzing the Composite Variable
Assumptions Made in Regression Analysis
Using Excel's Regression Tool
Accessing the Data Analysis Add-In
Running the Regression Tool
Forecasting with Moving Averages
About Moving Averages
Signal and Noise
Smoothing Versus Tracking
Weighted and Unweighted Moving Averages
Criteria for Judging Moving Averages
Mean Absolute Deviation
Least Squares
Using Least Squares to Compare Moving Averages
Getting Moving Averages Automatically
Using the Moving Average Tool
Forecasting a Time Series: Smoothing
Exponential Smoothing: The Basic Idea
Why "Exponential" Smoothing?
Using Excel's Exponential Smoothing Tool
Understanding the Exponential Smoothing Dialog Box
Choosing the Smoothing Constant
Setting Up the Analysis
Using Solver to Find the Best Smoothing Constant
Understanding Solver's Requirements
The Point
Handling Linear Baselines with Trend
Characteristics of Trend
First Differencing
Holt's Linear Exponential Smoothing
About Terminology and Symbols in Handling Trended Series
Using Holt Linear Smoothing
Forecasting a Time Series: Regression
Forecasting with Regression
Linear Regression: An Example
Using the LINEST() Function
Forecasting with Autoregression
Problems with Trends
Correlating at Increasing Lags
A Review: Linear Regression and Autoregression
Adjusting the Autocorrelation Formula
Using ACFs
Understanding PACFs
Using the ARIMA Workbook
Logistic Regression: The Basics
Traditional Approaches to the Analysis
Z-tests and the Central Limit Theorem
Using Chi-Square
Preferring Chi-square to a Z-test
Regression Analysis on Dichotomies
Residuals Are Normally Distributed
Restriction of Predicted Range
Ah, But You Can Get Odds Forever
Probabilities and Odds
How the Probabilities Shift
Moving On to the Log Odds
Logistic Regression: Further Issues
An Example: Predicting Purchase Behavior
Using Logistic Regression
Calculation of Logit or Log Odds
Comparing Excel with R: A Demonstration
Getting R
Running a Logistic Analysis in R
The Purchase Data Set
Statistical Tests in Logistic Regression
Models Comparison in Multiple Regression
Calculating the Results of Different Models
Testing the Difference Between the Models
Models Comparison in Logistic Regression
Principal Components Analysis
The Notion of a Principal Component
Reducing Complexity
Understanding Relationships Among Measurable Variables
Maximizing Variance
Components Are Mutually Orthogonal
Using the Principal Components Add-In
The R Matrix
The Inverse of the R Matrix
Matrices, Matrix Inverses, and Identity Matrices
Features of the Correlation Matrix's Inverse
Matrix Inverses and Beta Coefficients
Singular Matrices
Testing for Uncorrelated Variables
Using Eigenvalues
Using Component Eigenvectors
Factor Loadings
Factor Score Coefficients
Principal Components Distinguished from Factor Analysis
Distinguishing the Purposes
Distinguishing Unique from Shared Variance
Rotating Axes
Box-Jenkins ARIMA Models
The Rationale for ARIMA
Deciding to Use ARIMA
ARIMA Notation
Stages in ARIMA Analysis
The Identification Stage
Identifying an AR Process
Identifying an MA Process
Differencing in ARIMA Analysis
Using the ARIMA Workbook
Standard Errors in Correlograms
White Noise and Diagnostic Checking
Identifying Seasonal Models
The Estimation Stage
Estimating the Parameters for ARIMA(1,0,0)
Comparing Excel's Results to R's
Exponential Smoothing and ARIMA(0,0,1)
Using ARIMA(0,1,1) in Place of ARIMA(0,0,1)
The Diagnostic and Forecasting Stages
Varimax Factor Rotation in Excel
Getting to a Simple Structure
Rotating Factors: The Rationale
Extraction and Rotation: An Example
Showing Text Labels Next to Chart Markers
Structure of Principal Components and Factors
Rotating Factors: The Results
Charting Records on Rotated Factors
Using the Factor Workbook to Rotate Components
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.