Average age of wines
Average age of wines
A post that caught my eye on the Square's board was a listing of the average vintage of wines in member's cellars. It pushed my excel skills to the limit, but I managed (I think) to do the calculation and got 1999.78 from 38 vintages. Younger than I thought.
I wonder what Francois' would be?
stefan
I wonder what Francois' would be?
stefan
- JimHow
- Posts: 20315
- Joined: Thu Nov 20, 2008 10:49 pm
- Location: Lewiston, Maine, United States
- Contact:
Re: Average age of wines
Surely you are signed up to cellartracker, stefan, no?
In ten seconds there I got my answer:
2002.2 from 18 vintages.
In ten seconds there I got my answer:
2002.2 from 18 vintages.
Re: Average age of wines
No, I am wedded to my excel file, Jim.
stefan
stefan
Re: Average age of wines
My few bottles of NV Champagne skewed my formula. I show 487 different wines, with a mean average age of 2006, a median of 2005, and the oldest being a 1982 Leonetti Cab (Washington State).
------------------------
EDIT: I discovered a wine entered in my Excel spreadsheet with the 2995 vintage.....the corrected mean average is 2004.3, with 16 vintages.
------------------------
EDIT: I discovered a wine entered in my Excel spreadsheet with the 2995 vintage.....the corrected mean average is 2004.3, with 16 vintages.
Last edited by JonB on Fri Nov 20, 2009 5:23 pm, edited 1 time in total.
- JimHow
- Posts: 20315
- Joined: Thu Nov 20, 2008 10:49 pm
- Location: Lewiston, Maine, United States
- Contact:
Re: Average age of wines
I wonder how much my 1918 Haut Brion affected my 935 bottle cellar....
Re: Average age of wines
I would guess my average to be somewhere in the vicinity of 1996, with one bottle of 1845 Madeira included.
Glenn
Glenn
Last edited by Claret on Fri Nov 20, 2009 3:40 am, edited 2 times in total.
Glenn
Re: Average age of wines
JimHow wrote:Surely you are signed up to cellartracker, stefan, no?
In ten seconds there I got my answer:
2002.2 from 18 vintages.
What a coincidence, my cellar is 2002.1 from 21 vintages. Thank goodness for Cellartracker.
- Michael Malinoski
- Posts: 678
- Joined: Mon Jan 26, 2009 9:12 pm
- Location: Sudbury, MA
- Contact:
Re: Average age of wines
2000.6 in 32 vintages. Weird anomoly I would not have expected: just one bottle of wine from vintage 1990.
- JCNorthway
- Posts: 1554
- Joined: Mon Jan 26, 2009 9:31 pm
- Contact:
Re: Average age of wines
Ok. Now I'm curious about my own cellar. Back shortly with an answer (from an Excel file, like Stefan).
Jon
Jon
- JCNorthway
- Posts: 1554
- Joined: Mon Jan 26, 2009 9:31 pm
- Contact:
Re: Average age of wines
Without the aid of Cellar Tracker, I had to use the old fashioned Excel method. It turns out that my average vintage is 2001.2 from 1424 bottles over 25 vintages (not including NV). I was a little surprised by that average until I realized it was influenced by 21.7% of my bottles being from 2005 - largely impacted by Burgundy purchases from that vintage.
Jon
Jon
Re: Average age of wines
2000.2 in 27 vintages.
Re: Average age of wines
2001.07 in sixteen vintages.
Re: Average age of wines
I thought that older wines would bring my average age down, but on further inspection I see that I have only 65 bottles from before 1980, the oldest being from 1959. Most of the post 2000 wines I have are in case lots.
Clearly I need to enter the auction market.
stefan
Clearly I need to enter the auction market.
stefan
Re: Average age of wines
1999 in 31 vintages, no doubt influenced by heavy Bordeaux buying in 2005 and heavy Rhone buying in 2007.
Re: Average age of wines
My median bottle is even younger (2000). My median wine (so that multiple bottles carry no weight) is from 1998.
Before doing this, I thought my collection was older. This gives me an excuse to buy more older wine.
stefan
Before doing this, I thought my collection was older. This gives me an excuse to buy more older wine.
stefan
Re: Average age of wines
Average vintage of bottle: 1992
Median vintage by bottle : 1995 (sense, since the older vintages go back a lot farther)
Average vintage of wine: 1991 (just slightly fewer of the older bottles)
Median vintage of wine : 1993
I'm happy with these numbers, given what's in the cellar (Bordeaux, Barolo and Barbaresco, red Burgs, Sauternes, Port, ...), although Gail seems to think we have a lot of wine going OTH to her taste...
Median vintage by bottle : 1995 (sense, since the older vintages go back a lot farther)
Average vintage of wine: 1991 (just slightly fewer of the older bottles)
Median vintage of wine : 1993
I'm happy with these numbers, given what's in the cellar (Bordeaux, Barolo and Barbaresco, red Burgs, Sauternes, Port, ...), although Gail seems to think we have a lot of wine going OTH to her taste...
Who is online
Users browsing this forum: Claudius2, Google [Bot] and 95 guests