More Predictive Analytics

Microsoft Excel

Business & Finance, Economics, Statistics, Nonfiction, Computers, Application Software, Spreadsheets, Financial Applications
Cover of the book More Predictive Analytics by Conrad Carlberg, Pearson Education
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Conrad Carlberg ISBN: 9780134070933
Publisher: Pearson Education Publication: August 18, 2015
Imprint: Que Publishing Language: English
Author: Conrad Carlberg
ISBN: 9780134070933
Publisher: Pearson Education
Publication: August 18, 2015
Imprint: Que Publishing
Language: English

 

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

 

View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

 

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.

 

More books from Pearson Education

Cover of the book The Official Ubuntu Book by Conrad Carlberg
Cover of the book Special Edition Using Microsoft Office Home and Student 2007 by Conrad Carlberg
Cover of the book Absolute Beginner's Guide to WordPerfect X3 by Conrad Carlberg
Cover of the book Calvinize by Conrad Carlberg
Cover of the book Wealth by Conrad Carlberg
Cover of the book Canon EOS 7D Mark II by Conrad Carlberg
Cover of the book Profiting from the Data Economy by Conrad Carlberg
Cover of the book How to be Assertive In Any Situation by Conrad Carlberg
Cover of the book Tapping into Unstructured Data by Conrad Carlberg
Cover of the book Windows 7 Inside Out by Conrad Carlberg
Cover of the book Three Wishes by Conrad Carlberg
Cover of the book HTML Manual of Style: A Clear, Concise Reference for Hypertext Markup Language (including HTML5) by Conrad Carlberg
Cover of the book Designing for Interaction by Conrad Carlberg
Cover of the book How to Grow Your Business- For Entrepreneurs by Conrad Carlberg
Cover of the book Professional Portrait Retouching Techniques for Photographers Using Photoshop by Conrad Carlberg
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy