So I'm trying to plot out my ultra-important winger skill vs playmaking skill vs cost spreadsheet to try and get the most bang for my buck and I find out that Excel cannot do 3D scatter plots. Never mind that algebra students have to know how to make them, it's not doable in Excel. There's a little plugin sheet that someone wrote and that will do it but it's not that good of resolution which is useless when I'm trying to find pricing "sweet spots" where the graph indents a little. Back in the day, I want to say Harvard Graph did this but I haven't used or seen that since Win95. So, is there anything out there that people have used (as opposed to someone doing a google search)?

SI

Let's see... I think I used Matlab to do it. You might have access to that at school.

Oooh. I think you're right. I remember using Matlab for similar things at KU. Unfortunately, it's a bit pricey to get for something like this. Tho, they do have a trial version so I may try that out if no one else has a better option.

SI

Oooh. I think you're right. I remember using Matlab for similar things at KU. Unfortunately, it's a bit pricey to get for something like this. Tho, they do have a trial version so I may try that out if no one else has a better option.

SI

If you give me your data and directions how to do it, I'll Matlab it for you.

Unfortunately, it's not a program I can run from memory so I'm probably out of luck from that angle. Although here is my data for anyone who might have the tools to do it:

<table x:str="" style="border-collapse: collapse; width: 104pt;" border="0" cellpadding="0" cellspacing="0" width="139"> <col style="width: 42pt;" width="56"> <col style="width: 29pt;" width="39"> <col style="width: 33pt;" width="44"> <tbody><tr style="height: 12pt;" height="16"> <td class="xl24" style="height: 12pt; width: 42pt;" height="16" width="56">cost</td> <td class="xl24" style="width: 29pt;" width="39">pm-n</td> <td class="xl24" style="width: 33pt;" width="44">wing-n</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl24" style="height: 12pt;" x:num="" align="right" height="16">7272727</td> <td class="xl24" x:num="" align="right">12</td> <td class="xl24" x:num="" align="right">15</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl24" style="height: 12pt;" x:num="" align="right" height="16">7183000</td> <td class="xl24" x:num="" align="right">14</td> <td class="xl24" x:num="" align="right">13</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl24" style="height: 12pt;" x:num="4692000" align="right" height="16">4692000</td> <td class="xl24" x:num="" align="right">10</td> <td class="xl24" x:num="" align="right">14</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl24" style="height: 12pt;" x:num="7140000" align="right" height="16">7140000</td> <td class="xl24" x:num="" align="right">14</td> <td class="xl24" x:num="" align="right">13</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl24" style="height: 12pt;" x:num="6600000" align="right" height="16">6600000</td> <td class="xl24" x:num="" align="right">11</td> <td class="xl24" x:num="" align="right">15</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl24" style="height: 12pt;" x:num="4143000" align="right" height="16">4143000</td> <td class="xl24" x:num="" align="right">9</td> <td class="xl24" x:num="" align="right">13</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl24" style="height: 12pt;" x:num="" align="right" height="16">4480200</td> <td class="xl24" x:num="" align="right">9</td> <td class="xl24" x:num="" align="right">13</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl24" style="height: 12pt;" x:num="" align="right" height="16">5687000</td> <td class="xl24" x:num="" align="right">9</td> <td class="xl24" x:num="" align="right">14</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl24" style="height: 12pt;" x:num="" align="right" height="16">7037000</td> <td class="xl24" x:num="" align="right">10</td> <td class="xl24" x:num="" align="right">17</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl24" style="height: 12pt;" x:num="" align="right" height="16">4789000</td> <td class="xl24" x:num="" align="right">9</td> <td class="xl24" x:num="" align="right">14</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl24" style="height: 12pt;" x:num="4080000" align="right" height="16">4080000</td> <td class="xl24" x:num="" align="right">10</td> <td class="xl24" x:num="" align="right">13</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl24" style="height: 12pt;" x:num="4370000" align="right" height="16">4370000</td> <td class="xl24" x:num="" align="right">10</td> <td class="xl24" x:num="" align="right">13</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl24" style="height: 12pt;" x:num="7126000" align="right" height="16">7126000</td> <td class="xl24" x:num="" align="right">13</td> <td class="xl24" x:num="" align="right">14</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl24" style="height: 12pt;" x:num="8000000" align="right" height="16">8000000</td> <td class="xl24" x:num="" align="right">11</td> <td class="xl24" x:num="" align="right">17</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl24" style="height: 12pt;" x:num="6228000" align="right" height="16">6228000</td> <td class="xl24" x:num="" align="right">9</td> <td class="xl24" x:num="" align="right">15</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl24" style="height: 12pt;" x:num="5300000" align="right" height="16">5300000</td> <td class="xl24" x:num="" align="right">11</td> <td class="xl24" x:num="" align="right">13</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl24" style="height: 12pt;" x:num="5490000" align="right" height="16">5490000</td> <td class="xl24" x:num="" align="right">9</td> <td class="xl24" x:num="" align="right">14</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl24" style="height: 12pt;" x:num="5414000" align="right" height="16">5414000</td> <td class="xl24" x:num="" align="right">9</td> <td class="xl24" x:num="" align="right">16</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl24" style="height: 12pt;" x:num="" align="right" height="16">5609000</td> <td class="xl24" x:num="" align="right">10</td> <td class="xl24" x:num="" align="right">14</td> </tr></tbody> </table>
SI

Oooh. I think you're right. I remember using Matlab for similar things at KU. Unfortunately, it's a bit pricey to get for something like this. Tho, they do have a trial version so I may try that out if no one else has a better option.I thought you were still at school, where Matlab might be readily available -- e.g. I can get it easily in the Engineering computer cluster at ND. That was why I brought it up.

Your scatterplot wish is my command:

I use the only statistical program there is, SPSS.

http://www.higleylaw.com/images/scatter1.jpg

I thought you were still at school, where Matlab might be readily available -- e.g. I can get it easily in the Engineering computer cluster at ND. That was why I brought it up. Thankfully I got off that bus in December when I graduated :)

That said, yeah, they had it at KU- ran a couple of projects on it even, mostly in signal and system analysis.

Your scatterplot wish is my command:

I use the only statistical program there is, SPSS.
Thanks! That was exactly what I was looking for

I took a class on SPSS once- a little 3 hours "how to use this" thing and it seemed pretty good. From what I understand, it's the only program people use if they run statistical analysis. That said, again something a bit heavy just for this project on my end. Going and buying SPSS just for a little project like this would be like using a bazooka to kill a fly but thankfully you already have it sitting around :)

SI