Cummulative Events per delta time

From MariachiWiki

This tutorial is designed to give you scant instructions on how to compile all the "events per delta t per week_[x].xls" files into a cummulative file. This compilation is very similar to the compilation done to create the weekly files. It is assumed that you now know how do all the steps listed in other tutorials. If you do not remember them, feel free to refer back to the other tutorials.

1. Open a new file and save it as "events per delta t.xls".

2. Title Label A1 "delta t (min)".

3. Open Open all "events per delta t per week_[x].xls" files.

4. Copy and paste Select and copy all data cells in column A ("delta t (min)") from each file and paste them into column A in the new file.

You can now close the other files.

5. Sort Select column A and sort the data via the Data menu.

6. Bins Create bins in column B starting with "2" and going in increments of 2.

7. Histogram Create a histogram of the data via the Data Analysis under the Tools menu.

8. Customize Enlarge the graph, delete the legend, adjust the fonts and scales on the axes, display the data label values, and decrease the gap width just like on all the other files.

9. Title the graph "Cummulative Events per delta t for [x] weeks" and label the x-axis "delta t (min)".

EXAMPLE

---

Back to Events per delta time per week

Back to Candice