Predictive analytics Microsoft Excel

• 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...

Full description

Bibliographic Details
Main Author: Carlberg, Conrad George
Format: eBook
Language:English
Published: Indianapolis, Ind. Que Pub. 2013
Subjects:
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
LEADER 03715nmm a2200421 u 4500
001 EB001940141
003 EBX01000000000000001103043
005 00000000000000.0
007 cr|||||||||||||||||||||
008 210123 ||| eng
020 |a 013296726X 
020 |a 9780132967266 
020 |a 0789749416 
050 4 |a HD30.27 
100 1 |a Carlberg, Conrad George 
245 0 0 |a Predictive analytics  |b Microsoft Excel  |c Conrad Carlberg 
246 3 1 |a Predictive analytics 
260 |a Indianapolis, Ind.  |b Que Pub.  |c 2013 
300 |a 1 volume  |b illustrations 
505 0 |a Building a collector -- Linear regression -- Forecasting with moving averages -- Forecasting a time series: smoothing -- Forecasting a time series: regression -- Logistic regression: the basics -- Logistic regression: further issues -- Principal components analysis -- Box-Jenkins ARIMA models -- Varimax factor rotation in excel 
653 |a Prévision commerciale / Modèles mathématiques 
653 |a Business forecasting / Mathematical models 
653 |a Business forecasting / Mathematical models / fast 
653 |a Business forecasting / Data processing / fast 
653 |a Microsoft Excel (Computer file) / http://id.loc.gov/authorities/names/n86025775 
653 |a Prévision commerciale / Informatique 
653 |a Business forecasting / Data processing 
653 |a Microsoft Excel (Computer file) / fast 
041 0 7 |a eng  |2 ISO 639-2 
989 |b OREILLY  |a O'Reilly 
500 |a Includes index 
776 |z 9780789749413 
856 4 0 |u https://learning.oreilly.com/library/view/~/9780132967266/?ar  |x Verlag  |3 Volltext 
082 0 |a 650.0285/554 
082 0 |a 330 
520 |a • 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 
520 |a 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.  
520 |a 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.