Calculating A Percentage Difference In Excel… The Fastest Balls In Wimbledon…


Wimbledon 2013

I am a huge tennis fan (in particular Wimbledon), and the speed of the balls amaze me.  So, just how much faster were the fastest balls this year in Wimbledon compared to last year?.  A good excuse to flex a bit of Excel muscle and look at percentage difference between the two.

So, I took data from the Wimbledon websites for both 2012 and 2013.  I focused in on the gentlemen’s singles serve speeds.  Let’s take a look at the top five service speeds and see the percentage difference of the top five.

Here’s the data….

wimbledon percent increase_1
So, we now can construct a formula to see the percentage difference between 2013 and 2012 fastest servers of each year.

So, start with the = sign as we a building a formula and take 2012 figure from this years. So for the fastest speed of 143 in 2013 we have an equivalent of 140 in 2012.

=(E3-K3)  this part of the formula is in brackets as we want this part to be calculated first, then divide by 143 or E3 again

=(E3-K3)/E3

 

All we need then need to do is format the result as a percentage.

 

Home Tab >Number>Percent Style

wimbledon percent increase_3

 

 

Here we now have the percentage difference between 2013 and 2012 fastest serves.

wimbledon percent increase_2

 

I would not like to be at the receiving end of a tennis ball at 143mph!!!

 

 

 

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts