Biochemical Data Analysis with Spreadsheet Application

BIOCHEMICAL DATA ANALYSIS WITH SPREADSHEET APPLICATION 

A spreadsheet is a collection of data entries text, numbers, or a combination of both (alphanumeric) arranged in rows and columns used to display, manipulate, and analyze data (Atkinson et al., 1987 Diamond and Hanratty, 1997). Microsoft Excel 

The user is referred to the Microsoft Excel User s Guide or online Help for information. 

There are three types of data that can be entered in the cells of the spreadsheet number, date/time, and text. For multiple entries of serial number with constant increment, enter the initial value into the first cell, highlight the cells, and select Edit - Fill - Series. To fill multiple entries of the same value into a range, enter the value into the first cell, move the pointer to the right-hand corner of the active cell to activate fill handle (a bold crosshair), and drag it through the range. Data are edited with the usual cut, copy, and paste operations in the Edit menu and the decimal places of scientific numbers is controlled via dialog box in Format - Cells. 

Statistical functions are selected from two menus within Excel. The first approach is through the Function Wizard. Click the Function Wizard, fx to activate the Function Wizard dialog box select Statistical under the Function Category list and 

---

BIOCHEMICAL DATA ANALYSIS WITH SPREADSHEET APPLICATION... 

---