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.
- To start it up, type gnumeric
-
To load the data, click on the File menu in the top left of the
menu bar in the gnumeric spread sheet. Select the Open
option and load the spreadsheet
called Radon.gnumeric.
which is found in the folder data
-
Be sure to save your work in your own work area.
Use the Save As option to do this.
You will not be permitted to save the spreadsheet in the data
folder.
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,
- highlight the region to contain the counts,
- in the first of these cells type in =frequency(data array, endpoint array).
- hit CTRL - SHIFT - ENTER together
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.
- The count function gives the number of nonempty cells.
You can use it to find out how many sampled units are
in each county.
- The if function
can be used to create 0-1 values. It is found in the
list of logical functions.
If you click on cell CN3 and enter if(B3>4,1,0).
This will yield a 1 if cell B3 is greater than 4 and 0 otherwise.
You can copy and paste this cell into cells CN4:CN124, and paste
into rows CO through FV to turn all of the radon measurements
into 0-1 values. The sum of these will tell you how many
houses in the sample exceed 4.
- 2/14/03 To find the number of houses sampled in each
county use the count function.
- To make a new sheet, select Edit and choose the option
New Sheet.
Then paste into this new sheet just those numbers that you
want to use in your final report. To do this use the
Paste Special option under the Edit menu, and
select the As Value option to paste the numbers
as values rather than as references to calculations.
To paste a row as a column, select the Transpose
option.
- 2/14/03 Once you have reduced your computations to the
county level. Make a new spreadsheet that displays all of your
county computations. You will need to turn in this spreadsheet
as part of our report.
- To prepare data to be loaded into the colorMap function in
R do the following:
- the single row/column of 87 numbers that you will
use to color the map into a new sheet. (See above how to do this)
Be sure to make it a column of 87 numbers.
- Check to see that ou have all valid numbers in your column.
(NA is acceptable as a number).
- Check to see that there is no extraneous text in the sheet --
just our 87 numbers.
- Save this sheet, using the Save As option under File
to save as a text file. Be sure to save only this sheet,
not all of the sheets in your workbook. Give it a name, such as
myData.
- Refer to the other worksheet for instructions on loading the
data into R for the colorMap function.