![]() ![]() ![]() The user must also enter the number of desired iterations (repetitions). Version 2 (January 6, 2006) and later versions automatically count the number of user-entered min and max factor values (from 2 to 30). It also computes NHistBins and HistBinWidth in a slightly different manner. Version 3 (September 24, 2008) fixes a problem that would cause a "#DIV/0!" error in several places if for one or more factors the entered MinFactor and MaxFactor values were equal to each other. The pop-up comment notes from all 3 Excel workbook files are also available on this page so that you may read and/or print them before using the files. The method may be used to estimate the number of victims in spontaneous food poisoning episodes or in outbreaks caused by deliberate poisoning as in an act of bioterrorism. ![]() This allows for computing a "best guess" from this distribution's mode. Nevertheless, approximately lognormal distribution is already evident with as few as 5-6 factors. Theoretically, the distribution of the solutions should approach lognormality as the number of factors and repetitions grow. Once each influential factor is identified and its range estimated, a series of 'Fermi solutions' is generated using random values within the specified ranges. Estimating the number of victims in food poisoning outbreaks Using Excel Estimating the number of victims in food poisoning outbreaks using Excel* An Excel worksheet is used to estimate the number of cases of food poisoning based on the 'Fermi solution'.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |