如果给定-0.1703%,-0.1340%,0.6711%,2.9697%,-1.4361%,0.4061%,0.1189%,-0.7128%,-0.4786%,-0.2044%,0.9639%,-0.8473%,-2.0821%,0.0615%,-0.6879%,0.0742%,-0.2348%,0.3716%,0.7529%,-0.4043%,0.7872%,-0.8665%-1.5512%,-0.5752%,0.4276%,1.4402%,-0.4951%,1.1567%,
来源:学生作业帮助网 编辑:六六作业网 时间:2024/09/02 02:54:27
如果给定-0.1703%,-0.1340%,0.6711%,2.9697%,-1.4361%,0.4061%,0.1189%,-0.7128%,-0.4786%,-0.2044%,0.9639%,-0.8473%,-2.0821%,0.0615%,-0.6879%,0.0742%,-0.2348%,0.3716%,0.7529%,-0.4043%,0.7872%,-0.8665%-1.5512%,-0.5752%,0.4276%,1.4402%,-0.4951%,1.1567%,
如果给定
-0.1703%,-0.1340%,0.6711%,2.9697%,-1.4361%,0.4061%,0.1189%,-0.7128%,-0.4786%,-0.2044%,0.9639%,-0.8473%,-2.0821%,0.0615%,-0.6879%,0.0742%,-0.2348%,0.3716%,0.7529%,-0.4043%,0.7872%,-0.8665%
-1.5512%,-0.5752%,0.4276%,1.4402%,-0.4951%,1.1567%,-1.0943%,0.8080%,-0.2960%,0.0742%,-0.2472%,-0.2602%,1.0559%,-1.4136%,-0.1247%,0.6617%,-0.4837%,-0.4237%,0.0501%,0.0250%,0.0500%,0.3625%,1.0587%,-0.1479%,0.6788%,0.4413%,1.1595%,0.6033%
这些数据,如何用excel计算期望值呢?不是真的需要你们真的计算,
那如果这里有36个数据,前12个是09年的,中间12个是10年的,后12个是11年的。是不是计算年期望值(E(r)Aunnual)和期望值(E(r))是一样的呢?
如果给定-0.1703%,-0.1340%,0.6711%,2.9697%,-1.4361%,0.4061%,0.1189%,-0.7128%,-0.4786%,-0.2044%,0.9639%,-0.8473%,-2.0821%,0.0615%,-0.6879%,0.0742%,-0.2348%,0.3716%,0.7529%,-0.4043%,0.7872%,-0.8665%-1.5512%,-0.5752%,0.4276%,1.4402%,-0.4951%,1.1567%,
我帮你吧,这组数据的期望值只能这样求了:期望和平均值是一样的,有两种方法
一、excel函数里有平均值这个公式
二、先求和,有这个公式,然后求数据个数,也有这个公式,这个在函数里的统计子项里呢,然后一除就行了,
是的是一样的.
期望值就是平均值,先在excel中输入函数1/50∑x(就和符号),然后输入x1,x2,.......................,x50.就OK了
1