Events per delta time per week

From MariachiWiki

Now that you've created a histogram for the events per delta time, one for each day of the week, you will now want to combine all these graphs into one graph to display the events per delta time per week. This tutorial will instruct you how to do that.

OBJECTIVE:

To combine all the data from each graph for a whole week into one graph to display the events per delta time per week.

MATERIALS:

• Scintillator data from website

• Excel

• Excel’s Data Analysis Toolpak*

• To verify if you have the Toolpak, open Excel and click on the Tools menu. “Data Analysis” will be listed if you have it. If it is not listed, click on “Add-ins” from Tools menu and select “Analysis Toolpak” and “Analysis Toolpak – VBA” and click “ok”.

Step-By-Step How-to:

1. Open a new Excel file and save it as "events per delta t per week_[x].xls"

2. Titles In cell A1 type "delta t (min)" and in cell B1 type "bin".

3. Open Open the existing file called "number per time interval_week[x].xls"

4. Copy Select and copy all the filled cells in column F ("delta t (sort)")

5. Paste Return to your new file select cell A2 and paste the copied cells.

6. Repeat Repeat this copy and paste for all the days of the week, pasting the data in the first empty A cell.

7. Sort Select the "A" for column A and from the Data menu choose "sort. If/when a warning box comes up, choose "continue". Don't change anything in the next box and press "ok". This will sort column A from least to greatest.

8. Bins In B2 type "2". In B3 type "=B2+2". (This creates a bin width of 2 rather than 1 like the previous graphs. This gives a clearer distribution.) Click on cell B3 and drag down the small black box in the lower right corner until the last cell in column B is the even whole number just greater than the last number in column A. (If the last number in column A is 64.343, the last number in column B should be 66)

9. Histogram From the Tools menu, choose “Data Analysis” and choose “histogram” from the list. The “input range” is your data column. The “bin range” is column B, where you set up the bins. The “ouput range” is the place where you want the histogram to appear.

10. Input range Click on the small box with the red arrow for the input range. This will take you back to your worksheet. Click A2 and hold down the mouse button to select all the filled cells in column A. Click on the small box with the red arrow again to make the whole box appear again.

11. Bin range Click on the small box with the red arrow for the bin range. Click B2 and hold down the mouse button to select all the filled cells in column B. Click on the small box with the red arrow again to make the whole box appear again.

12. Output range Select “output range” and click on the small box with the red arrow for the output range. Click D1 and then click on the small box with the red arrow again to make the whole box appear again.

13. Chart You want the histogram displayed as a bar chart, so click the box to select “chart output” and click “ok”.

• If a box pops up that says "reference not valid", just click "ok". Sometimes this box appears, but other times it does not. It is not understood what this box means because clicking "ok" makes the graph with no problem.

14. Enlarge Click on the white area of the chart and grab a black corner and enlarge the graph by dragging the mouse.

15. Legend Click on the legend and delete it.

16. Format x-axis Double click on a number on the x-axis and choose the “font” tab and choose size 9 or 10 font. Choose the “scale” tab and put a “1” in each box. (This will put the scale at 1.)

17. Format y-axis Double click on a number on the y-axis. On the “patterns” tab, select “inside” for the “minor tick mark type”. On the "font" tab, select size 14 font.

18. Label and title Slowly double click on the label for the x-axis and type “delta t (min)”. Slowly double click on the title and rename it “Events per delta t per week [x]”.

19. Gap width and values Double click on one of the bars on the chart. Select the "options" tab and set the "gap width" to 100. This reduces the gap between the bars on the graph. Select the “data labels” tab and choose “value”. This will display the value for each of the bars to make it easier to read quickly if you want to know an exact number. Double click on one of the values that appears and on the “font” tab, resize it to 10 font.

20. Delete Delete the "more" bin from column D and E. This is a useless bin because there is no data in there because we set the bin range high enough to include all data points.

EXAMPLE

---

Go to next: Cummulative Events per delta time

Back to Number of Events per delta time

Back to Candice