More Predictive Analytics : Microsoft Excel /

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

Full description

Bibliographic Details
Main Author: Carlberg, Conrad (Author)
Corporate Author: Safari, an O'Reilly Media Company
Format: eBook
Language:English
Published: Que, 2015.
Edition:1st edition.
Subjects:
Online Access:Connect to this electronic resource

MARC

Tag First Indicator Second Indicator Subfields
LEADER 00000uam a2200000 a 4500
001 in00004253821
005 20260122211307.6
006 m o d
007 cr cn
008 250615s2015 xx o eng
020 |z 9780134070902 
020 |z 0134070909 
020 |z 9780789756145 
020 |z 0789756145 
035 |a (CaSebORM)9780134070902 
040 |d UtOrBLW 
041 0 |a eng 
100 1 |a Carlberg, Conrad,  |e author. 
245 1 0 |a More Predictive Analytics :  |b Microsoft Excel /  |c Carlberg, Conrad. 
250 |a 1st edition. 
264 1 |b Que,  |c 2015. 
300 |a 1 online resource (272 pages) 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
347 |a text file 
520 |a  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 
533 |a Electronic reproduction.  |b Boston, MA :  |c Safari,  |n Available via World Wide Web.  |d 2016. 
538 |a Mode of access: World Wide Web. 
542 |f Copyright © 2016 by Que Publishing  |g 2016 
588 |a Online resource; Title from title page (viewed August 20, 2015) 
500 |a Electronic resource. 
655 7 |a Electronic books.  |2 local 
710 2 |a Safari, an O'Reilly Media Company. 
856 4 0 |u https://proxy.library.tamu.edu/login?url=https://go.oreilly.com/TAMU/library/view/-/9780134070902/?ar  |z Connect to this electronic resource  |t 0 
999 f f |s fb5dc993-0186-34ea-81fa-008865c672f0  |i 203b886a-ccf0-3100-b8a5-9b07a9688ccf  |t 0 
952 f f |a Texas A&M University  |b College Station  |c Electronic Resources  |s www_evans  |d Available Online  |t 0  |h No information provided 
998 f f |t 0  |l Available Online