Updating my profile & calculating results

gypsy · Post by **gypsy** » Sat Jan 24, 2004 2:27 am

Hi there.

I want to update my profile. When I do update it it still shows the old information.

My website has changed to www.gypsyprodigies.com
and my slogan to ~You are only limited by your ignoance~

When I change the info and click on update it still the same as before...

Also.

How can we work out what our average video would be if it was on the top 10% lyst ???

There's a nice big formula there. I know how excel formula's work and I'm quite fond of it but I dont know what half those value's are.

compscore = sum(avg(nonNULL(opinion.category))/count(avg(nonNULL(opinion.category)) except Overall and Re-view

score = avg(compscore+overall+review)

Could somebody explaing this or give the formula in a format that everybody would be able to work it out ? I think it's the nonNULL value that throws me out cause I hae no idea what that is...

Zarxrax · Post by **Zarxrax** » Sat Jan 24, 2004 4:11 pm

Lets see if I can work this out here...

Composite Score:
For each category other than overall and review that has a score (for example dont count null rankings for lip sync or effects), remove the highest and lowest scores, then find the average of all the scores remaining.

Score: Average the composite sore with the overall and review scores.

Is this correct?

Arigatomina · Post by **Arigatomina** » Sun Jan 25, 2004 12:33 am

Close - but don't remove the highest and lowest scores until you have 10 reviews. That 'top/bottom' discarding doesn't happen until there are 2 more reviews than the necessary 8 (so you have some to throw away). ^.~

Scintilla · Post by **Scintilla** » Sun Jan 25, 2004 8:44 am

Arigatomyna wrote:Close - but don't remove the highest and lowest scores until you have 10 reviews. That 'top/bottom' discarding doesn't happen until there are 2 more reviews than the necessary 8 (so you have some to throw away). ^.~

I still don't think this is the case, because the scores shown for, say, "Haruko the Superfreak" on its info page are not the same as those I see when I pull up its opinions page. The ones on the info page, as far as I can tell, have the best and worst scores removed (I did the math and it works out)... and this video only has 9 opinions. And I'm pretty sure it was also that way back when it had 7 or 8 opinions.

So as far as I can tell, the removal of the extreme scores kicks in somewhat earlier than 10 opinions.

Arigatomina · Post by **Arigatomina** » Sun Jan 25, 2004 1:23 pm

Scintilla wrote:So as far as I can tell, the removal of the extreme scores kicks in somewhat earlier than 10 opinions.

Maybe. ^_^;; I heard it from AD in this thread:

http://www.animemusicvideos.org/phpBB/v ... ht=nonnull

AbsoluteDestiny · Post by **AbsoluteDestiny** » Sun Jan 25, 2004 2:57 pm

I dont know the exact number before it kicks in, I was just led to believe it was 10.

Corran · Post by **Corran** » Sun Jan 25, 2004 3:09 pm

I always thought it was applied right from the beginning since when you click on a video with less then 3 ops you are unable to see what ratings it got.

Arigatomina · Post by **Arigatomina** » Sun Jan 25, 2004 3:25 pm

Corran Productions wrote:I always thought it was applied right from the beginning since when you click on a video with less then 3 ops you are unable to see what ratings it got.

I think the 3 is just so there are enough reviews to take the average of them. If one person reviewed a vid and it showed the scores for that average (of 1 review) then you'd know what the person gave - whether the creator made it public or not. For 2 it's a little harder, but you can still get a good idea what scores the 2 reviewers left. With 3 you can't tell what each of the 3 reviewers might have given - you just get the average of them.

As for the 'drop' averages - I think it would *have* to be 10 if it's done specifically for the top 10 list (and I believe Phade says it is only put into effect once the vid is on the top list - not in the averages on each vid description page).

If you need 8 reviews to be in the top 10, then dropping 2 reviews would only give you 6. Then the vid wouldn't qualify for the top 10 - so only vids with 10 reviews would be listed there (since you drop 2 reviews - the top and bottom). If you drop the 2 once the vid has 10 reviews, you still have the minimum 8 reviews necessary to be counted on the top 10 list. Doing it before you have 2 extra reviews to drop would be the same as raising the minimum requirement to 10 reviews - to account for the 2 that get discredited.

gypsy · Post by **gypsy** » Thu Jan 29, 2004 12:20 pm

There's 1 way to confirm this...

I got 9 reviews on my newest video (Mystery Conundrum) and I'm on the top 10% list.

If someone gives me a review I'll either rise or fall on the lyst.

Then we'll know if the test and worst get's disregarded cause I'll be able to tell when I work out the average and compare it to what it is now...

Here's the link if anybody wanna give me a review. (I'll return the favour as well

)
http://www.animemusicvideos.org/members ... d_id=29861

Scintilla · Post by **Scintilla** » Thu Jan 29, 2004 1:00 pm

To give a new, current personal example:

My "Dueling Videos: Under Ice" currently has 7 opinions.

When I go to <a href="http://www.animemusicvideos.org/members ... 28816">its Opinions page</a>, the averages are:

But on the video's info page, the scores are:

What this tells me is that the best and worst scores in each category are removed before calculating the averages that show up on the info pages, even before the video hits 8 ops.