²é¿´: 951  |  »Ø¸´: 27
µ±Ç°Ö÷ÌâÒѾ­´æµµ¡£
¡¾ÐüÉͽð±Ò¡¿»Ø´ð±¾ÌûÎÊÌ⣬×÷Õßmimimama½«ÔùËÍÄú 207 ¸ö½ð±Ò
µ±Ç°Ö»ÏÔʾÂú×ãÖ¸¶¨Ìõ¼þµÄ»ØÌû£¬µã»÷ÕâÀï²é¿´±¾»°ÌâµÄËùÓлØÌû

mimimama

½ð³æ (ÖøÃûдÊÖ)

[ÇóÖú] 217½ð±ÒÇóÖúÊýѧ¸ßÊÖ £¨ÓÐЧÆÚÖÁ21ÈÕÍíÉÏÊ®¶þµã£© лл

ÏÂÃæÌâĿ˭Äܰïæ½â´ð£¬

Â鷳д³öÏêϸ½â´ð¹ý³ÌÒÔ¼°´ð°¸£¬

лл£¬ÓÉÓÚÒªµÃ±È½Ï¼±£¬

ËùÒÔÂé·³ÂÛ̳µÄÅóÓÑÁË£¬

Ï£ÍûÓиßÊÖÕæ³Ï°ïæ½â¾ö£¬

·Ç³£¸Ð¼¤ÄãÃÇÌṩµÄ°ïÖú£¬

лл£¡

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

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

» ²ÂÄãϲ»¶

ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

miney

ÈÙÓþ°æÖ÷ (ÎÄ̳¾«Ó¢)

¿ìÀÖ´Ï´ÏÀÏÓѼÇ

Question 1 ¨C 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 ¨C 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?
ż¶û»ØÀ´¿´¿´Ë®..................
8Â¥2008-10-21 13:05:43
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
²é¿´È«²¿ 28 ¸ö»Ø´ð

4clover

½û³æ (ÎÄ̳¾«Ó¢)

emuch08Ë®Íõ

4µ±Äê¸ßÊý¿¼ÁË24·Ö
Ô­À´Èç´Ë... 4µÄÌÔ±¦Ð¡µê£ºhttp://shop58845015.taobao.com/
2Â¥2008-10-21 12:58:57
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

flybird6676

Ϊʲô»¹µÃ»¨°³µÄ±Ò±ÒÄØ£¿»¹ÊÇ·¢µ½ÎÒÐÅÏä°É£¬ÎÒ°ïÄã¿´¿´£ºwater_bluesky@sina.com
3Â¥2008-10-21 13:00:13
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

bwtren

ÈÙÓþ°æÖ÷ (ÖªÃû×÷¼Ò)

²»ÔÚ¹àË®£¬×¨ÐÄÊÔÑé

ÒýÓûØÌû:
Originally posted by 4clover at 2008-10-21 12:58:
4µ±Äê¸ßÊý¿¼ÁË24·Ö

