CALL:  919-617-4041

Sample Size Calculator Excel Spreadsheet Content

  • Sample size calculator
  • Database for inspection data
  • How to randomize the samples
  • Directory of importers
  • Directory of exporters
  • Directory of producers

Sample Size Calculator

This Excel Spreadsheet TOOL was designed by Maribel Hurtado, Bob Griffin and Steve Hong for use in a recent workshop on Best Practices for Risk Management and Risk-Based Sampling held in Lima, Peru in late September, 2018. The event was sponsored by the Interamerican Institute for Cooperation in Agriculture - IICA, the cooperatively delivered by IICA, USDA-APHIS-PPQ and NAPPO. The workshop was hosted by the General Secretariat of the Andean Community – CAN.

The tool can be used to organize data derived from inspections conducted at ports, airports and border points. The formulae can be used to estimate sample sizes based on Risk-Based Sampling concepts.

Download the sample size calculator
Calculator Sample Size Calculator Maribel Hurtado, Bob Griffin and Steve Hong XLSX


Other Tools 



The intent of the training module is to assist biological control practitioners in drafting a comprehensive, well organized petition for the first release of non-indigenous biological control agents of insect pests.  RSPM 12 takes the guesswork out of what information to include in a petition, and this in turn helps reviewers quickly identify where there are gaps in our knowledge of the pest and the proposed biological control agent, as well as the risks, if any, of releasing the new agent. This module was developed by the NAPPO Biological Control Expert Group.

View now

thumb_tool_01.png The intent of this online training tool is to assist interested NAPPO stakeholders in furthering their understanding of Risk-Based Sampling as a method to conduct agricultural inspections that are technically justified (defensible) to trading partners. The module is divided into several sections and contains exercises to test the learner on their comprehension of the basic concepts. View now
1730 Varsity Drive Suite 145 Raleigh, NC 27606 USA ADMIN LOGIN 
T: 919-617-4041