Alrighty here's the first graph. Note that this is average speed, so any trips with an average speed near the right by definition have some parts of the trip faster than the average, so the actual drop at 80 mph isn't quite as severe as it looks.
This is really great - thanks so much for posting! I've been hunting for a similar curve for Teslas for a while.
Can I ask:
* Which car models are included?
* You write that your methodology for this chart looks at average speed for the whole trip; if this is true, would it be feasible to apply a different methodology and divide your data up into much smaller chunks (e.g. 30 seconds) and calculate the MPGe for each chunk?
* Is there any way I could calculate a similar graph for my own car? Can I get a graph like this from your app? (I'd personally be super-interested in both being able to access my own car's curve, and also explore a 'dashboard' of the whole dataset with filters by (e.g.) model, wheel size, etc.
Cool! Can you make a graph quantifying the fixed costs of startup somehow? The startup costs do seem really high, to the point where it's pretty much impossible to hit the rated efficiency unless your trip is longer than 10-20 minutes to amortize the startup costs. I'm glad someone else has noticed this.
I’d love to see them!