4appleÒ²ÔÚ °¡
Èç¹û˵·¢½ð±ÒÊÇÒ»ÖÖÐÅÄÄÇô½Ó½ð±Ò¾ÍÊÇÒ»·Ý×ðÖØ¡£
4Â¥2008-10-21 13:01:00
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
²»Ó¦Öú È·¶¨»ØÌûÓ¦Öú (×¢Ò⣺ӦÖú²Å¿ÉÄܱ»½±Àø£¬µ«²»ÔÊÐí¹àË®£¬±ØÐëÌîд15¸ö×Ö·ûÒÔÉÏ)
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] 296Çóµ÷¼Á +4 www_q 2026-03-18 8/400 2026-03-20 12:12 by ѧԱ8dgXkO
[¿¼ÑÐ] Ò»Ö¾Ô¸¼ªÁÖ´óѧ²ÄÁÏѧ˶321Çóµ÷¼Á +11 Ymlll 2026-03-18 14/700 2026-03-20 10:46 by EBSD
[¿¼ÑÐ] 26µ÷¼Á/²ÄÁÏ/Ó¢Ò»Êý¶þ/×Ü·Ö289/ÒѹýAÇøÏß +8 ²½´¨¿á×Ï123 2026-03-13 8/400 2026-03-20 08:47 by xingguangj
[ÂÛÎÄͶ¸å] ÉêÇë»Ø¸åÑÓÆÚÒ»¸öÔ£¬±à¼­Í¬ÒâÁË¡£µ«ÏµÍ³ÉϵÄʱ¼äû±ä£¬¸ø±à¼­ÓÖдÓʼþÁË£¬Ã»»Ø¸´ 10+3 wangf9518 2026-03-17 4/200 2026-03-19 23:55 by babero
[¿¼ÑÐ] Ò»Ö¾Ô¸Öйúº£Ñó´óѧ£¬ÉúÎïѧ£¬301·Ö£¬Çóµ÷¼Á +5 1ËïÎò¿Õ 2026-03-17 6/300 2026-03-19 23:46 by zcl123
[¿¼ÑÐ] 081700»¯¹¤Ñ§Ë¶µ÷¼Á +3 ¡¾1¡¿ 2026-03-16 3/150 2026-03-19 23:40 by edmund7
[¿¼ÑÐ] 288Çóµ÷¼Á +15 ÓÚº£º£º£º£ 2026-03-19 15/750 2026-03-19 22:41 by ѧԱ8dgXkO
[¿¼ÑÐ] 294Çóµ÷¼Á²ÄÁÏÓ뻯¹¤×¨Ë¶ +14 ݤÎÉ­ÁÖ 2026-03-18 14/700 2026-03-19 22:38 by ѧԱ8dgXkO
[¿¼ÑÐ] 0703»¯Ñ§µ÷¼Á +5 pupcoco 2026-03-17 8/400 2026-03-19 13:58 by houyaoxu
[¿¼ÑÐ] 085600²ÄÁÏÓ뻯¹¤Çóµ÷¼Á +6 Ð÷ÐÒÓë×Ó 2026-03-17 6/300 2026-03-19 13:27 by houyaoxu
[¿¼ÑÐ] Ò»Ö¾Ô¸Öк£Ñó²ÄÁϹ¤³Ìר˶330·ÖÇóµ÷¼Á +7 С²Ä»¯±¾¿Æ 2026-03-18 7/350 2026-03-19 10:46 by Linda Hu
[¿¼ÑÐ] 330Çóµ÷¼Á +3 С²Ä»¯±¾¿Æ 2026-03-18 3/150 2026-03-18 21:55 by ÎÞи¿É»÷111
[¿¼ÑÐ] 354Çóµ÷¼Á +4 Tyoumou 2026-03-18 7/350 2026-03-18 21:45 by Tyoumou
[¿¼ÑÐ] Ò»Ö¾Ô¸ÎäÀí²ÄÁÏ305·ÖÇóµ÷¼Á +5 ÏëÉϰ¶µÄÀðÓã 2026-03-18 6/300 2026-03-18 17:53 by Î޼ʵIJÝÔ­
[¿¼ÑÐ] 303Çóµ÷¼Á +4 î£08 2026-03-17 6/300 2026-03-18 11:01 by Iveryant
[¿¼ÑÐ] Ò»Ö¾Ô¸ÄϾ©´óѧ£¬080500²ÄÁÏ¿ÆÑ§Ó빤³Ì£¬µ÷¼Á +4 Jy? 2026-03-16 4/200 2026-03-17 11:02 by gaoqiong
[¿¼ÑÐ] Ò»Ö¾Ô¸211 0703·½Ïò310·ÖÇóµ÷¼Á +3 ŬÁ¦·Ü¶·112 2026-03-15 3/150 2026-03-16 16:44 by houyaoxu
[¿¼ÑÐ] ÖпÆÔº²ÄÁÏ273Çóµ÷¼Á +4 yzydy 2026-03-15 4/200 2026-03-16 15:59 by Gaodh_82
[¿¼ÑÐ] 070303 ×Ü·Ö349Çóµ÷¼Á +3 LJY9966 2026-03-15 5/250 2026-03-16 14:24 by xwxstudy
[¿¼ÑÐ] 0703 ÎïÀí»¯Ñ§µ÷¼Á +3 ÎÒ¿ÉÒÔÉϰ¶µÄ¶Ô 2026-03-13 5/250 2026-03-16 10:50 by ÎÒ¿ÉÒÔÉϰ¶µÄ¶ÔÂ
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û