Data management

Contents 

Data files
Multiple response questions

Data files

For the storage, manipulation and presentation and analysis of the data we need a combination of database, spreadsheet and statistical computer software packages. Microsoft Excel has been used for some of the manipulation of the data, and GenStat and Instat for data description and analysis.

Access to the Breedsurv HOUSEHOLD table can be made by opening Breedsurv, clicking the 'Database Window' icon on the Access Tool Bar, then clicking the 'Tables' tab and finally double clicking HOUSEHOLD. The same process can be repeated to retrieve the PRODCAT table. 

Each table can be saved as an Excel file by clicking 'File', then 'Export', changing the file type to Excel and clicking 'Export'. To avoid confusion later, we have saved the worksheets under the same names as the tables, so that the HOUSEHOLD table becomes the CS11HOUSEHOLD worksheet, and the PRODCAT table becomes the CS11PRODCAT worksheet