I never said you were wrong about it (the number of competitors, or cubing) growing. But you didn't just say that. You said stuff about the growth of the growth, and even about the growth of the growth of the growth. And I pointed out that you're wrong about those. You're also wrong about the number of events (as well as about the number of competitions, in case that's what you actually meant).
Why don't you show us your statistics on which you based your statements? Then we can maybe find the problem. I'm not just gonna guess what you did.
Edit: Oh well, here's mine regarding your "the difference in growth is getting bigger":
[TABLE="class:grid,align:left"]
[TR][TD]Year[/TD][TD]Competitors[/TD][TD]Growth[/TD][TD]Difference
in growth[/TD][TD]How much the
difference
in growth
got bigger[/TD][/TR]
[TR][TD="align:right"]1982[/TD][TD="align:right"]19[/TD][TD][/TD][TD][/TD][TD][/TD][/TR]
[TR][TD="align:right"]2003[/TD][TD="align:right"]90[/TD][TD="align:right"]71.0[/TD][TD][/TD][TD][/TD][/TR]
[TR][TD="align:right"]2004[/TD][TD="align:right"]205[/TD][TD="align:right"]115.0[/TD][TD="align:right"]44.0[/TD][TD][/TD][/TR]
[TR][TD="align:right"]2005[/TD][TD="align:right"]548[/TD][TD="align:right"]343.0[/TD][TD="align:right"]228.0[/TD][TD="align:right"]184.0[/TD][/TR]
[TR][TD="align:right"]2006[/TD][TD="align:right"]844[/TD][TD="align:right"]296.0[/TD][TD="align:right"]-47.0[/TD][TD="align:right"]-275.0[/TD][/TR]
[TR][TD="align:right"]2007[/TD][TD="align:right"]1498[/TD][TD="align:right"]654.0[/TD][TD="align:right"]358.0[/TD][TD="align:right"]405.0[/TD][/TR]
[TR][TD="align:right"]2008[/TD][TD="align:right"]3018[/TD][TD="align:right"]1520.0[/TD][TD="align:right"]866.0[/TD][TD="align:right"]508.0[/TD][/TR]
[TR][TD="align:right"]2009[/TD][TD="align:right"]5101[/TD][TD="align:right"]2083.0[/TD][TD="align:right"]563.0[/TD][TD="align:right"]-303.0[/TD][/TR]
[TR][TD="align:right"]2010[/TD][TD="align:right"]6294[/TD][TD="align:right"]1193.0[/TD][TD="align:right"]-890.0[/TD][TD="align:right"]-1453.0[/TD][/TR]
[TR][TD="align:right"]2011[/TD][TD="align:right"]7316[/TD][TD="align:right"]1022.0[/TD][TD="align:right"]-171.0[/TD][TD="align:right"]719.0[/TD][/TR]
[TR][TD="align:right"]2012[/TD][TD="align:right"]7912[/TD][TD="align:right"]596.0[/TD][TD="align:right"]-426.0[/TD][TD="align:right"]-255.0[/TD][/TR]
[TR][TD="align:right"]2013[/TD][TD="align:right"]10269[/TD][TD="align:right"]2357.0[/TD][TD="align:right"]1761.0[/TD][TD="align:right"]2187.0[/TD][/TR]
[TR][TD="align:right"]2014 (so far)[/TD][TD="align:right"]12412[/TD][TD="align:right"]2143.0[/TD][TD="align:right"]-214.0[/TD][TD="align:right"]-1975.0[/TD][/TR]
[/TABLE]
Code:
[NOPARSE]set @c := @g := @gg := @ggg := Null;
select y Year, c Competitors, g Growth, gg 'Difference\nin growth', ggg 'How much the\ndifference\nin growth\ngot bigger' from (
select y, @ggg:=gg-@gg ggg, @gg:=gg gg, @g:=g g, @c:=c c from (
select y, @gg:=g-@g gg, @g:=g g, @c:=c c from (
select y, @g:=c-@c g, @c:=c c from (
select year y, count(distinct personId) c
from Results join Competitions on id=competitionId
group by year
order by year) tmp) tmp2) tmp3) tmp4;[/NOPARSE]
Edit 2: In case you meant number of all-time competitors, i.e., including people who don't compete anymore (didn't sound like it, and it's not a good measure of the size of cubing), you're only wrong about the growth of the growth of the growth:
[TABLE="class:grid,align:left"]
[TR][TD]Until[/TD][TD]Competitors[/TD][TD]Growth[/TD][TD]Difference
in growth[/TD][TD]How much the
difference
in growth
got bigger[/TD][/TR]
[TR][TD="align:right"]1982[/TD][TD="align:right"]19[/TD][TD][/TD][TD][/TD][TD][/TD][/TR]
[TR][TD="align:right"]2003[/TD][TD="align:right"]107[/TD][TD="align:right"]88.0[/TD][TD][/TD][TD][/TD][/TR]
[TR][TD="align:right"]2004[/TD][TD="align:right"]281[/TD][TD="align:right"]174.0[/TD][TD="align:right"]86.0[/TD][TD][/TD][/TR]
[TR][TD="align:right"]2005[/TD][TD="align:right"]698[/TD][TD="align:right"]417.0[/TD][TD="align:right"]243.0[/TD][TD="align:right"]157.0[/TD][/TR]
[TR][TD="align:right"]2006[/TD][TD="align:right"]1278[/TD][TD="align:right"]580.0[/TD][TD="align:right"]163.0[/TD][TD="align:right"]-80.0[/TD][/TR]
[TR][TD="align:right"]2007[/TD][TD="align:right"]2293[/TD][TD="align:right"]1015.0[/TD][TD="align:right"]435.0[/TD][TD="align:right"]272.0[/TD][/TR]
[TR][TD="align:right"]2008[/TD][TD="align:right"]4467[/TD][TD="align:right"]2174.0[/TD][TD="align:right"]1159.0[/TD][TD="align:right"]724.0[/TD][/TR]
[TR][TD="align:right"]2009[/TD][TD="align:right"]8065[/TD][TD="align:right"]3598.0[/TD][TD="align:right"]1424.0[/TD][TD="align:right"]265.0[/TD][/TR]
[TR][TD="align:right"]2010[/TD][TD="align:right"]12052[/TD][TD="align:right"]3987.0[/TD][TD="align:right"]389.0[/TD][TD="align:right"]-1035.0[/TD][/TR]
[TR][TD="align:right"]2011[/TD][TD="align:right"]16359[/TD][TD="align:right"]4307.0[/TD][TD="align:right"]320.0[/TD][TD="align:right"]-69.0[/TD][/TR]
[TR][TD="align:right"]2012[/TD][TD="align:right"]20739[/TD][TD="align:right"]4380.0[/TD][TD="align:right"]73.0[/TD][TD="align:right"]-247.0[/TD][/TR]
[TR][TD="align:right"]2013[/TD][TD="align:right"]26907[/TD][TD="align:right"]6168.0[/TD][TD="align:right"]1788.0[/TD][TD="align:right"]1715.0[/TD][/TR]
[TR][TD="align:right"]2014 (so far)[/TD][TD="align:right"]34287[/TD][TD="align:right"]7380.0[/TD][TD="align:right"]1212.0[/TD][TD="align:right"]-576.0[/TD][/TR]
[/TABLE]
Code:
[NOPARSE]set @c := @g := @gg := @ggg := Null;
create table YearlyCompetitors
select distinct year, personId from Results join Competitions on Competitions.id=competitionId;
select y 'Until', c Competitors, g Growth, gg 'Difference\nin growth', ggg 'How much the\ndifference\nin growth\ngot bigger' from (
select y, @ggg:=gg-@gg ggg, @gg:=gg gg, @g:=g g, @c:=c c from (
select y, @gg:=g-@g gg, @g:=g g, @c:=c c from (
select y, @g:=c-@c g, @c:=c c from (
select y, count(distinct b.personId) c
from (select distinct year y from YearlyCompetitors) a, YearlyCompetitors b
WHERE b.year <= y
group by y
order by y) tmp) tmp2) tmp3) tmp4;
drop table YearlyCompetitors;[/NOPARSE]
I am only giving rough numbers on where the growth is heading. The chart doesn't seem to make any sense out of a years increase of events and competitors but you what? It doesn't matter as long as it's growing that's all we need to know and if I can have an event to return to Leeds which as you'd know has been gone for nearly a decade, and if I can being another 20 to 40 into the scene then that would be another lot adding to the total. It's clear though that it still continues to grow and as long as that carry's things are most certainly looking good.
