How do you compare to other cubers your age?

[pipkiksass]

Cool... it's coming together. Have you plotted the IQM for 30-39 year olds at the wrong place on the x-axis (~24 years)?

Once that's corrected the trend may well sort itself out.

In all honesty, the new chart was a rush job before leaving work (while I still had access to Excel!), so it's more than possible.

My data tables have IQM and age horizontally, so I copy and paste data only and transpose to allow it to be easily plotable on the same chart. What with removing a lot of the figures, that sounds like just the kind of error I might have made.

 

[Logiqx]

In all honesty, the new chart was a rush job before leaving work (while I still had access to Excel!), so it's more than possible.

My data tables have IQM and age horizontally, so I copy and paste data only and transpose to allow it to be easily plotable on the same chart. What with removing a lot of the figures, that sounds like just the kind of error I might have made.

I thought it might be something along those lines. Let's see what tomorrow brings!

 

[mark49152]

This is great stuff, thanks Pip for pulling it together.

 

[pipkiksass]

This is great stuff, thanks Pip for pulling it together.

No worries, quite literally my pleasure!

Just tried checking my errors... for the IQM values by age, I used =iferror(trimmean(range, 0.5)), ""), which copes with ages with no valid entries. Of the two spreadsheet packages I have at home, OpenOffice can't cope with 'trimmean', and Pages can't cope with either 'trimmean' or 'iferror'... Looks like it'll have to wait till I get back to work.

 

[Logiqx]

Just tried checking my errors... for the IQM values by age, I used =iferror(trimmean(range, 0.5)), ""), which copes with ages with no valid entries.

That should be fine. It will probably turn out to be a rogue cell still using "average" or the copy+paste of values.

Thanks for the nice graphs.

 

[IamWEB]

Not sure if it's too late to post.
YOLO.

Age: 19
GLOBAL average: Sub-10.5
Method: Fridrich
Gender: Male

 

[pipkiksass]

That should be fine. It will probably turn out to be a rogue cell still using "average" or the copy+paste of values

Yeah, I'm 100% confident with my formulae, I use Excel a LOT, so I'd be surprised if that were the source of the error.

Rather than delete the sup 40 times from the original sheets, with about 15 minutes left in the office, I copied two sheets and changed all of the references, deleted a load of results, pasted and transposed, then adjusted the chart data references. I'm pretty confident I know where the screwup is!

I didn't think I'd be able to make significant changes at home, but I thought I'd at least be able to open the spreadsheet. I don't think I can justify buying Excel just for making cubing spreadsheets!!!

Not sure if it's too late to post.
YOLO.

Age: 19
GLOBAL average: Sub-10.5
Method: Fridrich
Gender: Male

Nonono, please keep posting everyone. The more the merrier!

 

[bjs5890]

Age: 16
Global average: 15
Method: CFOP
Gender: Male

 

[AlexTheEmperor]

Age: 14
Global average: 15.97
Method: CFOP
Gender: Male

 

[Hssandwich]

Age: 13
Global average: sub 15
Method: CFOP
Gender: male

 

[MineKB]

Age: 13
Global Average: sub 13
Method: CFOP
Gender: Male

 

[slinky773]

Age: 15
Global Average: sub 15 (could be lower but we'll stick to that)
Method: CFOP
Gender: Male

 

[Myachii]

Age: 15
Global Average - Sub-19 (Need to practice)
Method: CFOP
Gender: Male

 

[Rocky0701]

Age: 15
Global average: 17.5
CFOP
Male

 

[ketchuphater999]

Age: 14(more like 13.9 but let's just say 14)
Global Average: sub-18
Method: CFOP
Gender: seriously? nah

 

[Rcuber123]

Age:11
Average:13.5
Method:cfop
Gender:male

 

[MM99]

Age:18
Average: Sub 18
Method: ZZ
Gender: Male
All these kids are sooo fast compared to me lol

 

[Sadiq]

What is Global average?

 

[Rcuber123]

What is Global average?

Look at the OP

 

[AlexTheEmperor]

Age: 6
Global average: sub 8
Method: CFOP/Roux/ZZ
Gender: both