| Click below to download the
example spreadsheet. |
Here are last year's scholars at
work with the Small Radio Telescope, preparing to take the data in that
spreadsheet: |
And here is the rotation curve
of our Galaxy that they produced: |
 |
 |
 |
Can you use Excel's built-in help, or an online tutorial, to learn how to average the numbers between rows 5 and 36, in each of columns G through BE, and histogram the results? That's the first step in getting one point on the plot shown here, and a good introduction to using spreadsheet data.