Survey Costs and Errors: User's Manual for the Lotus 1-2-3 Spreadsheet

Abstract

This report is a user's guide for a prototype spreadsheet program written in Lotus 1-2-3 (Version 3.1) to estimate survey costs and errors. Input to the spreadsheet includes basic survey parameters, underlying costs, and estimates of time needed to perform survey tasks. Users can select the survey sampling plan, method of survey administration, survey medium, and other aspects of the survey project. Output of the program is graphical. The spreadsheet was created to apply to surveys of U.S. Army recruits or prospects, but can be used in nonrecruiting survey situations as well. Appendixes contain the code necessary to build the spreadsheet. This report is the second of two reports on this project. The first (Borgida, Sullivan, McGuire, and DuBois, 1991, ARI technical Report 928) contains the technical report that discusses the recruiting process, analyses of seasonality in ongoing surveys of accessions, and a general model of survey costs and errors.

Open PDF

Document Details

Document Type
Technical Report
Publication Date
Apr 01, 1991
Accession Number
ADA243415

Entities

People

  • Dennis P. Mcguire

Organizations

  • Battelle Memorial Institute

Tags

DTIC Thesaurus Topics

  • Bulk Shipping
  • Computer Programming
  • Computer Programs
  • Computers
  • Contracts
  • Data Analysis
  • Databases
  • Instruction Manuals
  • Instructions
  • Military Research
  • Shipping
  • Social Sciences
  • Spreadsheet Software
  • Statistical Sampling
  • United States
  • User Manuals
  • Word Processors

Fields of Study

  • Mathematics

Readers

  • Computer Science.
  • Environmental Remediation and Restoration.
  • Naval Personnel Management

Technology Areas

  • AI & ML
  • AI & ML - Bayesian Inference