Skip to content

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

About this author

Office 2024 - all you need to know. Facts & prices for the new Microsoft Office. Do you need it?

Microsoft Office upcoming support end date checklist.