研究设计与统计

订阅

MedSci主页 / 所有栏目 / 研究设计与统计

Excel 2003进行时间序列分析视频

2010-12-18 MedSci原创 MedSci原创

Excel时间序列
关注

  [例]某从事汽车租赁业务的经理着手调查客户对防雪汽车的需求情况。下表是调查后得到的数据。试利用前10天调查的数据推断第10天应该储备多少辆防雪汽车以备第11天使用。（请使用指数平滑法） 防雪汽车的需求情况表 天 汽车租赁数目 天 汽车租赁数目 1 10 6 12

  [例]某从事汽车租赁业务的经理着手调查客户对防雪汽车的需求情况。下表是调查后得到的数据。试利用前10天调查的数据推断第10天应该储备多少辆防雪汽车以备第11天使用。（请使用指数平滑法） 防雪汽车的需求情况表 天 汽车租赁数目 天 汽车租赁数目 1 10 6 12 2 11 7 11 3 10 8 19 4 12 9 19 5 10 10 20 　

版权声明：
本网站所有内容来源注明为“梅斯医学”或“MedSci原创”的文字、图片和音视频资料，版权均属于梅斯医学所有。非经授权，任何媒体、网站或个人不得转载，授权转载时须注明来源为“梅斯医学”。其它来源的文章系转载文章，或“梅斯号”自媒体发布的文章，仅系出于传递更多信息之目的，本站仅负责审核内容合规，其内容不代表本站立场，本站不负责内容的准确性和版权。如果存在侵权、或不希望被转载的媒体或个人可与我们联系，我们将立即进行删除处理。
在此留言
评论区 (6)
#插入话题
  1. [GetPortalCommentsPageByObjectIdResponse(id=1958638, encodeId=7f4c1958638f9, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=31, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Wed Oct 05 13:01:00 CST 2011, time=2011-10-05, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2587, encodeId=a5e0258ea7, content=学习了,很有用, beContent=null, objectType=article, channel=null, level=null, likeNumber=58, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=9a7c41982, createdName=201005, createdTime=Sat Jul 16 12:10:00 CST 2011, time=2011-07-16, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2412, encodeId=d087241211, content=不错 ！！！, beContent=null, objectType=article, channel=null, level=null, likeNumber=122, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c56c40514, createdName=fang112, createdTime=Wed Jun 22 01:07:00 CST 2011, time=2011-06-22, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2382, encodeId=d61c238234, content=good, beContent=null, objectType=article, channel=null, level=null, likeNumber=183, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c47c38404, createdName=camelheart, createdTime=Thu Jun 16 21:04:00 CST 2011, time=2011-06-16, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2029126, encodeId=d1fd2029126dd, content=<a href='/topic/show?id=507c59556fe' target=_blank style='color:#2F92EE;'>#时间序列#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=26, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=59556, encryptionId=507c59556fe, topicName=时间序列)], attachment=null, authenticateStatus=null, createdAvatar=http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eqcyT7aQIuoYGGYr889lEiaOVWSfvMQ4d2oxhTMlWzEr6lPmg6pxzCVvPScSZrne4JFSyyPRCOxllQ/132, createdBy=416a2500064, createdName=ms3323097325231039, createdTime=Sat Nov 26 14:01:00 CST 2011, time=2011-11-26, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1970993, encodeId=07c519e0993ae, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=34, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Sun Jul 10 19:01:00 CST 2011, time=2011-07-10, status=1, ipAttribution=)]
    2011-10-05 维他命

    #CEL#

    0

  2. [GetPortalCommentsPageByObjectIdResponse(id=1958638, encodeId=7f4c1958638f9, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=31, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Wed Oct 05 13:01:00 CST 2011, time=2011-10-05, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2587, encodeId=a5e0258ea7, content=学习了,很有用, beContent=null, objectType=article, channel=null, level=null, likeNumber=58, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=9a7c41982, createdName=201005, createdTime=Sat Jul 16 12:10:00 CST 2011, time=2011-07-16, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2412, encodeId=d087241211, content=不错 ！！！, beContent=null, objectType=article, channel=null, level=null, likeNumber=122, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c56c40514, createdName=fang112, createdTime=Wed Jun 22 01:07:00 CST 2011, time=2011-06-22, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2382, encodeId=d61c238234, content=good, beContent=null, objectType=article, channel=null, level=null, likeNumber=183, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c47c38404, createdName=camelheart, createdTime=Thu Jun 16 21:04:00 CST 2011, time=2011-06-16, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2029126, encodeId=d1fd2029126dd, content=<a href='/topic/show?id=507c59556fe' target=_blank style='color:#2F92EE;'>#时间序列#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=26, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=59556, encryptionId=507c59556fe, topicName=时间序列)], attachment=null, authenticateStatus=null, createdAvatar=http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eqcyT7aQIuoYGGYr889lEiaOVWSfvMQ4d2oxhTMlWzEr6lPmg6pxzCVvPScSZrne4JFSyyPRCOxllQ/132, createdBy=416a2500064, createdName=ms3323097325231039, createdTime=Sat Nov 26 14:01:00 CST 2011, time=2011-11-26, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1970993, encodeId=07c519e0993ae, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=34, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Sun Jul 10 19:01:00 CST 2011, time=2011-07-10, status=1, ipAttribution=)]
    2011-07-16 201005

    学习了,很有用

    0

  3. [GetPortalCommentsPageByObjectIdResponse(id=1958638, encodeId=7f4c1958638f9, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=31, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Wed Oct 05 13:01:00 CST 2011, time=2011-10-05, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2587, encodeId=a5e0258ea7, content=学习了,很有用, beContent=null, objectType=article, channel=null, level=null, likeNumber=58, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=9a7c41982, createdName=201005, createdTime=Sat Jul 16 12:10:00 CST 2011, time=2011-07-16, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2412, encodeId=d087241211, content=不错 ！！！, beContent=null, objectType=article, channel=null, level=null, likeNumber=122, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c56c40514, createdName=fang112, createdTime=Wed Jun 22 01:07:00 CST 2011, time=2011-06-22, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2382, encodeId=d61c238234, content=good, beContent=null, objectType=article, channel=null, level=null, likeNumber=183, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c47c38404, createdName=camelheart, createdTime=Thu Jun 16 21:04:00 CST 2011, time=2011-06-16, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2029126, encodeId=d1fd2029126dd, content=<a href='/topic/show?id=507c59556fe' target=_blank style='color:#2F92EE;'>#时间序列#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=26, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=59556, encryptionId=507c59556fe, topicName=时间序列)], attachment=null, authenticateStatus=null, createdAvatar=http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eqcyT7aQIuoYGGYr889lEiaOVWSfvMQ4d2oxhTMlWzEr6lPmg6pxzCVvPScSZrne4JFSyyPRCOxllQ/132, createdBy=416a2500064, createdName=ms3323097325231039, createdTime=Sat Nov 26 14:01:00 CST 2011, time=2011-11-26, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1970993, encodeId=07c519e0993ae, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=34, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Sun Jul 10 19:01:00 CST 2011, time=2011-07-10, status=1, ipAttribution=)]
    2011-06-22 fang112

    不错 ！！！

    0

  4. [GetPortalCommentsPageByObjectIdResponse(id=1958638, encodeId=7f4c1958638f9, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=31, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Wed Oct 05 13:01:00 CST 2011, time=2011-10-05, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2587, encodeId=a5e0258ea7, content=学习了,很有用, beContent=null, objectType=article, channel=null, level=null, likeNumber=58, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=9a7c41982, createdName=201005, createdTime=Sat Jul 16 12:10:00 CST 2011, time=2011-07-16, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2412, encodeId=d087241211, content=不错 ！！！, beContent=null, objectType=article, channel=null, level=null, likeNumber=122, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c56c40514, createdName=fang112, createdTime=Wed Jun 22 01:07:00 CST 2011, time=2011-06-22, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2382, encodeId=d61c238234, content=good, beContent=null, objectType=article, channel=null, level=null, likeNumber=183, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c47c38404, createdName=camelheart, createdTime=Thu Jun 16 21:04:00 CST 2011, time=2011-06-16, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2029126, encodeId=d1fd2029126dd, content=<a href='/topic/show?id=507c59556fe' target=_blank style='color:#2F92EE;'>#时间序列#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=26, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=59556, encryptionId=507c59556fe, topicName=时间序列)], attachment=null, authenticateStatus=null, createdAvatar=http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eqcyT7aQIuoYGGYr889lEiaOVWSfvMQ4d2oxhTMlWzEr6lPmg6pxzCVvPScSZrne4JFSyyPRCOxllQ/132, createdBy=416a2500064, createdName=ms3323097325231039, createdTime=Sat Nov 26 14:01:00 CST 2011, time=2011-11-26, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1970993, encodeId=07c519e0993ae, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=34, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Sun Jul 10 19:01:00 CST 2011, time=2011-07-10, status=1, ipAttribution=)]
    2011-06-16 camelheart

    good

    0

  5. [GetPortalCommentsPageByObjectIdResponse(id=1958638, encodeId=7f4c1958638f9, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=31, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Wed Oct 05 13:01:00 CST 2011, time=2011-10-05, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2587, encodeId=a5e0258ea7, content=学习了,很有用, beContent=null, objectType=article, channel=null, level=null, likeNumber=58, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=9a7c41982, createdName=201005, createdTime=Sat Jul 16 12:10:00 CST 2011, time=2011-07-16, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2412, encodeId=d087241211, content=不错 ！！！, beContent=null, objectType=article, channel=null, level=null, likeNumber=122, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c56c40514, createdName=fang112, createdTime=Wed Jun 22 01:07:00 CST 2011, time=2011-06-22, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2382, encodeId=d61c238234, content=good, beContent=null, objectType=article, channel=null, level=null, likeNumber=183, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c47c38404, createdName=camelheart, createdTime=Thu Jun 16 21:04:00 CST 2011, time=2011-06-16, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2029126, encodeId=d1fd2029126dd, content=<a href='/topic/show?id=507c59556fe' target=_blank style='color:#2F92EE;'>#时间序列#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=26, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=59556, encryptionId=507c59556fe, topicName=时间序列)], attachment=null, authenticateStatus=null, createdAvatar=http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eqcyT7aQIuoYGGYr889lEiaOVWSfvMQ4d2oxhTMlWzEr6lPmg6pxzCVvPScSZrne4JFSyyPRCOxllQ/132, createdBy=416a2500064, createdName=ms3323097325231039, createdTime=Sat Nov 26 14:01:00 CST 2011, time=2011-11-26, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1970993, encodeId=07c519e0993ae, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=34, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Sun Jul 10 19:01:00 CST 2011, time=2011-07-10, status=1, ipAttribution=)]
    2011-11-26 ms3323097325231039

    #时间序列#

    0

  6. [GetPortalCommentsPageByObjectIdResponse(id=1958638, encodeId=7f4c1958638f9, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=31, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Wed Oct 05 13:01:00 CST 2011, time=2011-10-05, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2587, encodeId=a5e0258ea7, content=学习了,很有用, beContent=null, objectType=article, channel=null, level=null, likeNumber=58, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=9a7c41982, createdName=201005, createdTime=Sat Jul 16 12:10:00 CST 2011, time=2011-07-16, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2412, encodeId=d087241211, content=不错 ！！！, beContent=null, objectType=article, channel=null, level=null, likeNumber=122, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c56c40514, createdName=fang112, createdTime=Wed Jun 22 01:07:00 CST 2011, time=2011-06-22, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2382, encodeId=d61c238234, content=good, beContent=null, objectType=article, channel=null, level=null, likeNumber=183, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c47c38404, createdName=camelheart, createdTime=Thu Jun 16 21:04:00 CST 2011, time=2011-06-16, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2029126, encodeId=d1fd2029126dd, content=<a href='/topic/show?id=507c59556fe' target=_blank style='color:#2F92EE;'>#时间序列#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=26, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=59556, encryptionId=507c59556fe, topicName=时间序列)], attachment=null, authenticateStatus=null, createdAvatar=http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eqcyT7aQIuoYGGYr889lEiaOVWSfvMQ4d2oxhTMlWzEr6lPmg6pxzCVvPScSZrne4JFSyyPRCOxllQ/132, createdBy=416a2500064, createdName=ms3323097325231039, createdTime=Sat Nov 26 14:01:00 CST 2011, time=2011-11-26, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1970993, encodeId=07c519e0993ae, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=34, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Sun Jul 10 19:01:00 CST 2011, time=2011-07-10, status=1, ipAttribution=)]
    2011-07-10 fzwish20000

    #Excel#

    0

相关资讯

Excel 2003进行 多元回归分析视频

   [例]某VCD连锁店非常想知道在电视台做广告与在广播电台做广告哪种媒体更有效。它收集了连锁店各个商店月销售额（万元）数据和每月用在以上两种媒介的广告支出费用数据如下表所示。 广告支出费用数据 销售额 广播 电视 818 13 17 1101 23 37

Excel进行参数的区间估计视频

   [例]某零件加工企业生产一种螺丝钉，对某天加工的零件每隔一定时间抽出一个，共抽取12个，测得其长度（单位：mm）数据(见下表)。假定零件长度服从正态分布，试以95%的置信水平估计该企业生产的螺丝钉平均长度的置信区间。 用Excel求置信区间 序号 样本数据 1 10.94 2 11.91 3 10.91