BASIC STATISTICS IN EXCEL - Smart Module

<TABLE BORDER=0 WIDTH=100%> <TR> <TD ALIGN=center WIDTH=95%> <H3> INTRODUCTION TO BASIC STATISTICS IN EXCEL </H3> </TD> <TD ALIGN=right VALIGN=top> <IMG SRC="../../icons/smartnav.gif" alt="[Link Map]" usemap="#smartnav" BORDER=0 ALIGN=absmiddle WIDTH=101 HEIGHT=59> </TD> </TR> </TABLE> <map name="smartnav"> <area shape="polygon" coords="0,28,24,13,24,45,0,30" nohref> <area shape="rect" coords="26,10,50,29" ALT="begin" href="intro.htm"> <! UNIX><area shape="rect" coords="50,10,74,29" ALT="comments" href="http://www.bioss.ac.uk/cgi-bin/smart/comment"> <! PC area shape="rect" coords="50,10,74,29" ALT="comments" href="../../launch/comment.w3l"> <area shape="rect" coords="26,29,50,48" ALT="text" nohref> <area shape="rect" coords="50,29,74,48" ALT="sound" nohref> <area shape="polygon" coords="76,13,101,28,101,30,76,45" href="sl01.htm"> <area shape="default" nohref> </map> <CENTER> <img alt="line" src="../../icons/coloured.gif" WIDTH=98% HEIGHT=3> </CENTER> <BR> These notes describe some of the basic statistical operations when exploring and drawing conclusions from data using Microsoft Excel 97. <P>Excel 97 runs on any PC with a Windows 95, 98 or NT interface. A mouse or compatible pointing device is recommended. <P>Excel is an extremely powerful package, with a wide range of applications. The simplicity of both entering and manipulating data makes this a useful package for performing preliminary statistical exploration of data. <P>Some familiarity with both PCs and a Windows environment is useful although not essential. <P>If Excel is accessible from your computer then these notes can be used to best effect by opening an Excel window alongside your Web browser window and , as you move through the pages, performing the Excel operations as described in the notes. <P> <CENTER> <img alt="line" src="../../icons/coloured.gif" WIDTH=98% HEIGHT=3> </CENTER> <TABLE BORDER=0 WIDTH=100%> <TR> <TD> Author: <a href="mailto:tim@bioss.ac.uk"> T. Jackson </a> Biomathematics and Statistics Scotland <br> [and based on the handbook "Basic Statistics in Excel" by C.Davies and T. Jackson]. <br> &copy BioSS January 1999<br> </TD> <TD ALIGN=right> <a href="http://www.bioss.ac.uk" TARGET="_top"> <img src="../../icons/bioss.gif" BORDER=0 WIDTH=50 HEIGHT=58> </a> </TD> </TR> </TABLE>