Introduction to the Gnumeric Spreadsheet

The radon lab has two parts. In the first part you will use a spreadsheet to analyze your data. The spreadsheet is called gnumeric.

DNA LAB HELP

The hcmv spreadsheet contains a column of 296 palindrome locations on the HCMV DNA.

Use the frequency function to collapse these data into counts. This function has two arguments. The first is the list of data to aggreagate, and the second is the list of upper endpoints of the bins to be used in aggregating. To use the function,

The cells should then be filled with the counts of those values that fall in the intervals.

Be careful: Compute any Chi-square tests from scratch -- i.e. do not use the CHITEST function, as it may not be the appropriate one for your data.

RADON HELP

The Radon spreadsheet has a column of radon measurements for each of 87 counties in Minnesota. The county names run across the top of the sheet. Above the county names are the populations sizes for each of the counties. These are reported in hundreds.

To take the average radon level for St. Louis county, click on the cell in the 126th row and the St. Louis column (BR) of the table, i.e. click on cell BR126. Enter the calculation =average(BR3:BR124). The average should then appear in the cell. You can copy and paste this cell into other 86 cells in the 126th row to find the averages for the other counties.

Other commands that might be useful to you are count, sum, if. Read about these by clicking on the f(x) button in the menu bar.