Ok, are you ready? Deep breath.
I wrote a program to take all the poll results from my website and make a comma-separated text file ready for import. This program takes all the numbers and shuffles them into the right spots, substituting average (5) any unscored fish (0). I took the raw data and fed it into Excel and made up some charts. The pie chart was accurate with the raw figures because it takes each sample (1 person) and converts their scores into percentages. No person can give more or less than 100%. So the pie chart has been accurate since about 11pm. Realize this is my first time really using Excel in this way so I'm learning.
So the pie chart is DONE...
{UPDATE: HERE'S THE NEW LABELED PIE CHART}
So now you have your percentages. Now for weighted points.
Here is your ranking of all 22 fish/creatures and points scored (tallied):
<table cellspacing=4 border=1 bordercolor=AAAA00 bgcolor=000055>
<tr><td>Lionfish</td><td>523.0497</td></tr>
<tr><td>Percula Clown</td><td>453.1223</td></tr>
<tr><td>Starfish</td><td>415.1043</td></tr>
<tr><td>Powder Blue Tang</td><td>411.7179</td></tr>
<tr><td>Flame Angel</td><td>411.2689</td></tr>
<tr><td>Copper-banded Butterfly</td><td>405.3746</td></tr>
<tr><td>Wimplefish</td><td>397.0838</td></tr>
<tr><td>Koran Angel</td><td>395.3112</td></tr>
<tr><td>Clown Trigger</td><td>389.7137</td></tr>
<tr><td>Regal Tang</td><td>381.9304</td></tr>
<tr><td>Forceps Butterfly</td><td>379.4316</td></tr>
<tr><td>Yellow Tang</td><td>376.4910</td></tr>
<tr><td>Purple Tang</td><td>368.5496</td></tr>
<tr><td>Regal Angel</td><td>358.7886</td></tr>
<tr><td>French Angel</td><td>351.8587</td></tr>
<tr><td>Threadfin Butterfly</td><td>348.1166</td></tr>
<tr><td>Blue Chromis</td><td>337.9998</td></tr>
<tr><td>Addis Butterfly</td><td>333.2153</td></tr>
<tr><td>Three-stripe Damsel</td><td>332.8771</td></tr>
<tr><td>Royal Gramma</td><td>326.7717</td></tr>
<tr><td>Picasso Trigger</td><td>317.7930</td></tr>
<tr><td>Queen Angel</td><td>315.4302</td></tr></table>
And some graphix--sorted for your viewing pleasure...
and finally, here's ALL the data piled on one graph!
Each color line is a different person.
This is what I was trying to get across in my other post. Every fish got highs and lows and then a cluster in the middle. The scores were all over the map.
I extrapolated this from the above graph in Photoshop.
