Statistical Guides: Disciplined Use of Spreadsheet Packages for Data Entry (2nd Edition: Revised for Excel 2007)
Idiomas disponibles:
Idiomas disponibles:
Fechado: febrero 2009
Autor: Statistical Services Centre
This booklet gives guidance on best practice for using Excel in an appropriate way in order to facilitate effective data entry.From the introduction: "In our guide called “Data Management Guidelines for Experimental Projects”,1 we noted that spreadsheets are commonly used for data entry because they are familiar, in widespread use and very flexible. However, we also stated, as a warning: Their very flexibility means they can result in poor data entry and management. They should thus be used with great care. Users should apply the same rigour and discipline that is obligatory with more structured data entry software. This guide is to explain what we mean by “great care” and “rigour and discipline” and hence to show how a spreadsheet package can be used effectively for data entry. In the illustrations we have used Excel 2007 as an example of a spreadsheet package, but our strategy applies equally to other spreadsheets."Part of a series of statistical guides by The University of Reading Statistical Services Centre, which were originally written as part of a contract with DFID to give guidance to research and support staff working on DFID Natural Resources projects. They provide guidelines for staff involved in the development and presentation of research projects. The guidelines are intended to help researchers to identify their biometric or statistical needs.
Guía
Statistical Guides: Approaches to the Analysis of Survey Data
A booklet giving guidance on how to approach the analysis of survey data. "This guide is concerned with some f...
Guía
Statistical Guides: Concepts Underlying the Design of Experiments
A booklet giving guidance on the key concepts of experimental design. "This guide describes the main concepts...
Guía
Statistical Guides: Data Management Guidelines for Experimental Projects
A booklet giving guidance on managing data for research projects. Planning the data management aspects of a pr...
Guía
Statistical Guides: Guidelines for Planning Effective Surveys
A booklet on planning surveys for research. The guide covers planning, when a survey is appr...
Guía
Statistical Guides: Confidence and Significance - Key Concepts of Inferential Statistics
A booklet giving an overview of inferential statistics. This includes concepts such as estimation, hypothesis...
Guía
Statistical Guides: Mixed Models and Multilevel Data Structures in Agriculture
A booklet aiming to help the reader understand what heirarchical data structures are and how they may be analy...
Guía
Statistical Guides: Modern Approaches to the Analysis of Experimental Data
A booklet giving guidance on analysis of data. It discusses the three main parts of the process: relating the...
Guía
Statistical Guides: Modern Methods of Analysis
A booklet which follows on from the guides 'Approaches to the Analysis of Survey Data' and 'Modern Approaches...
Guía
Statistical Guides: Moving on from MSTAT
From the introduction:"This guide has been written as part of our work for DFID to encourage...
Guía
Statistical Guides: On-Farm Trials – Some Biometric Guidelines
A booklet giving guidance on how to design and conduct an on-farm experiment with the participation of farmers...
Guía
Statistical Guides: One Animal Per Farm? A guide to resolving the statistical difficulties encountered by on-farm researchers working with small livestock numbers in the developing world
A short booklet addressing the specific difficulties encountered in agricultural experimentation when conducti...
Guía
Statistical Guides: Informative Presentation of Tables, Graphs and Statistics
A guide for good practice in presenting information in the form of tables, graphs and statistics.From the intr...
Guía
Statistical Guides: The Role of a Database Package for Research Projects
A booklet providing guidance on the strengths and weaknesses of sprea...
Guía
Statistical Guides: Some Basic Ideas of Sampling
From the introduction: "This booklet is about ideas needed to devise a...
Guía
Statistical Guides: The Statistical Background to ANOVA
From the introduction:"This material was first produced as the statis...
Guía
Statistical Guides: Statistical Guidelines for Natural Resources Projects
This is the first in the series of guides aimed at supporting staff involved in research projects to identify...
Guía
Statistical Guides: Using Excel for Statistics - Tips and Warnings
A booklet aimed at staff working withing research projects, providing information about using Excel for statis...