Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Pedro Fragoso Pires
 
Posts: n/a
Default How do I perform a Monte Carlo simulation in Excel?


  #2   Report Post  
Bernard Liengme
 
Posts: n/a
Default

What a large topic. Can you be more specific?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Pedro Fragoso Pires" <Pedro Fragoso wrote
in message ...



  #3   Report Post  
Michael R Middleton
 
Posts: n/a
Default

Pedro Fragoso Pires -

Build some kind of spreadsheet model with some uncertain inputs and an
output that depends on those uncertain inputs.

If you want to only use Excel's built-in features, use RAND and
transformations of RAND to provide random values for the uncertain inputs.
Use Excel's Data Table command to recalculate inputs and collect
corresponding output values. Summarize the output values using Excel's
Descriptive Statistics and Histogram data analysis tools, or use Excel's
worksheet functions and Chart Wizard.

If you want to use an Excel add-in to handle most of those tasks (after you
have built your own model), you could try my RiskSim add-in, with tryout
version and manual available from the "Download Free Tryout" page at
www.treeplan.com.

Or, use Crystal Ball from www.crystalball.com or @Risk from
www.palisade.com.

- Mike

www.mikemiddleton.com


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel aficionado wants to learn Access Hari Excel Discussion (Misc queries) 0 December 3rd 04 05:47 AM
Excel aficionado wants to learn Access Hari Excel Discussion (Misc queries) 0 December 3rd 04 05:45 AM
Excel user desires to learn ABC of Access Hari Excel Discussion (Misc queries) 1 December 3rd 04 02:32 AM
OPENING TWO DIFFERENT EXCEL PROGRAMS EXCEL SPREADSHEETS Excel Discussion (Misc queries) 3 December 2nd 04 11:14 PM
pivotcell object to excel 2000 Kellyc Excel Discussion (Misc queries) 0 December 1st 04 03:45 PM


All times are GMT +1. The time now is 02:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"