Of course, I couldn’t just close the spreadsheet once I’d worked out our total mileage. I did a few sums to look at the average daily distances that we walked.
Overall we walked on 80 days, covering 1240 miles, so on the simplest level we covered an average of just over 15 miles per day. But that’s a skewed figure, because in lieu of taking rest days, we had some short days (the shortest being just under 4.25 miles).
So, to give a truer figure, I categorised our walking days into ‘full’ and ‘half’ days. A bit of an arbitrary categorisation, with the definition of ‘full’ being over 10 miles, and half being 10 miles or under.
Working on that basis, we averaged around 16.5 miles per day on a full day and around 7.5 miles per day on a half day.
Mick not only did some rather more complicated sums, but he also did some pretty pictures to illustrate. The graph above shows our five day running average mileage for the duration (Miles are up the side, the day number is across the bottom; you can spot where the short and the rest days fell!).
Overall we walked on 80 days, covering 1240 miles, so on the simplest level we covered an average of just over 15 miles per day. But that’s a skewed figure, because in lieu of taking rest days, we had some short days (the shortest being just under 4.25 miles).
So, to give a truer figure, I categorised our walking days into ‘full’ and ‘half’ days. A bit of an arbitrary categorisation, with the definition of ‘full’ being over 10 miles, and half being 10 miles or under.
Working on that basis, we averaged around 16.5 miles per day on a full day and around 7.5 miles per day on a half day.
Mick not only did some rather more complicated sums, but he also did some pretty pictures to illustrate. The graph above shows our five day running average mileage for the duration (Miles are up the side, the day number is across the bottom; you can spot where the short and the rest days fell!).
Wowza! This sounds fascinating. (Well, I think so anyway..) Can you make the picture a bit bigger so I can read it?
ReplyDeleteCheers
A
I tried a few things to get that graph (which started out as a readable size) to show at a reasonable scale. Then I gave up trying to do clever things and went for the easy option. So, the graph is now at the top (which is where Blogger wanted to put it), so if you click on it, you'll get the full size version.
ReplyDeleteOoh Ta Gayle! - Good ol' Blogger eh? I just leave the piccies where they land now when I put them in - if I try to move them you only ever get a titchy picture.
ReplyDeleteI am sure if I was techie enough there would be a way of sorting this: John Hee did when he put all the pictures in my blog for me.
I shall now study and ponder your wonderful graph. I DO like graphs.....