View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
webshark webshark is offline
external usenet poster
 
Posts: 2
Default NormInv performace in Excel 2003

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