3638 44

# [其他] More Predictive Analytics: Microsoft Excel [分享]

1%

-

9

2427028 个

17359.9895

2670 点

3386 点

2491 点

443482 点

5227

52

2898 小时

2007-8-6

2020-1-27

igs816   发表于 2015-8-28 22:59:48 |显示全部楼层

More Predictive Analytics: Microsoft Excel
English | 26 Aug. 2015 | ISBN: 0789756145 | 272 Pages | EPUB | 17 MB

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

Conrad Carlberg is a nationally recognized expert on quantitative analysis, data analysis, and management with applications such as Excel, SAS, and Oracle. He holds a Ph.D. in statistics from the University of Colorado, and is a many-time recipient of Microsoft's Excel MVP designation. Since 1995, he has consulted for companies seeking to guide their business decisions by means of analytics. He has written 11 books about quantitative analysis with Excel, including Predictive Analytics: Microsoft® Excel and Statistical Analysis: Microsoft® Excel.

#### 本帖隐藏的内容

More Predictive Analytics - Microsoft Excel.rar (17.17 MB, 售价: 10 个论坛币)

fantuanxiaot + 70 + 50 + 3 + 3 + 3 精彩帖子
chengzhifu2013 + 100 + 100 + 4 + 5 + 4 精彩帖子

### 本帖被以下文库推荐

chengzhifu2013 发表于 2015-8-28 23:02:31 |显示全部楼层
 感谢分享，再接再厉！

Crsky7 发表于 2015-8-28 23:18:51 |显示全部楼层
 More Predictive Analytics: Microsoft Excel

 谢谢楼主，加油！ bjkfpiao.jimdo.com,shkfpiao.jimdo.com,gzkfpiao.jimdo.com,szkfpiao.jimdo.com,tjkfpiao.jimdo.com,hzkfpiao.jimdo.com,njkfpiao.jimdo.com,jnkfpiao.jimdo.com,cqkfpiao.jimdo.com,nbkfpiao.jimdo.com,xmkfpiao.jimdo.com,cdkfpiao.jimdo.com,whkfpiao.jimdo.com,hebkfpiao.jimdo.com,sykfpiao.jimdo.com,xakfpiao.jimdo.com,cckfpiao.jimdo.com,cskfpiao.jimdo.com,fzkfpiao.jimdo.com,zzkfpiao.jimdo.com,sjzkfpiao.jimdo.com,wlmqkfpiao.jimdo.com,tykfpiao.jimdo.com,hfkfpiao.jimdo.com,nckfpiao.jimdo.com,nnkfpiao.jimdo.com,kmkfpiao.jimdo.com,lzkfpiao.jimdo.com,qdkfpiao.jimdo.com,dlkfpiao.jimdo.com,wxkfpiao.jimdo.com,dgkfpiao.jimdo.com,szkfpiao.jimdo.com,wzkfpiao.jimdo.com,fskfpiao.jimdo.com,yzkfpiao.jimdo.com,ywkfpiao.jimdo.com,szkfpiaoo.jimdo.com,tzkfpiao.jimdo.com,tzkfpiaoo.jimdo.com,sxkfpiao.jimdo.com,jxkfpiao.jimdo.com,yzkfpiaoo.jimdo.com,xykfpiao.jimdo.com,xykfpiaoo.jimdo.com,zbkfpiao.jimdo.com,whkfpiaoo.jimdo.com,ytkfpiaoo.jimdo.com,qhdkfpiaoo.jimdo.com,tskfpiaoo.jimdo.com,btkfpiaoo.jimdo.com,eedskfpiao.jimdo.com,xzkfpiaoo.jimdo.com,czkfpiaoo.jimdo.com,whkfpiaooo.jimdo.com,qzkfpiao.jimdo.com,kfkfpiao.jimdo.com,lykfpiaoo.jimdo.com,glkfpiao.jimdo.com,hkkfpiao.jimdo.com,ljkfpiao.jimdo.com,dlkfpiaoo.jimdo.com,fskfpiaoo.jimdo.com,zhkfpiaoo.jimdo.com,zjkfpiao.jimdo.com,hzkfpiaoo.jimdo.com,zskfpiao.jimdo.com,mmkfpiaoo.jimdo.com,

pensifia 发表于 2015-8-29 06:46:13 |显示全部楼层
 Thanks for sharing

pensifia 发表于 2015-8-29 06:52:04 |显示全部楼层
 Thanks for sharing

aggiewe 发表于 2015-8-29 07:15:52 |显示全部楼层
 see................

fengyg   发表于 2015-8-29 08:26:33 |显示全部楼层
 kankan

cono_0504 发表于 2015-8-29 08:42:03 来自手机 |显示全部楼层
 悲傷麼? 发表于 2015-8-28 23:21 谢谢楼主，加油！ bjkfpiao.jimdo.com,shkfpiao.jimdo.com,gzkfpiao.jimdo.com,szkfpiao.jimdo.com,tjkf ...thinks for sharing

yaominlinbigsun 发表于 2015-8-29 11:50:56 |显示全部楼层