|
Great Start
Hello
I have been playing with this my self. I'm working on G/U for now. I will clean up my spreadsheet and post it here. I basically used Data analysis in Excel
to give me descriptive stats one year at the time. Here is example for the last year. For H1 bar
RANGE 2008
Mean 42.77020654
Standard Error 0.425736519
Median 33
Mode 19
Standard Deviation 33.38436744
Sample Variance 1114.515989
Kurtosis 9.383841696
Skewness 2.366877386
Range 376
Minimum 1
Maximum 377
Sum 262994
Count 6149
Confidence Level(95.0%) 0.834592528
and Frequency table
Bin Frequency Cumulative %
0 25 2175 35.37%
25 50 2243 71.85%
50 75 921 86.83%
75 100 429 93.80%
100 125 193 96.94%
125 150 96 98.50%
150 175 42 99.19%
175 200 20 99.51%
200 225 13 99.72%
225 250 9 99.87%
250 275 3 99.92%
275 300 2 99.95%
300 325 2 99.98%
325 350 0 99.98%
350 375 0 99.98%
375 400 1 100.00%
More 0 100.00%
Let me know if we are on the same page here or I'm way of the base.
|