Adaptation of Standard Spreadsheet Software for the Analysis of DNA Sequences. (January 1998)

• Record Type: Journal Article
• Authors: McEwan, Neil R.; Gatherer, Derek
• Is Part Of: Biotechniques. Volume 24:Number 1(1998)
• Page Start: 131
• Page End: 138
• Publication Date: 1998-01
• Subjects: Biology, Experimental -- Periodicals; Molecular biology -- Periodicals; Medical technology -- Periodicals; Biology, Experimental; Medical technology; Molecular biology; Clinical Laboratory Techniques -- Periodicals; Research -- Periodicals; Medical Laboratory Science -- Periodicals; Periodicals; Electronic journals; 570
• DOI: 10.2144/98241st07
• Languages: English
• ISSNs: 0736-6205

Abstract

This paper presents use of spreadsheet software to derive various statistics on nucleotide and codon distribution and frequency from gene sequence data, including χ 2 tests and their derivatives, and proportion of nucleotides in the third position. The basic principles can be easily extended to other more complex functions. In addition, it can be used to translate a nucleic acid sequence into a protein sequence or to produce a codon usage table. This adaptation permits sequence analysis without expensive dedicated software and easy modification of the analysis according to the user's requirements. It is also ideal for introducing biological science students to the programming potential of spreadsheets.