Average age of wines

[stefan]

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

[JimHow]

Surely you are signed up to cellartracker, stefan, no?
In ten seconds there I got my answer:
2002.2 from 18 vintages.

[stefan]

No, I am wedded to my excel file, Jim.

stefan

[JonB]

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.

[JimHow]

I wonder how much my 1918 Haut Brion affected my 935 bottle cellar....

[Claret]

I would guess my average to be somewhere in the vicinity of 1996, with one bottle of 1845 Madeira included.

Glenn

[Gerry M.]

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]

2000.6 in 32 vintages. Weird anomoly I would not have expected: just one bottle of wine from vintage 1990.

[JCNorthway]

Ok. Now I'm curious about my own cellar. Back shortly with an answer (from an Excel file, like Stefan).

Jon

[JCNorthway]

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

[SF Ed]

2000.2 in 27 vintages.

[William P]

2001.07 in sixteen vintages.

[stefan]

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

[DavidG]

1999 in 31 vintages, no doubt influenced by heavy Bordeaux buying in 2005 and heavy Rhone buying in 2007.

[stefan]

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

[Tom In DC]

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...