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

2010-12-18 MedSci原创 MedSci原创

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

   [例]某VCD连锁店非常想知道在电视台做广告与在广播电台做广告哪种媒体更有效。它收集了连锁店各个商店月销售额(万元)数据和每月用在以上两种媒介的广告支出费用数据如下表所示。 广告支出费用数据 销售额 广播 电视 818 13 17 1101 23 37 781 33 30 1076 41 22 1253 22 30 836 17 21 710 24 25 684 17 25 1007 23 23 952 11 28 876 12 27 821 31 22 633 10 30 1428 32 25 1159 27 23 711 17 18 800 21 29 718 15 30 1516 34 31 752 23 16  

评论区 (3)
#插入话题
  1. [GetPortalCommentsPageByObjectIdResponse(id=1958637, encodeId=7767195863e81, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=69, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Thu May 05 03:59:00 CST 2011, time=2011-05-05, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1671670, encodeId=280a16e167073, content=<a href='/topic/show?id=c56c4051902' target=_blank style='color:#2F92EE;'>#回归分析#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=78, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=40519, encryptionId=c56c4051902, topicName=回归分析)], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=a46f26833520, createdName=cenghis, createdTime=Sat Jul 16 17:59:00 CST 2011, time=2011-07-16, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1970992, encodeId=d3d119e099264, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=75, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Sat Sep 24 04:59:00 CST 2011, time=2011-09-24, status=1, ipAttribution=)]
    2011-05-05 维他命
  2. [GetPortalCommentsPageByObjectIdResponse(id=1958637, encodeId=7767195863e81, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=69, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Thu May 05 03:59:00 CST 2011, time=2011-05-05, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1671670, encodeId=280a16e167073, content=<a href='/topic/show?id=c56c4051902' target=_blank style='color:#2F92EE;'>#回归分析#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=78, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=40519, encryptionId=c56c4051902, topicName=回归分析)], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=a46f26833520, createdName=cenghis, createdTime=Sat Jul 16 17:59:00 CST 2011, time=2011-07-16, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1970992, encodeId=d3d119e099264, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=75, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Sat Sep 24 04:59:00 CST 2011, time=2011-09-24, status=1, ipAttribution=)]
  3. [GetPortalCommentsPageByObjectIdResponse(id=1958637, encodeId=7767195863e81, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=69, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Thu May 05 03:59:00 CST 2011, time=2011-05-05, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1671670, encodeId=280a16e167073, content=<a href='/topic/show?id=c56c4051902' target=_blank style='color:#2F92EE;'>#回归分析#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=78, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=40519, encryptionId=c56c4051902, topicName=回归分析)], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=a46f26833520, createdName=cenghis, createdTime=Sat Jul 16 17:59:00 CST 2011, time=2011-07-16, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1970992, encodeId=d3d119e099264, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=75, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Sat Sep 24 04:59:00 CST 2011, time=2011-09-24, status=1, ipAttribution=)]
    2011-09-24 fzwish20000

相关资讯

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

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