Use of a spreadsheet program for circadian analysis of biological/physiological data.

Abstract

Biological/physiological data sampled over a period of 24 h can be subjected to a mathematical analysis to determine the presence of circadian rhythmicity. Several procedures have been proposed, most being complex. To render such an analysis simpler and easy to use by non-mathematicians, we developed and tested the cosinor technique using a commonly available commercial spreadsheet (Excel). It can be used to analyze equally or unequally time-spaced data over 24 h with missing data, as well as to calculate the significance and the main limit of the resultant circadian rhythm (mesor, amplitude, acrophase and their confidence limits). Examples of its application to hourly samples of plasma cortisol and minute-by-minute rectal temperatures are shown.