Instructions for Excel
Analysis of Cosmic Ray Muon, Barometric Pressure, and Estimated Planetary K
- Go to:
http://pittsfordschools.org/webpages/jwillie/, then go to the Muon
down and click on the Related File: March 2003 Mendon Muon Run or Sept
18, 2003 – Feb 4, 2004 Mendon Muon Run.
the Excel file to your server folder or a disk.
- Go to
the folder or disk and open the file.
data in the file includes:
Column A – Interval: two-hour time intervals
Column B – End Date the date the data interval
Column C – End
Time the time the
interval ended (in Eastern Standard time)
Column D –
Counts the # of
muon events in that interval
Column E – Rate (Hz) the
rate of muon events (in Hz, or events/second) during the two hour interval
Column F –
estimated statistical uncertainty of the muon rate data (also in Hz)
Column G –
pres (kpas) the average
barometric pressure (in kilopascals) during the two-hour interval
Column H – k
index the Estimated
Planetary K Index as reported by the National Oceanic and Atmospheric
Administration (NOAA) for the time period
begin graphing, click on the Chart Wizard icon on the top toolbar.
on XY (Scatter) chart type and click next >.
- On Step
2 of 4 – Chart Source Data, click on the Series tab near the top.
data already appears on the graph, click the remove button under
where it says series on the lower left. Repeat this until all the data is
removed and the graph no longer appears above.
you’ve cleared the data series, click on the add tab on the
left. Three boxes will then appear
on the lower right.
on the chart icon on the right side of the X values
box. This will return you to the
data spreadsheet with a chart wizard box “floating” above it.
- While on
the spreadsheet, highlight the data that you would like to use for your
x-axis. (Note that if you highlight
the whole column by clicking the letter on top, the axis will have a huge
scale that will have to be adjusted later.
You may find it easier to simply highlight the numerical data in
question.) After you have
highlighted the data, click on the chart icon on the right side of the
floating Chart Source Data box.
the operation for the y-axis data by clicking on the icon at the right of
the Y values box, highlighting data, etc.
- If you
intend to add a second y data series, click on the add tab at left,
click the chart icon on the Y values box, and highlight
another column of data on the spreadsheet.
your axes (include units, as always), click off the legend, and finish the
graph as a new sheet. Note that at
this point, you will not be able to label more than one y-axis, if you
have more than one. You’ll have to
return to do this later.
on the graph and remove the gray background.
- If you
think there is a correlation between your variables, add a trend line,
equation, and r2 value.
adjust axis scale:
viewing the graph, click on the axis in question, and then click Format,
Selected Axis, and Scale.
Adjust the scale by changing the Minimum, and/or Maximum
add a second y-axis scale:
viewing the graph, click on one set of data points, and then click the Format
tab at the top of the page.
Click Selected Data Series, then the Axis tab. Under Plot series on, click secondary
axis, then OK.
this, click on Chart, then Chart Options, and label the
To add error bars to muon
the data points on completed graph.
Click Format, Selected Data Series, and Y Error Bars. Click on Custom at the lower
left. Click the icon on the right of the
+ box at right. Click back to the
data spreadsheet, and highlight the Sigma column. Next, click on the - box, and repeat the procedure.