Forums
Calculating % differences in reviews - Printable Version

+- Forums (https://www.babeltechreviews.com/community)
+-- Forum: BabelTechReviews (https://www.babeltechreviews.com/community/forumdisplay.php?fid=3)
+--- Forum: Everything BabelTech Related (https://www.babeltechreviews.com/community/forumdisplay.php?fid=14)
+--- Thread: Calculating % differences in reviews (/showthread.php?tid=662)

Pages: 1 2


Calculating % differences in reviews - apoppin - 08-07-2016

It has always taken me too long. But now I am getting requests to do it.

Is this an easy way? Just plug in the two numbers and hit enter?

http://www.marshu.com/articles/calculate-percentage-increase-decrease-percent-calculator.php
e.g. GTX 1080 69.5 vs TITAN X 82.2 = 18.3% performance change

And this one is similar, but it gives different results

http://www.calculatorsoup.com/calculators/algebra/percent-difference-calculator.php
e.g. GTX 1080 69.5 vs TITAN X 82.2 =
16.7% difference

Hmm ... I am a little confused this morning, which one should I use? One is performance difference, the other is performance change. I am guessing the first one, difference. Please confirm or explain. Thanks.
Blush


The old way takes a minute for each of 75 results ....
Quote: To calculate the percentage increase: First: work out the difference (increase) between the two numbers you are comparing. Then: divide the increase by the original number and multiply the answer by 100. If your answer is a negative number then this is a percentage decrease.

If I can just use a percentage calculator, I can cut my time by 3/4s and I can add the results to each of my reviews
Cool


RE: Calculating % differences in reviews - SickBeast - 08-07-2016

Use a formula in Excel. It will do it for you automatically. There is a way to do it. First, go to the cell directly to the right of the data you're working with. Then type "=" in that cell. Then, click the first cell, type "/" (for divided by), click the second cell, then type "*100" (for times 100) and press "enter" (no quotes for any of this). Then you use the "fill down" command and Excel will automatically do it for you for all of your data all the way down the chart.

I'm pretty sure that's how it works. If you want, send me one of your charts and I will see if I can implement it for you.

Also, it will have to be modified a bit to show the percentage faster or slower, let me have a look at it. This is going to show you the percentage out of 100, not the difference. We might have to add a second formula.

*edit* I figured it out! You need to do a second formula. Just go one cell to the right of your first formula and type "=100-" and then click on the cell of the previous formula and press "enter". That will give you how much faster the first one is compared to the second one in terms of a percentage.


RE: Calculating % differences in reviews - apoppin - 08-07-2016

For now, Can I just use one of the two calculators? See my edit in the OP. One is percentage differences and the other is percentage of change. It would be quick enough for today's results.

I would have to change all of my Excel numbers on the chart as they are not standard - I have averages next to minimums. The calculations won't work. I just want to compare averages.


RE: Calculating % differences in reviews - SickBeast - 08-07-2016

Yes you can use a calculator. All you do is divide the first number by the second number. For example, if the RX480 got 90fps and the GTX 1060 got 100fps, you would do 90 divided by 100, which gives you .9. Multiply that times 100 and you will get 90. Then do 100 subtract 90, and it will tell you that the RX480 is 10 percent slower.

Actually an even quicker way might be to divide the bigger number by the smaller number. In this case you can do 100 divided by 90, which gives you 1.11 which means that the GTX 1060 is 11 percent faster.

There is some weird thing where the RX480 would be 10 percent slower but the GTX 1060 would be 11 percent faster. It's hard to explain and it's hard to understand.

Also, as for your charts, if you change the formatting slightly I could set up a formula to do it automatically for you. You would just need to add a separate column for your minimums but I'm sure you could set it up such that it would be the same visually.

*edit* And yes, you can use that calculator but you can just use any calculator like I explained in my second method. All that site is doing is dividing the bigger number by the smaller number.


RE: Calculating % differences in reviews - apoppin - 08-07-2016

I'd rather not use a calculator. Can I just use the first website and plug in the two numbers?
http://www.calculatorsoup.com/calculators/algebra/percent-difference-calculator.php

It is much faster than using a calculator if it is accurate. Is it accurate???? Does it show by how much the Titan X is faster than the GTX 1080?
Huh

The 2nd website shows "percentage of change" ... Not the one that I should use, correct?

For my NEXT (Next) evaluation, I can set up Excel differently for the automatic calculation. But not now, it will take too much time.

(08-07-2016, 03:01 PM)SickBeast Wrote: Yes you can use a calculator.  All you do is divide the first number by the second number.  For example, if the RX480 got 90fps and the GTX 1060 got 100fps, you would do 90 divided by 100, which gives you .9.  Multiply that times 100 and you will get 90.  Then do 100 subtract 90, and it will tell you that the RX480 is 10 percent slower.

Actually an even quicker way might be to divide the bigger number by the smaller number.  In this case you can do 100 divided by 90, which gives you 1.11 which means that the GTX 1060 is 11 percent faster.

There is some weird thing where the RX480 would be 10 percent slower but the GTX 1060 would be 11 percent faster.  It's hard to explain and it's hard to understand.

Also, as for your charts, if you change the formatting slightly I could set up a formula to do it automatically for you.  You would just need to add a separate column for your minimums but I'm sure you could set it up such that it would be the same visually.

*edit* And yes, you can use that calculator but you can just use any calculator like I explained in my second method.  All that site is doing is dividing the bigger number by the smaller number.



RE: Calculating % differences in reviews - SickBeast - 08-07-2016

It looks accurate to me. It looks like it's taking the aggregate between the two methods that I explained to you. I think you should be fine using it.


RE: Calculating % differences in reviews - apoppin - 08-07-2016

OK.  Thank-you.  

The second website calculates something different, right?
---Percentage of change.

http://www.marshu.com/articles/calculate-percentage-increase-decrease-percent-calculator.php

It got me somewhat confused first thing in the morning.
:s

As you can see, using the website calculator is faster than using a calculator ... it saves a couple of steps and if it is accurate, will make the difference between using percentages in my reviews and not using them. Later on, I will set up my Excel charts differently so I can use the automatic method.

Thanks for your help!


RE: Calculating % differences in reviews - SickBeast - 08-07-2016

Yeah it's confusing. As I explained, percent slower and percent faster are different. I like the second one you showed me because it looks like it splits the two figures down the middle.

Either way it's not going to make a very big difference percentage wise.

This is the one I like:

http://www.calculatorsoup.com/calculators/algebra/percent-difference-calculator.php


RE: Calculating % differences in reviews - apoppin - 08-07-2016

(08-07-2016, 03:17 PM)SickBeast Wrote: Yeah it's confusing.  As I explained, percent slower and percent faster are different.  I like the second one you showed me because it looks like it splits the two figures down the middle.

Either way it's not going to make a very big difference percentage wise.

This is the one I like:

http://www.calculatorsoup.com/calculators/algebra/percent-difference-calculator.php

Actually, calculator soup is the first one that I showed (% differences), not the second (Marshu - % increase or decrease)

OOPs, you are referring to the OP. You are correct. I am still tired/confused
Blush

I will use calculator soup
http://www.calculatorsoup.com/calculators/algebra/percent-difference-calculator.php
Thanks a lot!!


RE: Calculating % differences in reviews - SickBeast - 08-07-2016

No problem! Good luck finishing up the article! Let me know for your next one and I will help you automate it in Excel.