Reddit reviews Statistics for Experimenters: Design, Innovation, and Discovery, 2nd Edition

I really like statistics for experimenters for a classical statistics book. But if you're interested in finance, you probably want more time series stuff. I included an Amazon link to show what the book looks like but I think you're better off getting it somewhere else because it's expensive on Amazon.

http://www.amazon.com/Statistics-Experimenters-Design-Innovation-Discovery/dp/0471718130

I know this isn't a straight-forward answer, but I recommend reading the NIST/SEMATECH e-Handbook on Statistical Methods. It's designed for engineers and talks a lot about exploring, measuring, characterizing, and controlling processes. I have found it immensely useful. I also recommend the book Statistics for Experimenters which goes further into how one should design and run experiments and interpret the results.

I mention this because I can't tell what you are actually trying to accomplish with the data that you have collected, but looking at its form, I can't imagine there is much you can do with it.

First, every experiment will contain randomness: you can't escape it. From one run to the next, you won't get exactly the same measurements, even if you run exactly the same experiment. But by choosing appropriate runs and applying appropriate analyses to your measurements, you can determine what's a trend and what is just random chance. Also, if you're really smart about choosing your runs, you can get a lot of information without having to run many experiments, but if you are careless about designing the experiment, you may end up with a lot of data that isn't all that useful.

I recommend taking a little bit of time to understand what it is you want to accomplish and to describe that to us so that we can better help you. I can only begin to guess what you are trying to do from your description and I certainly don't comprehend it well enough to help you.