Search -
More Predictive Analytics: Microsoft Excel
More Predictive Analytics Microsoft Excel Author:Conrad Carlberg Organizations of all types have discovered the immense power of predictive analytics for improving decision-making and profitability. Not everyone has access to expensive predictive analytics tools, and not everyone appreciates R's challenging interface -- but virtually every business professional is comfortable with one tool that'll serve the p... more »urpose admirably: Microsoft Excel. In More Predictive Analysis: Microsoft Excel, world-renowned Excel analytics expert Conrad Carlberg takes sophisticated Excel users to the cutting-edge with predictive analytics. Going far beyond the core techniques he introduced in Predictive Analytics: Microsoft Excel, Carlberg introduces advanced methods for solving a wide range of important analytical problems with Excel: solutions covered in no competitive book. Bringing the same clarity and insight that has made him the world's most respected author on Excel analytics and statistics, Carlberg covers all this, and more: Multinomial logistic regression for applications with more than just two categorical outcomes (for example, patients exhibiting symptoms consistent with three or more possible diseases) Probit analysis for scenarios where outcome variables are distributed categorically, with people or things assigned to a few genuinely different states of nature Seasonal time series, such as home purchases and agricultural crop yields which exhibit seasonal peaks and valleys Survival analysis using curvilinear regression, including Kaplan-Meier curves and the Cox Proportional Hazards model Box-Jenkins models from start to finish: identification, estimation, diagnostics, and forecasting As always, Carlberg helps you create more credible, reliable forecasts -- and avoid pitfalls associated with simply "plugging" numbers into Excel's tools. He also provides downloadable Excel workbooks you can easily adapt to your unique requirements.« less