Yay! I get to do some real math. I totally feel like a real engineer and a real scientist this morning. I have a huge amount of work to do over the next few days on my little research policy paper. It was, as I wrote, well reviewed. But one of the reviewers complained that my simulated data was normally distributed, and that I should instead use lognormal data. But that mucks up my statistics.
Normal data is great. Most stuff is normal in the real world, and it’s easy to hypothesis test it. Two samples of data. Are the means the same, or not? Easy peasy. Lognormal data isn’t so easy, because the same tests don’t work. For testing normal data, you can use either the Z test or Student’s t test. But for lognormal data, I’m not aware of any standard test, and certainly nothing that’s already built for me.
So I did what any lost engineer would do. I went to Prof. Google (after asking on twitter to crickets). And I found this:
Which is exactly what I need. So now, I get to redo all my data, implement the above in Excel, and rerun all my tests. Should be glorious. As long as my result holds under the new distribution. We shall see.
But this is how science is done. Assertion, rebuttal, research, revision, response. And it’s exciting to do it.
 Abdollahnezhad K, Babanezhad M, Jafari AA, Inference on Difference of Means of two Log-Normal Distributions A Generalized Approach, Journal of Statistical and Econometric Methods, vol.1, no.2, 2012, 125-131