Adaptation of Standard Spreadsheet Software for the Analysis of DNA Sequences

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...

Full description

Saved in:
Bibliographic Details
Main Authors: Neil R. McEwan, Derek Gatherer
Format: Article
Language:English
Published: Taylor & Francis Group 1998-01-01
Series:BioTechniques
Online Access:https://www.future-science.com/doi/10.2144/98241st07
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary: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.
ISSN:0736-6205
1940-9818