Energy Histogram

Guide To Making an Energy Histogram Using Pierre Auger Observatory Surface Detector Data

 

Histogram

A histogram is essentially a graphical representation of the frequency or distribution of a variable over specific intervals known as “bins”. In other words is a graph that shows how often a specific number or range of numbers comes up in a data set. This manual focuses on building a histogram that shows the frequency at which the Pierre Auger Observatory Surface Detector has recorded cosmic ray showers of certain energies.

 

Before you start you should know that:

• This set of instructions only assumes a very minimal level of proficiency with computers and Microsoft Excel. It is written mostly with teachers in mind not just as a learning tool but as a document that could be adapted for student use.
• These instructions are written using Microsoft Excel 2007 for PC. Some screens may look different in other versions.
• In order to complete the following steps you may need to install Data Analysis Tool Pack to Excel. If so you may use Microsoft Office Help options or visit this website and follow their directions.

http://www.dummies.com/how-to/content/how-to-install-the-excel-2007-analysis-toolpak.html

 

Download and organize the data

• Use the instructions in the Data Centre to download the data into an Excel file
• Go to the “Sheet 1” and “Sheet 2” tabs and rename them “Data” and “Energy Histogram” respectively. This manual will refer to these as spreadsheets. These spreadsheets are all part of the same document and will be saved as such.

First things first! In order to generate a histogram that shows anything meaningful the data must be presented in a log10 scale.
Otherwise the histogram looks like this:

This is not very informative. The axes need to be scaled appropriately so the data get better spread out among more bins.
Our data will have a power distribution so using a log scale will work just fine.

 

Calculate the log10 of the energy data

• Label a new column for your log data
  
  

  

• Type the log10 function in your new column. Apply the calculation to all the energy data
  
  

  

  
  Tip: the traditional way of applying a calculation to all cells usually involves some kind of “copy/paste” or “drag down” process that due to the large amount of data in your spreadsheet may be inconvenient. Instead try the following trick:

• Highlight the third cell of any of the other columns. For this example I will chose to use the energy column which is in E3.

• Press CTRL+SHIFT+DOWN on your keyboard. This will select every number in that column from E3 down.

• Hit CTRL+C to copy these numbers

• Select the second cell down in your “log Energy” column which is I3 in this example. Then press CTRL+V to paste the copied data in this column

• Select the first number in your “log Energy” column. This is the number that was actually calculated in Step 2.

• Press CTRL+C to copy the log function in this cell then press CTRL+SHIFT+DOWN to select every number in this column then press CTRL+V to paste the log function in every cell in this column. PRESTO you are now ready to create your histogram.

Note: Aside from speeding up the calculation process this also allows you to perform the calculations on only cells that have numbers in them.

1. Determine the minimum and maximum values in your “log Energy” column – this will help you determine your “Bin” values later

• Label two new columns in Min and Max

• Under the “Min” label type the min function then select the first value in the “log Energy” column

• Don’t close parenthesis yet! Now press CTRL+SHIFT+DOWN to select every value in this column. Press Enter.

• Repeat this process in the “Max” Column only this time use the Max function instead

1. Create your “Bins”

The “Bins” are essentially placeholders in the horizontal axis in which Excel will graph a specific range of numbers. For example this manual uses a “Bin Size” of 0.1. This means that any number between 0.1 and 0.2 will be graphed in the same column.

• For organizational purposes this guide starts the histogram the “Energy Histogram” spreadsheet. Go to this spreadsheet by clicking on the “Energy Histogram” tab created at the beginning of this manual.

• In your new sheet label a column “Bins”.

• Fill the “Bins” column with a range of numbers with reasonable increments. Since the Min and Max in this Manual’s example are -0.95713 and 1.61352 respectively we will use bin values starting at -0.9 and ending at 1.6 with 0.1 increments

Note: Choosing the right bins can be tricky depending on the minimum and maximum values of your data and the kind of data distribution desired. Experimenting with the bin values to observe differences in data distribution is recommended.

1. Find the Frequency of Occurrences

• Click on the “Data” tab in the Excel menu then click on “Data Analysis”

• From the pop up menu choose “Histogram” then click “OK”

• Click on the “Input Range” collapse box. The window will become smaller and will be awaiting your input.

• Go to the “Data” spreadsheet and select the “log Energy” data by selecting the first cell and using pressing CTRL+SHIFT+DOWN

• Click the collapse box to return to the input window.

• Click the the “Bin Range” Collapse box . This process will be similar to the Input range process.
• Go to the “Energy Histogram” spreadsheet and select the “Bin Range” numbers created in step 4.

• Click the collapse box to return to the input window.

• Click the “Output Range” Collapse box . With this you will select the cells you with the data to generate in.

• Select any reasonable cell in your “Energy Histogram” spreadsheet.

• Click the collapse box to return to the input window.
• Click “OK” . Your Frequency Range and bins should appear. This is the data that will be graphed in your histogram.

1. Generate Graphical Histogram

• Select the first value in the “Bins” column. DO NOT SELECT BOTH COLUMNS; this will cause the X axis values to be displayed incorrectly.

• Go to the “Insert” tab in Excel and Click on “Column” in the graph menu, then choose “Clustered Column” from this list. Excel should automatically generate a table.

• Your graph should look something look this

1. Insert Titles and Labels

• Click your graph to select it. Go to the “Layout” tab.

• Go to “Axis Titles”, select “Primary Horizontal Axis Title” and click on “Title Below Axis”

• Type in an appropriate name for the Horizontal Axis
• Repeat this process for the Vertical Axis
• The Title Can be typed in directly into the graph

• The amount of detail that can be observed in each axis can also be edited and it mainly depends on the size of the graph. The larger the graph the more detail can be seen. To increase the size of the graph, simply click on the bottom right corner of the graph and while holding the mouse button “drag” the corner of the graph until desired size is obtained.

• You’ll notice that you now see a larger number of “Bins” on the x axis.