The workbook includes a plot of the data and two histograms (one of the entered data and the other after their logarithmic conversion), the calculation and plotting of the autocorrelation function and the Quantile-Quantile plots of the normal and lognormal distributions to help the user decide which one better represents the data. An 'Update Worksheet' button runs a Visual Basic macro to automatically update any cells and charts in the worksheet that are affected by changes in the count data. You must click on the 'Enable Macros' button in the dialog box that is displayed before the worksheet opens in Excel in order for the macro to be useable.
* Excel® is a registered trademark of Microsoft Corporation. You can get more information about Excel by visiting Microsoft's web site at: http://www.microsoft.com/
The Excel worksheet (EstimatingProbabilityOfAccidentalExtinction.xls) is available in the file format of Excel 97 through 2003 for Windows and Excel 98 through 2004 for MacOS. If you have a modern web browser you should be able to download the binary Excel file directly by clicking on the link below. If a compatible version of Excel is currently installed on your computer, double-click the icon for the EstimatingProbabilityOfAccidentalExtinction.xls file that was downloaded to open the worksheet in Excel. Be sure to click the 'Enable Macros' button in the dialog box that appears. If you are using a recent version of Excel for Windows, you may need to first reduce the security level in Tools>Macro>Security to Medium, then close and reopen the file to enable the macros.
For Windows and MacOS:![[Return to ]](../images/gif/redarrow.gif){kind=small}
Free Microsoft Excel Workbook Software
Prof. Micha Peleg
Mark D. Normand
UMass Department of Food Science
University of Massachusetts at Amherst