开发者:上海品职教育科技有限公司 隐私政策详情

应用版本:4.2.11(IOS)|3.2.5(安卓)APP下载

勇往直前 · 2021年12月12日

请问是Z发布吗

NO.PZ2021062201000011

问题如下:

A portfolio has an expected mean return of 8% and standard deviation of 14%. The probability that its return falls between 8% and 11% is closest to:

选项:

A.

8.5%

B.

14.8%

C.

58.3%

解释:

A is correct.

P(8% ≤ Portfolio return ≤ 11%) = N(Z corresponding to 11%) – N(Z corresponding to 8%).

For the first term, NORM.S.DIST(11% – 8%)/14% = 58.48%. To get the second term immediately, note that 8% is the mean, and for the normal distribution, 50% of the probability lies on either side of the mean.

Therefore, N(Z corresponding to 8%) must equal 50%, So, P(8% ≤ Portfolio return ≤ 11%) = 0.5848 - 0.50 = 0.0848, or approximately 8.5%.


基于下列总公式:

P(8% ≤ Portfolio return ≤ 11%) = N(Z corresponding to 11%) – N(Z corresponding to 8%).

本公式第一部分:利用excel中NORM.S.DIST这个公式,我们解得:58.48%

本公式第二部分,8%为均值,且为正态分布,则50%的概率落在均值两侧,所以,N(Z corresponding to 8%)=50%,

带入总公式:P(8% ≤ Portfolio return ≤ 11%) = 0.5848 - 0.50 = 0.0848 = 8.5%

老师,不知道从何入手,这是哪个知识点.考试中无法用Excel,怎么解答呢? 请问可以详细列一下解题步骤吗?谢谢
1 个答案
已采纳答案

星星_品职助教 · 2021年12月13日

同学你好,

做题并不需要用Excel公式,考试也不会给。

这道题要求11%和8%之间的概率,即P(X=11%)-P(X=8%)。非正态分布不能查表,所以要做标准化转化。

利用下图正态分布标准化的公式,对于P(X=11%)进行标准化后得到Z(0.2143),查表得到对应面积在58.32%和58.71%之间;对P(X=8%)标准化后得到Z(0)。对应面积即为50%。

所以最终结果在 58.71%-50%=8.71%,和58.32%-50%=8.32%之间,即选择A选项对应的8.5%。

  • 1

    回答
  • 0

    关注
  • 519

    浏览
相关问题

NO.PZ2021062201000011问题如下 A portfolio hexpectemereturn of 8% anstanrviation of 14%. The probability thits return falls between 8% an11% is closest to: A.8.5%B.14.8%C.58.3% A is correct.P(8%≤ Portfolio return ≤ 11%) = N(Z corresponng to 11%) – N(Z corresponngto 8%). For the firstterm, NORM.S.ST(11% – 8%)/14% = 58.48%. To get the secontermimmeately, note th8% is the mean, anfor the normstribution, 50% ofthe probability lies on either si of the mean.Therefore, N(Z corresponng to 8%) must equ50%, So, P(8% ≤Portfolio return ≤ 11%) = 0.5848 - 0.50 = 0.0848, or approximately 8.5%.基于下列总公式 P(8% ≤ Portfolio return ≤ 11%) = N(Z corresponng to 11%) – N(Z corresponng to 8%). 本公式第一部分利用excel中NORM.S.ST这个公式,我们解得58.48%本公式第二部分,8%为均值,且为正态分布,则50%的概率落在均值两侧,所以,N(Z corresponng to 8%)=50%,带入总公式P(8% ≤ Portfolio return ≤ 11%) = 0.5848 - 0.50 = 0.0848 = 8.5% 老师以后在出这种用到Criticvalue(不是常见的1,1.65,1.98,和2.58时?) 值的时候,可不可以附上对应的概率呢?

2023-08-06 22:50 1 · 回答

NO.PZ2021062201000011 问题如下 A portfolio hexpectemereturn of 8% anstanrviation of 14%. The probability thits return falls between 8% an11% is closest to: A.8.5% B.14.8% C.58.3% A is correct.P(8%≤ Portfolio return ≤ 11%) = N(Z corresponng to 11%) – N(Z corresponngto 8%). For the firstterm, NORM.S.ST(11% – 8%)/14% = 58.48%. To get the secontermimmeately, note th8% is the mean, anfor the normstribution, 50% ofthe probability lies on either si of the mean.Therefore, N(Z corresponng to 8%) must equ50%, So, P(8% ≤Portfolio return ≤ 11%) = 0.5848 - 0.50 = 0.0848, or approximately 8.5%.基于下列总公式 P(8% ≤ Portfolio return ≤ 11%) = N(Z corresponng to 11%) – N(Z corresponng to 8%). 本公式第一部分利用excel中NORM.S.ST这个公式,我们解得58.48%本公式第二部分,8%为均值,且为正态分布,则50%的概率落在均值两侧,所以,N(Z corresponng to 8%)=50%,带入总公式P(8% ≤ Portfolio return ≤ 11%) = 0.5848 - 0.50 = 0.0848 = 8.5% 考察的哪部分的知识点

