ebooks and download videos Search All  Title  Author 
Home / Nonfiction / Business & Economics / Statistics

More Predictive Analytics: Microsoft Excel

| £26.66 | €29.98 | Ca$43.24 | Au$42.68
by Conrad Carlberg
What is this?DRM-EPUB by download  |  $31.99
What is this?DRM-PDF by download  |  $31.99
add to wish list
More Predictive Analytics: Microsoft Excel by Conrad Carlberg

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

To view this DRM protected ebook on your desktop or laptop you will need to have Adobe Digital Editions installed. It is a free software. We also strongly recommend that you sign up for an AdobeID at the Adobe website. For more details please see FAQ 1&2. To view this ebook on an iPhone, iPad or Android mobile device you will need the Adobe Digital Editions app, or BlueFire Reader or Txtr app. These are free, too. For more details see this article.

SHARE  Share by Email  Share on Facebook  Share on Twitter  Share on Linked In  Share on Delicious
or call in the US toll free 1-888-866-9150 product ID: 767733

Ebook Details
Pages: 336
Size: 17.1 MB
Publisher: Que Publishing
Date published:   2015
ISBN: 9780134070933 (DRM-EPUB)
9780134070919 (DRM-PDF)

DRM Settings
Copying:of 30 selections every 30 days allowed
Printing:of 30 pages every 30 days allowed
Read Aloud:  allowed

Territory Restrictions
This ebook will NOT be sold to customers with a billing address in:
Afghanistan, Algeria, Belarus, Bosnia and Herzegowina, Congo, Congo (The Democratic Republic of the), Cote D'Ivoire, Cuba, Indonesia, Iran (Islamic Republic of), Iraq, Korea (Democratic People's Republic of), Liberia, Libyan Arab Jamahiriya, Macedonia (The Former Yugoslav Republic of), Myanmar, Nigeria, Sudan, Syrian Arab Republic, Zimbabwe

This product is listed in the following categories:

Nonfiction > Computers > Spreadsheets
Nonfiction > Business & Economics > Statistics

This author has products in the following categories:

Nonfiction > Computers > Financial Applications
Nonfiction > Business & Economics > Accounting
Nonfiction > Computers > Digital Media > Desktop Publishing
Nonfiction > Computers > Spreadsheets
Nonfiction > Business & Economics > Statistics
Nonfiction > Business & Economics > Finance
Nonfiction > Computers > Data Processing
Nonfiction > Business & Economics > Accounting > Financial
Nonfiction > Computers > Mathematical & Statistical Software

If you find anything wrong with this product listing, perhaps the description is wrong, the author is incorrect, or it is listed in the wrong category, then please contact us. We will promptly address your feedback.

Submit 5 page SummaryWhat is this?

© 2016