NOVEMBER

In November the group is starting to look at excel to sort and cut data. I found Tom McCauley's data set online and today I worked on trying to change the .csv into .xls on the windows computer on at Quarknet but for some reason the data set would not download no matter how I manipulated the file. I tried opening it in wordpad, or just simply changing .csv to .xls from the save as menu option. I found out a while later that if I just used my mac laptop with excel it would open just by clicking the download button. After opening up the data set, we started to sort and cut the data. We made a new column which we called (E1+E2)/M. We accomplished making the column by clicking each box in the row after putting in the equal sign, and then hitting enter. We then dragged down the box for the row, and it filled the equation in for the rest of the events. This simple task will help the group a lot as we continue to figure out where the cosmic rays are.



Now what we want to do is sort the data by this column value. Working from smallest to largest.

I noticed that when I screen captured the above image the column created just added in the date that I made the equation for the column. When I had first made the column it showed me viable numbers. Today I am going to try to fix this, and I am going to also start working on finding different ways to manipulate the excel data to give us cosmic rays. Then we can add this into many eyes with my account and we can see if it looks like what we saw with the first data we looked at at the beginning of the semester.

Here is my new screenshot that shows the actual numbers that I got from the equation of E sum/ M instead of just a date.

Now that I have completed this, I am going to play around with excel and try to think of ways to find cosmic rays by filtering the data at hand.

This new screenshot is of two columns I created in excel with equations making both phi and eta subtract each other. My idea of doing this is because the particles come in from the top of the detector and come out the bottom, so getting the sum of the two numbers should equal 0. (negative and a positive). Of course there will be a small difference because the cosmic rays don't always come down perpendicular from the detector. There is a little bit of an angle, so the difference may have a small effect. Because of this, the next step is to take the new columns and filter out the data so that we can see the cosmic rays when we plot the graph in many eyes. This is the next task I will be working on tomorrow.

Now the problem with doing what I did above is that all I am finding is the back to back muons, which means it might not be coming straight down from the detector. In order to fix this, I need to first make a cut on the phi1 and phi2 data as well as eta1 and eta2 data. For phi, the number should be around pi/2, or 1.57. There can be some leeway in this because some cosmic rays come down at a slight angle. For this, I think it would be best to filter the data. Next, we have to do the same thing with eta, but eta should be more around 0. For this, we need to look more at around 0. I would say .2 to -.2 for a filter. Doing this should give us a clearer cut, and then we can do the equations on these new columns to find the cosmic rays.

Monday: Today I have just worked on some ways to manipulate the data set. Here is a picture of sorting the data into phi1. I expanded the selection so that all the other columns went with the column I sorted. I also made a new phi1 and phi2 for which I am going to filter the data so that I can find where the cosmic rays are coming from. (1.57 is what I am going to filter around)

After sorting the data, I started with filtering the data. I took the phi1 filtered column and I made a filter. It was greater than 1.50 and less than 1.64. Doing this, I gave a little lee way for the top of the CMS detector, which is half pi, or 1.57. In doing this, I then took filtered data set, and I decided to make a new column. I made phi1phi2 sum, which is adding the two data sets together. Doing this, now all I need to do is take the new filtered phi1 and phi2, and just add them together. In the new column, I sorted the data to go in ascending order. From doing this, I can see all the particles that are around 0. This shows me that adding 1.57 to the other phi2 (hopefully -1.57) will give me a back to back particle going through the top of the detector. Now I just have to filter this data set to be close to zero, and I will find half of the phi filtered. The other half is filtering phi1 filtered into -1.57. Phi1 has both positive and negative values, so that means that it includes the particles coming out of the bottom. Because of this, I have to do the same filtering and sorting for the negative values of phi1 filtered. This is my next task.

Here is the data for the other set

Here is just phi1 being filtered and sorted. I am going to take a plot of this data on excel to see if I can get a histogram of the data.

After playing around more with the data, I just cut phi1 without moving it around, and after adding phi1 and phi2 together, I realized that I only had around 10 points. There are only a thousand events in the data set so this may make sense, but I feel that there should be more. I know that I have to do the other half, but with the points around 0, there are only five. What I might end up looking at is widening the range at which I am filtering phi to give more space for cosmic rays to come down.



Here is doing around the same thing with eta. I made a very small cut to eta since I know that the top and bottom of the detector are around 0. The filter/cut was between -.02 to .02 which still gave me 4 good cosmic muon particles. What I want to do now is to look at the event numbers to see if they are the same particles. If this is true, then we can know whether or not these are actual cosmic rays.

Event Numbers for Eta: Event Numbers for Phi:
 * 6390492 ||
 * 2209615 ||
 * 4726799 ||
 * 10049894 ||
 * 9375434 ||
 * 8373233 ||
 * 4038645 ||
 * 5916124 ||
 * 8908160 ||
 * 5283764 ||
 * 6758193 ||
 * 2038711 ||
 * 2435168 ||
 * 8204549 ||
 * 6435 ||
 * 3511348 ||
 * 1758467 ||





This is the 100,000 events.

With the new data 100,000 Lorenz Data set, I started by adding in the columns that were already in the first 1,000 data set. Here is a picture of taking the equations from the 1,000 data set and applying it to a new column for the 100,000 dimuon event. An example that I have on the picture is M1, which is not in the new data set. We realized that for the 100,000 Lorenz set, it was only 10,000 events. Now we are looking for a 100,000 set so that we can have more data to work with. Many eyes cant handle all 100,000 events, so cutting the data with our muons will help us put the data into many eyes. Another hint I found for working with excel is if you hit shift + click the last column, and then copy and paste the equation that you have put into the column, it will automatically fill in the equation into all of the columns. In doing so, I now don't have to drag and click all the way down the screen for when I have 100,000 events in excel.