TDF 2013 Spoiler Thread Analysis **No Spoiler**
RideOnTime
Posts: 4,712
Some important analysis here. What we have is the main spoiler thread for each stage. The 'substance' quotient is the proportion of views to posting. I suppose this is like talking to listening. So Stage 2 was very good at 18.4. Stage 18 was not very good at 6.9. We were all ranting at each other but no one was taking any notice...
I will be test more hypothesis soon;
Stage Posts Views Substance
1 491 8088 16.5
2 265 4883 18.4
3 278 4059 14.6
4 410 6234 15.2
5 411 5370 13.1
6 381 5968 15.7
7 266 3736 14.0
8 498 6586 13.2
9 479 6434 13.4
10 493 7796 15.8
11 712 9355 13.1
12 359 4743 13.2
13 842 9151 10.9
14 279 3210 11.5
15 932 11190 12.0 Ventoux
16 814 8588 10.6
17 661 5987 9.1
18 1408 9651 6.9 L'Alpe d Huez
19
I will be test more hypothesis soon;
Stage Posts Views Substance
1 491 8088 16.5
2 265 4883 18.4
3 278 4059 14.6
4 410 6234 15.2
5 411 5370 13.1
6 381 5968 15.7
7 266 3736 14.0
8 498 6586 13.2
9 479 6434 13.4
10 493 7796 15.8
11 712 9355 13.1
12 359 4743 13.2
13 842 9151 10.9
14 279 3210 11.5
15 932 11190 12.0 Ventoux
16 814 8588 10.6
17 661 5987 9.1
18 1408 9651 6.9 L'Alpe d Huez
19
0
Comments
-
I hope you've included house points for stage intros - the bars been set really high with this edition.The dissenter is every human being at those moments of his life when he resigns
momentarily from the herd and thinks for himself.0 -
It would be interesting to explore the issue of joining threads.
The relationship of pro-cycling comment to general banter. etc.
The impacts of visual stimulation etc.
Anyway back to Stage 19...0 -
Oh yes graphs...
Now then...0 -
I was going to do my graphs on SundayFckin' Quintana … that creep can roll, man.0
-
-
I have a graph in Excel for this data.
How do I get it up - so to speak?0 -
Screenshot, upload, link to forum.RideOnTime wrote:I have a graph in Excel for this data.
How do I get it up - so to speak?You only need two tools: WD40 and Duck Tape.
If it doesn't move and should, use the WD40.
If it shouldn't move and does, use the tape.0 -
Merging rest day with following stage skews results. Date separation required.
Pie charts, I want pie charts.0 -
Pie charts begin and end here:Alan A wrote:Merging rest day with following stage skews results. Date separation required.
Pie charts, I want pie charts.
You only need two tools: WD40 and Duck Tape.
If it doesn't move and should, use the WD40.
If it shouldn't move and does, use the tape.0 -
-
0
-
-
So to explain the chart.
For those of you with long hair. Here's the science bit.
We are taking views divided by posts as a proxy for substance - to produce a 'substance ratio'.
This is of course a very crude measure.0 -
I shall commence more detailed analysis of Stage 1. Back soon with results.0
-
RideOnTime wrote:Thread substance by stage
Very interesting how there is an overall decline in substance which becomes much more rapid AFTER stage 12. Stage 13 has been argued to be the stage of the tour so far. Interesting that the Axe-3 Domaine stage (when the tour was "over") had little impact
Be interesting to compare thread length to see if it was a numerical decrease in posts or an increase in posting rather than just looking. For example I think Lichtblick started to make an appearance about then....
On a personal note I would just like to add that as geology posts have decelined throughout the tour, as predicted, the off topic posts appear to have little impact on thread substanceWe're in danger of confusing passion with incompetence
- @ddraver0 -
Instead of Stage 1 I have started to analyse Stage 15 - Ventoux. A real biggie with 932 posts.
I'm working on analysis categories for posts - these I feel need to be mutually exclusive.
Initially;
Pro-cycling
Historical pro-cycling
Picture offering
Personal comment - eg I can't watch the cycling today because I'm drilling, going to the dentists, meeting in Milan etc.
Filler comment
Raising a cycling question
Response to a cycling question
Non cycling informative
Geology
Now I'm thinking rather than substance - need to look at whether post raised a new issue or responded to a debate.0 -
What wouldn't Meatloaf do for love?
L'Alpe d ' Huez.
Imagine that the big fat F*.0 -
Still working on this but its far more complex than first meets the eye.
With 3 weeks work to catch up it may take a little longer. I have still got 14 hi-lights programmes to watch again. 
0 -
Just a quick question- why would you do this?
I am genuinely curious.0 -
smithy21 wrote:Just a quick question- why would you do this?
I am genuinely curious.
A good and a fair question.
I think the analysis might answer.
Is it that you want the analysis in pies?
I can do pies.
I thought the bar chart was good. No?0
