Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Predictive Analytics: Microsoft Excel

Buy
Predictive Analytics: Microsoft Excel, 9780789749413 (0789749416), Que, 2012

Predictive Analytics: Microsoft® Excel

Excel predictive analytics for serious data crunchers!

 

The movie Moneyball made predictive analytics famous: Now you can apply the same techniques to help your business win. You don’t need multimillion-dollar software: All the tools you need are available in Microsoft Excel, and all the knowledge and skills are right here, in this book!

 

Microsoft Excel MVP Conrad Carlberg shows you how to use Excel predictive analytics to solve real-world problems in areas ranging from sales and marketing to operations. Carlberg offers unprecedented insight into building powerful, credible, and reliable forecasts, showing how to gain deep insights from Excel that would be difficult to uncover with costly tools such as SAS or SPSS.

 

You’ll get an extensive collection of downloadable Excel workbooks you can easily adapt to your own unique requirements, plus VBA code–much of it open-source–to streamline several of this book’s most complex techniques.

 

Step by step, you’ll build on Excel skills you already have, learning advanced techniques that can help you increase revenue, reduce costs, and improve productivity. By mastering predictive analytics, you’ll gain a powerful competitive advantage for your company and yourself.

 

   •   Learn both the “how” and “why” of using data to make better tactical decisions

   •   Choose the right analytics technique for each problem

   •   Use Excel to capture live real-time data from diverse sources, including third-party websites

   •   Use logistic regression to predict behaviors such as “will buy” versus “won’t buy”

   •   Distinguish random data bounces from real, fundamental changes

   •   Forecast time series with smoothing and regression

   •   Construct more accurate predictions by using Solver to find maximum likelihood estimates

   •   Manage huge numbers of variables and enormous datasets with principal components analysis and Varimax factor rotation

   •   Apply ARIMA (Box-Jenkins) techniques to build better forecasts and understand their meaning

 

Category: Spreadsheets

Covers: Microsoft Office Excel

 

 

 

 

(HTML tags aren't allowed.)

Engineering the Guitar: Theory and Practice
Engineering the Guitar: Theory and Practice
Engineering the Guitar: Theory and Practice uniquely describes the mechanics of the guitar for engineers and craftsmen alike. Complete with informative illustrations, this popular musical volume describes the underlying mechanical concepts behind the guitar, supported by theory and test. A detailed description of guitar electronics paired with an...
Google Hacks: Tips & Tools for Finding and Using the World's Information
Google Hacks: Tips & Tools for Finding and Using the World's Information

Everyone knows that Google lets you search billions of web pages. But few people realize that Google also gives you hundreds of cool ways to organize and play with information.

Since we released the last edition of this bestselling book, Google has added many new features and services to its expanding...

Endoscopic Anatomy of the Third Ventricle: Microsurgical and Endoscopic Approaches
Endoscopic Anatomy of the Third Ventricle: Microsurgical and Endoscopic Approaches

An illustrated atlas of anatomical aspects important for combinations of microsurgical and endoscopic approaches. The basis for Professor Seeger’s renowned drawings has been anatomical preparations, cadaver dissections and intraoperative pictures. The correct proportions are derived by measuring the distances of anatomical landmarks of...


The Structure of Style: Algorithmic Approaches to Understanding Manner and Meaning
The Structure of Style: Algorithmic Approaches to Understanding Manner and Meaning

Style is a fundamental and ubiquitous aspect of the human experience: Everyone instantly and constantly assesses people and things according to their individual styles, academics establish careers by researching musical, artistic, or architectural styles, and entire industries maintain themselves by continuously creating and marketing new...

Inside Microsoft SharePoint 2010
Inside Microsoft SharePoint 2010

The purpose of this book is to help you design and develop custom business solutions for SharePoint 2010, which includes the two products SharePoint Foundation and SharePoint Server 2010. Our goal is to teach you how to create, debug, and deploy the fundamental building blocks such as Features, Pages, Web Parts, Site Columns, Content...

Quicken 2007 On Demand
Quicken 2007 On Demand

Learn how to make the most of the latest version of one of the most popular personal finance software applications available with Quicken 2007 On Demand. This book uses step-by-step, visual instructions to show you how to get up and running quickly using this latest version of Quicken. You...

©2018 LearnIT (support@pdfchm.net) - Privacy Policy