24小时热门版块排行榜

返回列表

当前主题已经存档。

【悬赏金币】回答本帖问题，作者mimimama将赠送您 207 个金币

当前只显示满足指定条件的回帖，点击这里查看本话题的所有回帖

mimimama

金虫 (著名写手)

应助: 22 (小学生)
金币: 2062.4
散金: 817
红花: 9
帖子: 1562
在线: 341.1小时
虫号: 436183
注册: 2007-08-25
性别: GG
专业: 系统生物学

[求助] 217金币求助数学高手（有效期至21日晚上十二点）谢谢

下面题目谁能帮忙解答，

麻烦写出详细解答过程以及答案，

谢谢，由于要得比较急，

所以麻烦论坛的朋友了，

希望有高手真诚帮忙解决，

非常感激你们提供的帮助，

谢谢！

http://www.namipan.com/d/de043b1 ... 5ee87f54ab400600000

[ Last edited by mimimama on 2008-10-21 at 19:12 ]

回复此楼

» 猜你喜欢

1楼 2008-10-21 12:57:03

已阅回复此楼关注TA 给TA发消息送TA红花 TA的回帖

miney

荣誉版主 (文坛精英)

快乐聪聪老友记

应助: 0 (幼儿园)
贵宾: 2.939
金币: 5001.5
散金: 15611
红花: 39
沙发: 184
帖子: 29554
在线: 985小时
虫号: 232099
注册: 2006-03-28
性别: MM
专业: 药物化学
管辖: 休闲灌水

Question 1 – Numerical Integration
a) Probabilities from the standard normal distribution N(0,1) function below are found in Excel using the normsdist(z) function. Choose a numerical integration technique (i.e. Simpsons rule, trapezium rule etc) to approximate the integral used to find N(2.00). How does your answer compare to the normsdist function?

Question 2 – Monte Carlo Simulation
From http://office.microsoft.com/en-us/excel/HA011118931033.aspx read the entire page, which introduces the idea of doing Monte Carlo simulation in Excel.

On two separate worksheets, complete Problem 1 and Problem 2 at the bottom of that page.

The Question:
1. A GMC dealer believes that demand for 2005 Envoys will be normally distributed with a mean of 200 and standard deviation of 30. His cost of receiving an Envoy is $25,000, and he sells an Envoy for $40,000. Half of all leftover Envoys can be sold for $30,000. He is considering ordering 200, 220, 240, 260, 280, or 300 Envoys. How many should he order?
2. A small supermarket is trying to determine how many copies of People magazine they should order each week. They believe their demand for People is governed by the following discrete random variable.
Demand Probability
15 .10
20 .20
25 .30
30 .25
35 .15
The supermarket pays $1.00 for each copy of People and sells each copy for $1.95. They can return each unsold copy of People for $0.50. How many copies of People should the store order?