如果给定-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/01 16:26:52
![如果给定-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%,](/uploads/image/z/2732367-39-7.jpg?t=%E5%A6%82%E6%9E%9C%E7%BB%99%E5%AE%9A-0.1703%25%2C-0.1340%25%2C0.6711%25%2C2.9697%25%2C-1.4361%25%2C0.4061%25%2C0.1189%25%2C-0.7128%25%2C-0.4786%25%2C-0.2044%25%2C0.9639%25%2C-0.8473%25%2C-2.0821%25%2C0.0615%25%2C-0.6879%25%2C0.0742%25%2C-0.2348%25%2C0.3716%25%2C0.7529%25%2C-0.4043%25%2C0.7872%25%2C-0.8665%25-1.5512%25%2C-0.5752%25%2C0.4276%25%2C1.4402%25%2C-0.4951%25%2C1.1567%25%2C)
如果给定-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