Home > Store > Computer Software > Business Office Software > Spreadsheet Software > Microsoft Excel

More Predictive Analytics: Microsoft Excel

Register your product to gain access to bonus material or receive a coupon.

More Predictive Analytics: Microsoft Excel

Best Value Purchase

Book + eBook Bundle

  • Your Price: $43.19
  • List Price: $71.98
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

More Purchase Options

Book

  • Your Price: $31.99
  • List Price: $39.99
  • Usually ships in 24 hours.

eBook (Watermarked)

  • Your Price: $25.59
  • List Price: $31.99
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

About

Features

  • Students will master both the "how" and "why" of using data to make the best data-driven decisions
  • Covers multinomial logistic regression, Probit analysis, seasonal exponential smoothing, survival analysis, and advanced ARIMA modeling
  • Demystifies advanced techniques and helps readers apply them to real business problems

Description

  • Copyright 2016
  • Dimensions: 7" x 9-1/8"
  • Pages: 272
  • Edition: 1st
  • Book
  • ISBN-10: 0-7897-5614-5
  • ISBN-13: 978-0-7897-5614-5

Accurate, practical Excel predictive analysis: powerful smoothing techniques for serious data crunchers!

In More Predictive Analytics, Microsoft Excel® MVP Conrad Carlberg shows how to use intuitive smoothing techniques to make remarkably accurate predictions. You won’t have to write a line of code--all you need is Excel and this all-new, crystal-clear tutorial.

Carlberg goes beyond his highly-praised Predictive Analytics, introducing proven methods for creating more specific, actionable forecasts. You’ll learn how to predict what customers will spend on a given product next year… project how many patients your hospital will admit next quarter… tease out the effects of seasonality (or patterns that recur over a day, year, or any other period)… distinguish real trends from mere “noise.”

Drawing on more than 20 years of experience, Carlberg helps you master powerful techniques such as autocorrelation, differencing, Holt-Winters, backcasting, polynomial regression, exponential smoothing, and multiplicative modeling.

Step by step, you’ll learn how to make the most of built-in Excel tools to gain far deeper insights from your data. To help you get better results faster, Carlberg provides downloadable Excel workbooks you can easily adapt for your own projects.

If you’re ready to make better forecasts for better decision-making, you’re ready for More Predictive Analytics.

  • Discover when and how to use smoothing instead of regression
  • Test your data for trends and seasonality
  • Compare sets of observations with the autocorrelation function
  • Analyze trended time series with Excel’s Solver and Analysis ToolPak
  • Use Holt's linear exponential smoothing to forecast the next level and trend, and extend forecasts further into the future
  • Initialize your forecasts with a solid baseline
  • Improve your initial forecasts with backcasting and optimization
  • Fully reflect simple or complex seasonal patterns in your forecasts
  • Account for sudden, unexpected changes in trends, from fads to new viral infections
  • Use range names to control complex forecasting models more easily
  • Compare additive and multiplicative models, and use the right model for each task

Downloads

Downloads

Please download the Excel spreadsheets associated with More Predictive Analytics: Microsoft Excel here.

Extras

Author's Site

Please visit the author's site here.

Sample Content

Online Sample Chapter

Predictive Analytics with Microsoft Excel: Working with Seasonal Time Series

Sample Pages

Download the sample pages (includes part of Chapter 5 and Index)

Table of Contents

1. Multinomial Logistic Regression
2. Probit Analysis
3. Seasonal Exponential Smoothing
4. Survival Analysis
5. ARIMA Models: Forecasting an Autoregressive Time Series
6. ARIMA Models: Forecasting a Moving Average Time Series
7. Seasonal ARIMA Models

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership