Courtesy of http://www.findyourfate.com/chineseastro/grid.htm
I don't know about you but I don't see much. Let's do some visualization:
|Conditional formatting in Excel. High levels are green, low levels are red.|
That looks interesting - there are diagonal strips. Let's use Matlab to check that the strips aren't there by accident. To do that we will do random permutation test and measure uniformity. To measure the uniformity we can look at the average standard deviation in a row. And for the beginning we shift each column up by the column index multiplied by integer.
|As depicted by the graph from Matlab, the maximal uniformity is reached when i=1|
To visualize the result, we can use Excel again:
|Excel plot when i=1|
This looks meaningfully. But is it significant?
Minitab didn't identify the lowest value as an outlier. Hence, over finding is not significant. This is because our test is not strong enough. Nevertheless, if we generated more permutations (that are truly random), we would conclude that our finding is significant.
And what did we find? The signs are sorted by the year. For example the difference between the rat and the dragon is four years. And they are good match. Based on our analysis of Chinese zodiac we can conclude that the hypothesized ideal age difference is in multiplies of 4 years and the worst age difference is in multiplies of 6 years.