inquiry, on 2012-November-24, 13:37, said:
On the 20,000 versus 250,000 front: There is this handy little principal in stats known as asymptotic convergence. You don't need a quarter million hands. As I mentioned earlier in this thread, in the case of a chi square goodness of fit test, you want the expected number of observations to be at least 5.
http://www.talkstats...Chi-Square-test
(BTW, one of the limitations with Excel is that it still works very poorly if the number of rows increases beyond 65,536)
Personally, I refuse to accept that whether the people at the club with understand or accept the results of the analysis has anything to do with the choice to run the Chi square test.
1. If you genuinely believe that you're dealing with people to are immune to logic and reasoning then you should be blowing them off from day one. When they bitch about the deals do your best to ignore them.
2. However, if you are going to go to the time and bother of analyzing the data, then you should do so to the best of your abilities. To quote Hunter S. Thompson, "If a thing like this is worth doing at all, it's worth doing right".
FWIW, I wouldn't get all bent out of shape if someone went off and analyzed the data and didn't present me with a formal hypothesis test provided that they didn't know any better. As you folks have noted, not everyone has taken a real course in statistics. If someone doesn't know any better, so be it. Use it as a learning opportunity.
I might even prefer if the basic version of the presentation didn't consider these issues. (When I present to our senior management, I don't have confidence intervals in the PowerPoint deck. However, I make damn sure that I have performed a legitimate analysis and have back up slides available because if I don't and I get called on it I'm going to look like I don't know what I'm talking about)
I find your attitude baffling: You're willing to do 99% of the work, including the real heavy lifting. However, some perverted sense of stubbornness is preventing you from actually crossing the finishing line and performing a legitimate / useful analysis.