European University Institute Library

More predictive analytics, Microsoft Excel, Conrad Carlberg

eng

illustrations

index present

non fiction

More predictive analytics

921134495

Conrad Carlberg

Microsoft Excel

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.--, Provided by Publisher

1. Multinomial Logistic Regression 2. Probit Analysis 3. Seasonal Exponential Smoothing 4. Survival Analysis 5. ARIMA Models: Forecasting an Autoregressive Time Series 6. ARIMA Models: Forecasting a Moving Average Time Series 7. Seasonal ARIMA Models