Sunday afternoon Genealogy Fun

Sunday Afternoon Genealogy Fun – Lifespans of Your 3rd Great Grandparents

Each week on Randy Seaver’s Genea-musings blog he has a post for Saturday night Genealogy fun. Because of the time difference, I have called my series Sunday Afternoon Genealogy Fun. This week the mission was:

1)  We each have 32 3rd great grandparents.  How did their birth and death years vary?  How long were their lifespans?

2)  For this week, please list your 32 third great grandparents, their birth year, their death year, and their lifespan in years.  You can do it in plain text, in a table or spreadsheet, or in a graph of some sort.

3)  Share your information about your 32 great-great grandparents with us in a blog post of your own, in a comment to this blog post, or on Facebook or Google+.  Please leave a link to your information as a comment to this post.

Here’s mine

1 William Whimpey (1789-1870), 81 years

2 Elizabeth Clement (1792-1860), 68 years

3 John Price (-), ?

4  (-), ?

5 William Sharp (1795-1866), 71 years

6 Sarah Rose Crossley (1804-1868), 64 years

7 Mark Oldroyd (1791-1868), 77 years

8 Elizabeth Sidebottom (1796-1878), 82 years

9 John Harley (1792-1864), 72 years

10 Agnes Moncur (1793-1850), 57 years

11 John Dandie (1800-1841), 41 years

12 Catherine Hardie (1799-1867), 68 years

13 Garrett John Russell (1817-1877), 60 years

14 Susan Greene (1818-1884), 66 years

15 Thomas Doyle (1814-1886), 72 years

16 Catherine Mills (1818-1899), 81 years

17 John Marr (1790-1851), 61 years

18 Agnes Philp (1791-1864), 73 years

19 David Richardson (1806-after 1841), ?

20 Margaret Nicol (1791-1846), 55 years

21 William Reeves (1802-1877), 75 years

22 Maria Crook (1807-1871), 64 years

23 William Gill (1790-bet 1841 and 1851), between 51 and 61 years

24 Mary Scott (1792-1872), 80 years

25 Tempest Sell (1787-1861), 74 years

26 Jane Docwra (1800-1840), 40 years

27 Joseph Scott (1797-1846), 49 years

28 Mary Ann Muncy (1806-1841), 35 years

29 Frederick Oliver (1824-1855), 31 years

30 Susannah Campkin (1827-1880), 53 years

31 William Edward Ball (1825-1893), 68 years

32 Ann Slawson (1836-1878), 42 years

The average birth year is 1803, with a range from 1787 to 1836

The average death year is 1866, with a range from 1840 to 1899

The average life span is about 60 years, with a range from 31 to 82 years. Males average 64 years (31 to 81), and females average 62 years (35 to 82).

I used Microsoft Excel to do the calculations.  I started by entering the details into the spreadsheet from my family tree database.

family tree data

I then added a column for the age, and added the formula to calculate the age for each person.

I then sorted the sheet by birth year to find the earliest and latest birth years, and then the Average function in Excel to calculate the average birth year.  I then sorted by death year to find the earliest and latest and average death years.  I then did the same for the ages.

I then added another column to indicate whether the person was male or female, and sorted by gender, and then by age, to calculate the average age for each gender.

final data

I then copied the first five columns over to some blank cells on the right side of the spreadsheet, and sorted the list by number, and then used the Concatenate function to generate the list of my ancestors with their birth and death years and ages:

concatenate

  Background of featured image is a photo from Unsplash – https://unsplash.com/photos/RoRoAQTSnEU Photo by unsplash-logoUthpala Shyamendra