Random Number Generation, Monte Carlo Analysis


J

Jeremy

I'm doing a simple Monte Carlo Analysis.

When doing a random number generation, under Data Analysis, I get
different results from the rest of my class (using PCs). Any ideas why and is
it a problem in the end?

In general what problems may I encounter using Mac instead of PC like the
rest of my classmates?

Thanks for the Help.

-Jeremy
MBA 2006
 
Ad

Advertisements

B

Bob Greenblatt

I'm doing a simple Monte Carlo Analysis.

When doing a random number generation, under Data Analysis, I get
different results from the rest of my class (using PCs). Any ideas why and is
it a problem in the end?

In general what problems may I encounter using Mac instead of PC like the
rest of my classmates?

Thanks for the Help.

-Jeremy
MBA 2006
Without knowing for sure which versions of Excel are involved, your
different answers are likely because yours are right and theirs are not.
There were a lot of changes made to the statistical functions (especially
RAND) for Macintosh Excel 2004 which corrected many ancient problems. I
believe that the corresponding changes have only been made for Windows Excel
2003 by means of a service pack. (Somebody will undoubtedly jump in here
with the correct version ids.)
 
G

Guest

I'm using Office vX. Would you recommend I upgrade to Office 2004?

-J
 
J

Jeremy

I'm using Office v.X. Will I benefit by upgrading to Office 2004. I'll be using
Excel quite frequently for stats classes.
 
M

Michael R Middleton

Jeremy -
I'm doing a simple Monte Carlo Analysis. When doing a random number
generation, under Data Analysis, I get different results from the rest of my
class (using PCs). Any ideas why ... <

Maybe you're specifying a "Random Seed" that's different from theirs.

- Mike

www.mikemiddleton.com
 
G

Guest

I'm using the same seed number, so I'm stumped.


-----Original Message-----
Jeremy -

generation, under Data Analysis, I get different results from the rest of my
class (using PCs). Any ideas why ... <

Maybe you're specifying a "Random Seed" that's different from theirs.

- Mike

www.mikemiddleton.com


.
 
Ad

Advertisements

S

strawberryshortcake977

تحليل عددى : معادله الغير خطيه...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top