Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have compared the speed performance of Excel 2003 vs. Excel 2000 in
generating series of normally distributed random numbers. Sub test() ActiveSheet.Range("A1") = Time() For i = 1 To 64000 ActiveSheet.Range("A" & i + 1).Value = Application.NormInv(Rnd(), 0, 1) Next i ActiveSheet.Range("B1") = Time() End Sub I get that Excel 2000 is 5.5 faster. Does anybody experiance the same problem? I wonder if the problem is due to the upgrade of the NormInv function in Excel 2003 or there is any other reason. Thanks, Michael |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 versus Excel 2003 & Excel 97-2003 fully compatible | Excel Worksheet Functions | |||
Does installing Service Packs help with Excel performace? | Excel Discussion (Misc queries) | |||
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
VBA and norminv | Excel Programming |