Red shirt analysis using Powerpoint and Excel

A good example of how to present data effectively – using data from a 60’s TV show.

Anyone who has followed Star Trek probably knows about the ‘red shirt’ phenomenon – in the original show any character wearing a red shirt was likely to die after beaming down to a planet.

But it takes the particular type of fan that Star Trek has produced to do a comprehensive analysis. Matt Bailey has done just that using Powerpoint and Excel charts.

It’s a good example of the options in presenting data – you should choose the tool (Powerpoint or Excel) that suits the data not the other way around.

The PPT slides were poorly made to over-emphasise his point.  The Excel chart is impressive though it’s so long and detailed that it would not be much use in a presentation, it’s great for online use where you can zoom in.

What’s really worrying is that someone has tabulated all the ‘fatality’, love affair and other data from the shows at all – such is the love of Star Trek in some circles.  How bored do you have to be to make a database of ‘deaths’ in a 60’s TV show?  Perhaps it has something to do with the lack of new Star Trek TV or movies – fans have to comb the depths of past shows for new ‘insights’.

Join Office for Mere Mortals today

Office for Mere Mortals is where thousands pick up useful tips and tricks for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  We've never spammed or sold addresses since we started over twenty years ago.
Invalid email address