| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Rand() function
Excel spreadsheets using the rand() function in Excel
2000 are not behaving the same way in Excel 2003. The distributions that were "almost-normal" are now significantly non-normal. Does anyone have a pointer to how to fix this problem ? |
|
#2
|
|||
|
|||
|
Perhaps:
The RAND function returns negative numbers in Excel 2003 http://support.microsoft.com/default...b;en-us;834520 Otherwise, RAND() in XL03 is *far* more "almost-normal" than XL00 or XL02. Description of the RAND function in Excel 2003 http://support.microsoft.com/default...b;en-us;828795 In article , "SMANDA" wrote: Excel spreadsheets using the rand() function in Excel 2000 are not behaving the same way in Excel 2003. The distributions that were "almost-normal" are now significantly non-normal. Does anyone have a pointer to how to fix this problem ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
