Voltage Experiment

This weeks experiment was difficult for me. At first I had difficulty figuring out how the amounts were to be calculated. After a quick review, me and my group were ready to go. The experiment was to plug in a device and shake it. The energy created could power devices. We learning in class about alternate ways of receiving energy. We needed to pick a speed and shake it while counting how many shakes we were making in 30 seconds. The lab view application would calculate the voltages of energy. The next step was putting our data into an excel sheet. The number of shakes, sum of the shakes, voltages, and sum of the voltages. Here is our data.
First Attempt: we had calculated 10 shakes in 30 seconds. Then we had to do the sum of the squares. We used the formula SUMSQB1,B30 this gave us 97.38186506. The next amount was the sum of the voltages with the same formula just different squares we got 0.383325203.
Second Attempt: we had 30 shakes. The sum of the squares came out to be 97.38186506. Then the sum of the voltages came out to be 0.825472058.
Third Attempt: this attempt we had 50 shakes, the sum came out be 97.38186506, and the sum of the voltages is 53.80326587.
Fourth Attempt: we had 60 shakes, 97.38186506 is the sum of the shakes, and 72.50162075 is the sum of the voltages.
Fifth Attempt: we had 70 shakes, the sum of the shakes came out to 97.38186506 and the sum of the voltages was 58.29262387.

One thing I did notice was that the sum of the squares always came to the same number, which could have been because seconds were always 30.