Page 1 of 2 12 LastLast
Results 1 to 15 of 18

Thread: An Error in average calculations??

  1. #1
    Total Cricket Moderator
    Join Date
    Nov 2001
    Location
    Mumbai
    Posts
    387

    An Error in average calculations??

    I just found a major error in the average calculation done to adjust
    the performances of players in the next season.
    I think an example would illustrate it better.
    S.Tendulkar had played 361 matches and averaged 45.42 before the start
    of the WCCC season.In the season he scored 246 runs at an avg of 30.75 in 10 matches.
    So now his number of matches would be 371 but his average would be :
    (his original career runs + runs in WCCC)/(371-not outs)

    The formula used seems to be
    (WCC avg + Original avg)/2 which is grossly incorrect.
    Pls try to correct it.

    Sriram

  2. #2
    Cricketer Of The Year bugssy's Avatar
    Join Date
    May 2002
    Location
    Sydney NSW
    Posts
    8,213
    can some one clarify this

    very important we get this clarified i think....
    Career cricket
    311 wickets @16.54 and 3021 runs @ 34.56 from 176 games over 11 years H.S 178*
    Member of the CW Green
    Cricket Web Career:(end of season 11) FC: 7404 runs @ 30.85 H.S 253* : One Day: 7331 runs @ 48.55 H.S 155*
    Off season: FC 1209 @ 52.51 & One Day: 921 @ 92.10
    COD4: djs clan
    World Of Warcraft: just sensational

  3. #3
    All Time Legend Paid The Umpire's Avatar
    Join Date
    Mar 2002
    Location
    In Your House, With A Knife!
    Posts
    2,300
    Yes that is major!
    SNRUB!

  4. #4
    3rd Umpire
    Join Date
    Nov 2001
    Location
    Auckland, NZ
    Posts
    2,172
    My understanding was that WCCC averages would become the career averages, in effect cancelling out completely any previous statistics.


  5. #5
    U19 Vice-Captain
    Join Date
    Aug 2002
    Location
    Mumbai,India
    Posts
    529
    Originally posted by Graham
    My understanding was that WCCC averages would become the career averages, in effect cancelling out completely any previous statistics.

    This cannot be done Graham.We have traded players looking at their career avgs.So i think the career avgs should be taken into account.
    Manager of Karnataka
    Season 2 Div 3 Four Day Champions
    Season 2 Div 3 One Day Runners up
    Season 2 Vb Cup Champions
    Season 3 Div 2 Four Day Champions
    Season 3 Div 3 One Day Champions
    Season 4 Div 2 One Day Champions

  6. #6
    Total Cricket Moderator
    Join Date
    Nov 2001
    Location
    Mumbai
    Posts
    387
    GB had said that they would affect present stats....

  7. #7
    Hall of Fame Member age_master's Avatar
    Plasmanaut on Fire Champion!
    Join Date
    Nov 2001
    Location
    Sydney, NSW, Australia
    Posts
    15,777
    only the man himself can answer this one
    Member of CW Green
    Kerry O'Keefe - Worlds funniest Commentator

  8. #8
    Cricketer Of The Year Blewy's Avatar
    Join Date
    Dec 2001
    Location
    Your house
    Posts
    9,964
    The problem with this is that Career runs are not associated with VC4, Aves could only be worked out on games but that would not be an accurate number...

    Basically what i have done is if a player had a very bad season compared to his average his average would drop by a couple of runs, so if a player ave 40 in career and then had a season ave of 30 his ave would decrease by a couple...

    On the other hand if a player had a better than ave season his ave would increase....
    Career games were taken into accnt so if a player had played a motsa of career games his ave would not drop as much as a player who had played only a handful of games...

    The system was the easiest and fairest i could use without going through and calculating every players career runs...

  9. #9
    Hall of Fame Member age_master's Avatar
    Plasmanaut on Fire Champion!
    Join Date
    Nov 2001
    Location
    Sydney, NSW, Australia
    Posts
    15,777
    so for example S Sharath in the colts may will be a little higher in his OD average than last year cause he made heaps of runs last year - is that correct

  10. #10
    Eyes not spreadsheets marc71178's Avatar
    Join Date
    Nov 2001
    Location
    England
    Posts
    57,735
    Oh well, it doesn't hurt me if it's happened to Sachin!

    marc71178 - President and founding member of AAAS - we don't only appreciate when he does well, but also when he's not quite so good!

    Anyone want to join the Society?

    Beware the evils of Kit-Kats - they're immoral apparently.

  11. #11
    Eyes not spreadsheets marc71178's Avatar
    Join Date
    Nov 2001
    Location
    England
    Posts
    57,735
    Originally posted by Sriram k
    I just found a major error in the average calculation done to adjust
    the performances of players in the next season.
    I think an example would illustrate it better.
    S.Tendulkar had played 361 matches and averaged 45.42 before the start
    of the WCCC season.In the season he scored 246 runs at an avg of 30.75 in 10 matches.
    So now his number of matches would be 371 but his average would be :
    (his original career runs + runs in WCCC)/(371-not outs)

    The formula used seems to be
    (WCC avg + Original avg)/2 which is grossly incorrect.
    Pls try to correct it.

    Sriram
    According to the site, he now averages 62.24.

  12. #12
    U19 Vice-Captain
    Join Date
    Aug 2002
    Location
    Mumbai,India
    Posts
    529
    I took Troughton and knight from you marc and their avgs have fallen drastically.Troughton avgs just 34 now in 1d and knight also same.

  13. #13
    Eyes not spreadsheets marc71178's Avatar
    Join Date
    Nov 2001
    Location
    England
    Posts
    57,735
    Originally posted by aditya
    I took Troughton and knight from you marc and their avgs have fallen drastically.Troughton avgs just 34 now in 1d and knight also same.
    LOL!

  14. #14
    Cricket Web Vice Administrator
    Join Date
    Mar 2002
    Location
    Kent, UK
    Posts
    7,190
    How do everyone know the stats have fallen (going by the site) because if you read another thread about the stats I asked GB, Not a single stat has changed on the site from last year yet GB has been busy and hasn't got round to updating the sites stats, only the stats in the VC file have been altered.

    I think GB said by round 2 he should have the new stats for the site... so keep an eye on them then

    Rich

  15. #15
    3rd Umpire
    Join Date
    Nov 2001
    Location
    Auckland, NZ
    Posts
    2,172
    (This cannot be done Graham.We have traded players looking at their career avgs.So i think the career avgs should be taken into account)

    With a little time on my hands during a holiday break, I calculated the FC and OD season averages of every player (taking friendlies into account also). I used performance as well as career stats to conduct my trading, so it will be interesting to see if it was worth all the trouble!
    By the way I did all my calculations on paper and not in spreadsheet form, so sorry I can't email them to anybody.
    I used these calculations and career stats to make my predictions about how teams would go in each division. Since then there were trades, so I might amend my predictions slightly soon (if you're interested).

    [Edited on 13/10/2002 by Graham]

Page 1 of 2 12 LastLast


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •