Author | Thread |
|
05/06/2007 05:15:32 PM · #1 |
Just for fun I am playing with my challenge scores in Excel to judge improvement, digression, etc.
But when I first started with a simple average of all my challenges, my average score reads 6.011, yet on my profile it reads 5.997.
I have judged whether it is including or not including current ongoing challenges and it is not. The numbers still come out differently.
Any ideas? |
|
|
05/06/2007 05:17:30 PM · #2 |
the thing i can think of is that the system goes to more than just 4 digits past the decimal...it just doesnt show it... |
|
|
05/06/2007 05:18:06 PM · #3 |
When you just take your average of scores in Excel, it doesn't include how many votes you got in different challenges and treats all scores equally. :) |
|
|
05/06/2007 05:21:24 PM · #4 |
Your average score is a weighted average, I think. Try this:
(avg in challenge) * (# votes in challenge)
add all, divide by total number of votes received
Message edited by author 2007-05-06 17:26:54.
|
|
|
05/06/2007 05:28:07 PM · #5 |
I'm not sure, but perhaps your current challanges are counting...
(my average in Excel is lower than the report, but I'm al little
confused about my current scores). |
|
|
05/06/2007 05:28:34 PM · #6 |
Ahh yes..rings a bell now.
I like the excel number better. Thanks. |
|
|
05/06/2007 05:41:39 PM · #7 |
|
Home -
Challenges -
Community -
League -
Photos -
Cameras -
Lenses -
Learn -
Help -
Terms of Use -
Privacy -
Top ^
DPChallenge, and website content and design, Copyright © 2001-2025 Challenging Technologies, LLC.
All digital photo copyrights belong to the photographers and may not be used without permission.
Current Server Time: 09/16/2025 09:38:43 AM EDT.