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  

版权声明:
本网站所有内容来源注明为“梅斯医学”或“MedSci原创”的文字、图片和音视频资料,版权均属于梅斯医学所有。非经授权,任何媒体、网站或个人不得转载,授权转载时须注明来源为“梅斯医学”。其它来源的文章系转载文章,或“梅斯号”自媒体发布的文章,仅系出于传递更多信息之目的,本站仅负责审核内容合规,其内容不代表本站立场,本站不负责内容的准确性和版权。如果存在侵权、或不希望被转载的媒体或个人可与我们联系,我们将立即进行删除处理。
在此留言
评论区 (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=35, 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=35, 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=35, 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=35, 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=35, 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=35, 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=35, 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=35, 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=35, 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