2023-03-20 18:06 1 · 回答

NO.PZ2021062201000011 问题如下 A portfolio hexpectemereturn of 8% anstanrviation of 14%. The probability thits return falls between 8% an11% is closest to: A.8.5% B.14.8% C.58.3% A is correct.P(8%≤ Portfolio return ≤ 11%) = N(Z corresponng to 11%) – N(Z corresponngto 8%). For the firstterm, NORM.S.ST(11% – 8%)/14% = 58.48%. To get the secontermimmeately, note th8% is the mean, anfor the normstribution, 50% ofthe probability lies on either si of the mean.Therefore, N(Z corresponng to 8%) must equ50%, So, P(8% ≤Portfolio return ≤ 11%) = 0.5848 - 0.50 = 0.0848, or approximately 8.5%.基于下列总公式 P(8% ≤ Portfolio return ≤ 11%) = N(Z corresponng to 11%) – N(Z corresponng to 8%). 本公式第一部分利用excel中NORM.S.ST这个公式,我们解得58.48%本公式第二部分,8%为均值,且为正态分布,则50%的概率落在均值两侧,所以,N(Z corresponng to 8%)=50%,带入总公式P(8% ≤ Portfolio return ≤ 11%) = 0.5848 - 0.50 = 0.0848 = 8.5% 我的确算出来了p(o z 0.214), 但是对应的那个表在哪里可以看到啊?

2022-11-21 07:11 1 · 回答

NO.PZ2021062201000011 问题如下 A portfolio hexpectemereturn of 8% anstanrviation of 14%. The probability thits return falls between 8% an11% is closest to: A.8.5% B.14.8% C.58.3% A is correct.P(8%≤ Portfolio return ≤ 11%) = N(Z corresponng to 11%) – N(Z corresponngto 8%). For the firstterm, NORM.S.ST(11% – 8%)/14% = 58.48%. To get the secontermimmeately, note th8% is the mean, anfor the normstribution, 50% ofthe probability lies on either si of the mean.Therefore, N(Z corresponng to 8%) must equ50%, So, P(8% ≤Portfolio return ≤ 11%) = 0.5848 - 0.50 = 0.0848, or approximately 8.5%.基于下列总公式 P(8% ≤ Portfolio return ≤ 11%) = N(Z corresponng to 11%) – N(Z corresponng to 8%). 本公式第一部分利用excel中NORM.S.ST这个公式,我们解得58.48%本公式第二部分,8%为均值,且为正态分布,则50%的概率落在均值两侧,所以,N(Z corresponng to 8%)=50%,带入总公式P(8% ≤ Portfolio return ≤ 11%) = 0.5848 - 0.50 = 0.0848 = 8.5% 讲义给的例子是说了相反的情况即标准化的情况,所以不需要查表,对吗?

2022-07-19 08:47 1 · 回答

NO.PZ2021062201000011问题如下 A portfolio hexpectemereturn of 8% anstanrviation of 14%. The probability thits return falls between 8% an11% is closest to: A.8.5%B.14.8%C.58.3% A is correct.P(8%≤ Portfolio return ≤ 11%) = N(Z corresponng to 11%) – N(Z corresponngto 8%). For the firstterm, NORM.S.ST(11% – 8%)/14% = 58.48%. To get the secontermimmeately, note th8% is the mean, anfor the normstribution, 50% ofthe probability lies on either si of the mean.Therefore, N(Z corresponng to 8%) must equ50%, So, P(8% ≤Portfolio return ≤ 11%) = 0.5848 - 0.50 = 0.0848, or approximately 8.5%.基于下列总公式 P(8% ≤ Portfolio return ≤ 11%) = N(Z corresponng to 11%) – N(Z corresponng to 8%). 本公式第一部分利用excel中NORM.S.ST这个公式,我们解得58.48%本公式第二部分,8%为均值,且为正态分布,则50%的概率落在均值两侧,所以,N(Z corresponng to 8%)=50%,带入总公式P(8% ≤ Portfolio return ≤ 11%) = 0.5848 - 0.50 = 0.0848 = 8.5% 我算出来的结果是0.0832,选择了一个接近的数值。① 标准化,是要求0<Z<0.21的概率。0.21是通过(11-8)/14得来的。然后查0.21的正态分布数等于0.5832,减去0.5,得到的0.0832。请问,问题出在哪里呢?

2022-07-07 14:30 1 · 回答