|
|
|
|
| ||
Diamond Jewelry Forums
 Picture Gallery
 Video Gallery
 Journal
|
|||
|
|  Search
|  Posted Today
|  Most Active
|  Help
|
||
 »
Home
»  » Diamond Prices and Grading »
 » RockyTalky
»  » Results have been calculated: and the average PS e-ring size is...
|
| Pages: 1 of 3: [1] 2 3 > |
|
 |
Results have been calculated: and the average PS e-ring size is... |
 |
| P: 5/23/2008 1:41:09 PM | |
gwendolyn Ideal Rock Total Posts: 6,544 Last Post: 11/12/2009 Member Since: 8/4/2007 |
Here are the results of all the data you guys provided in my other thread. If you have any questions, feel free to ask! And if you didn't take part, you can still add your info to my other thread because I will update this if the numbers keep rolling in!  Solitaires! These numbers do not include upgrades or 3-stone rings. Total number of carats of diamond solitaire stones [original (not counting upgrades) e-rings, without sidestones, melee, etc.]: 229.616cts  Average number of carats of diamond solitare stones [original (not counting upgrades) e-rings, without sidestones, melee, etc.]: 2.59453107 cts, extremes were 0.15 and 5.01 Median (the middle of the distribution): 1.09 cts Mode (the most common value): 1.01 cts Sidestones! These are the measurements for all original e-rings. Upgrades were calculated as ctw (coming up next). Total carat weight of diamond sidestones: 45.02cts Average carat weight of diamond sidestones: 0.57717949cts, extremes were 0.05 and 2.13 Median of diamond sidestones: 0.5 Mode of diamond sidestones: 0.5 Total carat weight of non-diamond sidestones: 1.2 (only 2 posters submitted info) Upgrades! Anyone who gave me information on their upgrades was tallied in this column. If you had multiple upgrades, I only used information from the most recent one, so this should reflect everyone's current e-rings. Total number of carats of diamond upgrades: 106.1cts Average upgrade: 2.35777778cts, extremes were 0.73 and 10.1 Median of upgrades: 1.81cts Mode of upgrades: 2.0cts Wedding bands! Anyone who supplied carat weight (presumably all diamond, no one mentioned any other stones) for their wedding bands has been calculated. Total number of carats in diamond wedding bands: 22.48cts Average number of carats in diamond wedding bands: 0.80285714cts, extremes were 0.09cts and 2.7cts Median: 0.75cts Mode: 1.0cts E-rings with stones other than diamonds in the center! There aren't many of you, so you won't have a mode, I'm afraid. Total carat weight of non-diamond center stones: 4.45cts Average carat weight of non-diamond center stones: 1.48333333cts, extremes being 0.97cts and 2.06cts Median: 1.42cts No mode  3-stone rings! Total carat weight of 3-stone diamond rings: 24.81cts Average carat weight of 3-stone diamond rings: 2.25545455cts Median: 2.0cts Mode: 0.7cts ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ UK Wedding: April ?th, 2010 US Reception: May 30th, 2010! Out of Context Theatre presents...ladypirate: "Gwen, you would make a terrible medieval catholic priest!" 'One day you will do things for me that you hate. That is what it means to be family.' -Jonathan Safran Foer, 'Everything Is Illuminated' |
| Posted: 5/23/2008 1:41:09 PM | |
|
There are 80 replies to this message. There are 30 replies on this page. |
|
| P: 5/23/2008 1:44:27 PM | |
|
gwendolyn Ideal Rock Total Posts: 6,544 Last Post: 11/12/2009 Member Since: 8/4/2007 |
And if anyone wants to still participate, the data thread can be found here (sorry I can't direct link): http://www.pricescope.com/idealbb/view.asp?topicID=82987 Add your info and I'll update these numbers when we get enough data! 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| Posted: 5/23/2008 1:44:27 PM | |
| P: 5/23/2008 1:46:08 PM | |
neatfreak Ideal Rock Total Posts: 13,477 Last Post: 11/24/2009 Member Since: 2/17/2007 |
All that calculation to get 1 carat! Lol. And Gwen, your new picture is ADORABLE!
|
| Posted: 5/23/2008 1:46:08 PM | |
| P: 5/23/2008 1:50:29 PM | |
NewEnglandLady Ideal Rock Total Posts: 3,159 Last Post: 11/25/2009 Member Since: 7/27/2007 |
You are such a sweetheart to do this on top of all of your other work!! And with your sweetie in town!! I tried to do find the average and mean in the e-ring eye candy folder and didn't even make it through a tenth of it, haha. I LOOOOOVE your new avatar!!
|
| Posted: 5/23/2008 1:50:29 PM | |
| P: 5/23/2008 1:51:09 PM | |
Addy Ideal Rock Total Posts: 3,915 Last Post: 11/18/2009 Member Since: 10/20/2007 |
Man! I knew my e-ring was small, it's the size of other people's side stones. That's a lot of fancy calculations you've done, aren't you supposed to be writing a dissertation and visiting with your man? Thank you for all your hard work!!
|
| Posted: 5/23/2008 1:51:09 PM | |
| P: 5/23/2008 1:52:04 PM | |
|
gwendolyn Ideal Rock Total Posts: 6,544 Last Post: 11/12/2009 Member Since: 8/4/2007 |
Date: 5/23/2008 1:46:08 PM Author: neatfreak All that calculation to get 1 carat! Lol. It was much more than that! More than just that one question! Besides, 1 was the mode, 2.59 was the average... And Gwen, your new picture is ADORABLE! Thanks! I wish it wasn't blurry, but I didn't want to chop off half of either of our heads to make it a square. Oh well. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| Posted: 5/23/2008 1:52:04 PM | |
| P: 5/23/2008 1:54:06 PM | |
|
neatfreak Ideal Rock Total Posts: 13,477 Last Post: 11/24/2009 Member Since: 2/17/2007 |
Date: 5/23/2008 1:52:04 PM Author: gwendolyn Date: 5/23/2008 1:46:08 PM Author: neatfreak All that calculation to get 1 carat! Lol. It was much more than that! More than just that one question! Besides, 1 was the mode, 2.59 was the average... And Gwen, your new picture is ADORABLE! Thanks! I wish it wasn't blurry, but I didn't want to chop off half of either of our heads to make it a square. Oh well. True...but I think in this case the mode might be more telling...Considering the mode and the average are so off, it implies that the average is being heavily weighted by those few honker stones!
|
| Posted: 5/23/2008 1:54:06 PM | |
| P: 5/23/2008 1:54:37 PM | |
|
gwendolyn Ideal Rock Total Posts: 6,544 Last Post: 11/12/2009 Member Since: 8/4/2007 |
NEL & Addy--If J was still here, I'd be doing other things, trust me! He left yesterday morning, alas and alack. Now, about the dissertation, yes, I SHOULD be doing that, but...I'm not.   Honestly, with Excel, it didn't take very long at all. And, I know this makes me a dork, but it was kinda neat.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| Posted: 5/23/2008 1:54:37 PM | |
| P: 5/23/2008 1:58:07 PM | |
the rube Ideal Rock Total Posts: 1,934 Last Post: 10/15/2009 Member Since: 10/22/2007 |
So after all, the average PS stone is the same size as the most common size out in the general population. About 1 carat. Fascinating!!
|
| Posted: 5/23/2008 1:58:07 PM | |
| P: 5/23/2008 1:58:48 PM | |
|
gwendolyn Ideal Rock Total Posts: 6,544 Last Post: 11/12/2009 Member Since: 8/4/2007 |
Date: 5/23/2008 1:54:06 PM Author: neatfreak True...but I think in this case the mode might be more telling...Considering the mode and the average are so off, it implies that the average is being heavily weighted by those few honker stones! Perhaps, but many of those honkers are classified as upgrades. Those first numbers are just people's original solitaires, so at least some of the giant stones you're thinking of weren't included in those calculations because those people included their original solitaire info and their upgrade info. It's also why I put up what the extremes of each calc were, so you could see the range (since no one wants to look at 187 different arrangements of numbers for each tally). Anyway, although it was for fun, it did not JUST come out to 1ct. I figured out a lot more stuff than just that, thanks very much! 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| Posted: 5/23/2008 1:58:48 PM | |
| P: 5/23/2008 1:59:34 PM | |
|
gwendolyn Ideal Rock Total Posts: 6,544 Last Post: 11/12/2009 Member Since: 8/4/2007 |
Date: 5/23/2008 1:58:07 PM Author: tberube So after all, the average PS stone is the same size as the most common size out in the general population. About 1 carat. Fascinating!! For original e-rings, yes. That calc doesn't include upgrades. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| Posted: 5/23/2008 1:59:34 PM | |
| P: 5/23/2008 2:01:31 PM | |
|
NewEnglandLady Ideal Rock Total Posts: 3,159 Last Post: 11/25/2009 Member Since: 7/27/2007 |
Date: 5/23/2008 1:54:37 PM Author: gwendolyn NEL & Addy--If J was still here, I'd be doing other things, trust me! He left yesterday morning, alas and alack. Now, about the dissertation, yes, I SHOULD be doing that, but...I'm not. Honestly, with Excel, it didn't take very long at all. And, I know this makes me a dork, but it was kinda neat. Aww, I'm glad you didn't do it while J was in town :) We definitely appreciate the work you put into it, thank you!!
|
| Posted: 5/23/2008 2:01:31 PM | |
| P: 5/23/2008 2:10:48 PM | |
LegacyGirl Ideal Rock Total Posts: 1,757 Last Post: 1/15/2009 Member Since: 11/16/2007 |
Wow thanks Gwen! That was interesting. And your new pic is sooooooooo cute!
|
| Posted: 5/23/2008 2:10:48 PM | |
| P: 5/23/2008 2:13:11 PM | |
|
LegacyGirl Ideal Rock Total Posts: 1,757 Last Post: 1/15/2009 Member Since: 11/16/2007 |
Date: 5/23/2008 1:58:07 PM I thought .75 was more common?
Author: tberube So after all, the average PS stone is the same size as the most common size out in the general population. About 1 carat. Fascinating!!
|
| Posted: 5/23/2008 2:13:11 PM | |
| P: 5/23/2008 2:15:31 PM | |
|
neatfreak Ideal Rock Total Posts: 13,477 Last Post: 11/24/2009 Member Since: 2/17/2007 |
Date: 5/23/2008 1:58:48 PM Author: gwendolyn Date: 5/23/2008 1:54:06 PM Author: neatfreak True...but I think in this case the mode might be more telling...Considering the mode and the average are so off, it implies that the average is being heavily weighted by those few honker stones! Perhaps, but many of those honkers are classified as upgrades. Those first numbers are just people's original solitaires, so at least some of the giant stones you're thinking of weren't included in those calculations because those people included their original solitaire info and their upgrade info. It's also why I put up what the extremes of each calc were, so you could see the range (since no one wants to look at 187 different arrangements of numbers for each tally). Anyway, although it was for fun, it did not JUST come out to 1ct. I figured out a lot more stuff than just that, thanks very much! I TOTALLY did not mean to discount all the calcs you did Gwen! It took a ton of work I'm sure!!!!
|
| Posted: 5/23/2008 2:15:31 PM | |
| P: 5/23/2008 2:19:23 PM | |
|
gwendolyn Ideal Rock Total Posts: 6,544 Last Post: 11/12/2009 Member Since: 8/4/2007 |
Date: 5/23/2008 2:15:31 PM Author: neatfreak Date: 5/23/2008 1:58:48 PM Author: gwendolyn Date: 5/23/2008 1:54:06 PM Author: neatfreak True...but I think in this case the mode might be more telling...Considering the mode and the average are so off, it implies that the average is being heavily weighted by those few honker stones! Perhaps, but many of those honkers are classified as upgrades. Those first numbers are just people's original solitaires, so at least some of the giant stones you're thinking of weren't included in those calculations because those people included their original solitaire info and their upgrade info. It's also why I put up what the extremes of each calc were, so you could see the range (since no one wants to look at 187 different arrangements of numbers for each tally). Anyway, although it was for fun, it did not JUST come out to 1ct. I figured out a lot more stuff than just that, thanks very much! I TOTALLY did not mean to discount all the calcs you did Gwen! It took a ton of work I'm sure!!!! No worries, m'dear, I was just slightly crestfallen to see that the first response was that it all boiled down to 1ct. But it was just a momentary feeling! So no worries! I am now curious to find out what the average and the mode (and the other stuff) are for everyone's current e-rings (combining the solitaire stats with the upgrades. I am going to put together another column of data and see if I can figure it out. It will have to be ctw, though, because some people didn't give me the breakdowns of the upgrades (which is why I only did upgrades in ctw). So, give me a little while and I should have more info, if anyone else is curious.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| Posted: 5/23/2008 2:19:23 PM | |
| P: 5/23/2008 2:42:27 PM | |
|
gwendolyn Ideal Rock Total Posts: 6,544 Last Post: 11/12/2009 Member Since: 8/4/2007 |
Additional info! CTW of all current diamond e-rings (this includes all the original solitaire info, sidestone info, and upgrade info. If you gave me upgrade info, that ring was counted instead of your original. All numbers given are ctw. Total sum of diamond e-ring carats: 338.386cts (yowsah! We are worth millions!) Average diamond e-ring size: 1.89042458cts, extremes were 0.21cts and 10.1cts Median: 1.52cts Mode: 1.01cts What the?! Is this everyone falling for DeBeers' marketing?! Ok. All done FOR REAL this time. I will shut up now. Thank you! 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| Posted: 5/23/2008 2:42:27 PM | |
| P: 5/23/2008 2:50:28 PM | |
Burk Ideal Rock Total Posts: 3,269 Last Post: 11/24/2009 Member Since: 5/9/2006 |
WOW! Interesting stuff. Good work gwen!!! I'll have to go and participate to make more work for you.
|
| Posted: 5/23/2008 2:50:28 PM | |
| P: 5/23/2008 3:03:19 PM | |
lyra Ideal Rock Total Posts: 1,764 Last Post: 11/24/2009 Member Since: 7/13/2007 |
Date: 5/23/2008 1:51:09 PM Author: Addy Man! I knew my e-ring was small, it's the size of other people's side stones. Size isn't everything. My original stone was .26 with .24ctw sidestones. It's kind of pitiful looking and lost among the sidestones.  Thanks so much Gwendolyn!  Good job!
|
| Posted: 5/23/2008 3:03:19 PM | |
| P: 5/23/2008 3:20:14 PM | |
Lynn B Ideal Rock Total Posts: 5,151 Last Post: 11/24/2009 Member Since: 5/9/2004 |
Darlin', you got a liiiiiiittle too much time on your hands... Seriously, INCREDIBLE work! And I am TERRIBLY jealous, as I am a certified math moron! Wow, VERY interesting statistics. Thanks!I thought this was especially interesting: Average upgrade: 2.35777778cts My upgrade size? Exactly 2.36 cts!!!! Haha! That's me, Ms. Average!!! 
And THAT'S my story and I'm sticking to it! |
| Posted: 5/23/2008 3:20:14 PM | |
| P: 5/23/2008 3:21:15 PM | |
sparxs111 Cut Rock Total Posts: 208 Last Post: 11/23/2009 Member Since: 1/4/2008 |
So the mode was around 1 carat which is the average in North america. However I bet you money that most of those are excellent and ideal cuts, which would afr outweigh the average...
|
| Posted: 5/23/2008 3:21:15 PM | |
| P: 5/23/2008 3:42:01 PM | |
LtlFirecracker Ideal Rock Total Posts: 3,020 Last Post: 11/24/2009 Member Since: 2/29/2008 |
Very interesting, thanks for doing the calculations. The nerd in me has a question. Did you see the data in a graph? I am wondering if extreams of size are right shifting the mean. I am just wondering if I should look at the medium or the mean to get an idea of what most people have here. Thanks.
|
| Posted: 5/23/2008 3:42:01 PM | |
| P: 5/23/2008 3:42:59 PM | |
|
gwendolyn Ideal Rock Total Posts: 6,544 Last Post: 11/12/2009 Member Since: 8/4/2007 |
Date: 5/23/2008 3:20:14 PM Author: Lynn B Darlin', you got a liiiiiiittle too much time on your hands... Am supposed to be writing my 'Findings & Discussion' chapter for my dissertation. Shhh, don't tell.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| Posted: 5/23/2008 3:42:59 PM | |
| P: 5/23/2008 3:54:26 PM | |
|
gwendolyn Ideal Rock Total Posts: 6,544 Last Post: 11/12/2009 Member Since: 8/4/2007 |
Date: 5/23/2008 3:42:01 PM Author: LtlFirecracker Very interesting, thanks for doing the calculations. The nerd in me has a question. Did you see the data in a graph? I am wondering if extreams of size are right shifting the mean. I am just wondering if I should look at the medium or the mean to get an idea of what most people have here. Thanks. No, I didn't put the data into a graph. I listed the extremes to give people an idea of the outliers, how far to either end they go. In order to get the median, you essentially line up your data from the smallest values to the largest, and the number that falls precisely in the middle is the median. It's only marginally useful in that it really only tells you something if all your numbers are spread evenly apart, which to some degree these are. The mode (which I know you didn't directly ask about) tells you which was the most common, which is reflective of the data in some ways but also not in others (for instance, there were some stones that were *almost* the same size but were off by 0.01ct so they don't get counted as a reoccurring statistic even though if I had rounded the numbers they probably would have). The mean, or average, was the original point of the whole thread. Although I find the mode interesting, I wanted to know how many carats would be passed around to all if we could mash them together and then divvy them up evenly. If you *really* want to get an idea what people have here, take a look through the thread where I got my info, and read how incredibly varied everyone's stones are. And if I can figure it out, I'll make you a chart too.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| Posted: 5/23/2008 3:54:26 PM | |
| P: 5/23/2008 4:02:34 PM | |
|
gwendolyn Ideal Rock Total Posts: 6,544 Last Post: 11/12/2009 Member Since: 8/4/2007 |
Ok, let's see if this works. I just made a scatter plot to show where most of the data lies (probably way more useful than any of the other stats I gave earlier ). Not sure if it will work, though...lemme see... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| Posted: 5/23/2008 4:02:34 PM | |
| P: 5/23/2008 4:10:04 PM | |
|
LtlFirecracker Ideal Rock Total Posts: 3,020 Last Post: 11/24/2009 Member Since: 2/29/2008 |
Thanks for the review. I totally forgot what the mode is and I did remember the definition of medium (but I wasn't sure I had it right). I have not formally done stats for 6 years now, but I may be starting a research project soon, so I guess i have to brush up. Thanks for trying to do the graph and thanks again for taking this on, although I know you should be doing something elce ;-). I did follow the thread. But it is helpful to see it put together like this for me.
|
| Posted: 5/23/2008 4:10:04 PM | |
| P: 5/23/2008 4:13:35 PM | |
|
gwendolyn Ideal Rock Total Posts: 6,544 Last Post: 11/12/2009 Member Since: 8/4/2007 |
This time? How can I show an Excel chart in here? Changing the extension isn't working, and I can't seem to save it as an image.  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| Posted: 5/23/2008 4:13:35 PM | |
| P: 5/23/2008 4:21:34 PM | |
purrfectpear Ideal Rock Total Posts: 3,706 Last Post: 11/24/2009 Member Since: 3/31/2008 |
I don't think it will take a gif file. Has to be jpg doesn't it?
"Style is knowing who you are, what you want to say and not giving a damn." -Gore Vidal |
| Posted: 5/23/2008 4:21:34 PM | |
| P: 5/23/2008 4:26:06 PM | |
|
gwendolyn Ideal Rock Total Posts: 6,544 Last Post: 11/12/2009 Member Since: 8/4/2007 |
Date: 5/23/2008 4:21:34 PM Author: purrfectpear I don't think it will take a gif file. Has to be jpg doesn't it? First time I tried it as a jpg and it didn't work. I think it's because although I changed the extension, it didn't convert the Excel file into an image file. There are instructions on how to do it in 'Help,' but they don't work on my Mac. Am going to fiddle a bit more, because this chart is really pretty neat (man I am a dork), but I really am not that familiar with Excel, so if anyone has any hints, please feel free to share them with me. Thanks! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| Posted: 5/23/2008 4:26:06 PM | |
| P: 5/23/2008 4:38:57 PM | |
|
gwendolyn Ideal Rock Total Posts: 6,544 Last Post: 11/12/2009 Member Since: 8/4/2007 |
AHA!!!!!! I figured it out! Pulled the Excel chart up and then did a screenshot! So, yeah, here's my scatterplot diagram, showing you how the majority of folks have between 1-2 carats, and gives a nice visual representation of how many are way out of the 'norm.' The X-axis (going across the bottom there) doesn't mean anything. Those numbers are just the order in which I put the data into the chart. 187 people submitted their info, so that's why the chart goes up that high.  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| Posted: 5/23/2008 4:38:57 PM | |
| P: 5/23/2008 4:47:09 PM | |
LDubs Cut Rock Total Posts: 126 Last Post: 4/5/2009 Member Since: 2/7/2008 |
Well done! I've been waiting for these results - I'm so glad you came up with the idea :)
|
| Posted: 5/23/2008 4:47:09 PM | |
 Previous Page
|
Pages: 1 of 3: [1] 2 3 > |
Next Page 
|
| « Platinum E-ring sizing help « | » Radiant Cut » |
Contact Us | Back Home | Privacy Statement | Forum Agreement | Forum Policies | |
| Ideal BB Version: 0.1.5.4.beta1 | Message forum software powered by the Ideal BB |
| |
Pricescope -
Knowledge -
Diamond Prices -
Tools -
Resources -
About
© 2000-2009 Pricescope. Terms of Use Privacy Policy Disclaimer
forum archives
