Picture 1 of 1
Stock photo
Picture 1 of 1
Stock photo
More Predictive Analytics : Microsoft Excel by Conrad Carlberg (2015, Trade Paperback)
RNA TRADE (2154)
99% positive feedback
Price:
US $57.52
ApproximatelyRM 248.91
+ $19.34 shipping
Returns:
30 days return. Buyer pays for return shipping. If you use an eBay shipping label, it will be deducted from your refund amount.
Condition:
Oops! Looks like we're having trouble connecting to our server.
Refresh your browser window to try again.
About this product
Product Identifiers
PublisherPearson Education
ISBN-100789756145
ISBN-139780789756145
eBay Product ID (ePID)208636553
Product Key Features
Number of Pages272 Pages
Publication NameMore Predictive Analytics : Microsoft Excel
LanguageEnglish
SubjectDesktop Applications / Spreadsheets, Forecasting, Statistics
Publication Year2015
TypeTextbook
Subject AreaComputers, Business & Economics
AuthorConrad Carlberg
FormatTrade Paperback
Dimensions
Item Height0.6 in
Item Weight15.3 Oz
Item Length9 in
Item Width7 in
Additional Product Features
Intended AudienceTrade
LCCN2015-941441
Dewey Edition23
IllustratedYes
Dewey Decimal005.369
Table Of Content1. 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
SynopsisThis book introduces advanced methods for solving a wide range of important analytical problems with Excel. Students will learn to create more credible, reliable forecasts -- and avoid pitfalls associated with simply "plugging" numbers into Excel's tools., Accurate, practical Excel predictive analysis: powerful smoothing techniques for serious data crunchers In More Predictive Analytics , Microsoft Excel(R) 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, 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
LC Classification NumberHD30.27.C37 2015
Be the first to write a review
