楼主: igs816
3638 44

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

泰斗

1%

还不是VIP/贵宾

-

威望
9
论坛币
2427028 个
通用积分
17359.9895
学术水平
2670 点
热心指数
3386 点
信用等级
2491 点
经验
443482 点
帖子
5227
精华
52
在线时间
2898 小时
注册时间
2007-8-6
最后登录
2020-1-27

igs816 在职认证  发表于 2015-8-28 22:59:48 |显示全部楼层
zLRg880KTBOas9xhOkzQ6wi5e7QGVkDu.jpeg

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 个论坛币)



关键词:Predictive Microsoft Analytics Analytic predict Microsoft Excel

已有 2 人评分经验 论坛币 学术水平 热心指数 信用等级 收起 理由
fantuanxiaot + 70 + 50 + 3 + 3 + 3 精彩帖子
chengzhifu2013 + 100 + 100 + 4 + 5 + 4 精彩帖子

总评分: 经验 + 170  论坛币 + 150  学术水平 + 7  热心指数 + 8  信用等级 + 7   查看全部评分

本帖被以下文库推荐

stata SPSS
chengzhifu2013 发表于 2015-8-28 23:02:31 |显示全部楼层
感谢分享,再接再厉!
回复

使用道具 举报

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

使用道具 举报

悲傷麼? 发表于 2015-8-28 23:21:29 |显示全部楼层
谢谢楼主,加油!

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 |显示全部楼层
Thanks for your sharing
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 我要注册

京ICP备16021002-2号 京B2-20170662号 京公网安备 11010802022788号 论坛法律顾问:王进律师 知识产权保护声明   免责及隐私声明

GMT+8, 2020-1-28 16:33