# How to rank observations with two variables (website performance)

I have no background in statistics, so I find myself confused by this simple problem. I'm not even sure which search terms to use.

I have some website performance data. I have the number of times a page was requested/visited, and how long it took to load (average time and percentiles in seconds).

I want to identify pages that are often requested/visited but take a long time to load. So for example, if an "FAQ" page takes 30 seconds to load but is only visited a few times a day, this is less important than a "Search" page that takes 2 seconds to load but is used thousands of times a day. The purpose is to make a "Top 10" list or something like that which some website developers will use to improve performance.

I had thought to do something simple like create a new column with NUM_TRANSACTIONS * AVERAGE and sort that, but I'm wondering if there is something wrong with this approach.

SOLVED: Edgar's answer worked well for me. I created the plot he suggested, and the scoring mechanism, and they produced similar results. The number markers indicate ranking.

• Log scale often helps on such graphs. – Nick Cox Apr 24 '19 at 20:41
• On log scale lines with $xy$ constant are straight too. – Nick Cox Apr 24 '19 at 21:24
• Thanks for the tip, @NickCox, it is easier to read now. I don't understand your second comment though. Are you suggesting another improvement? – DavidS Apr 24 '19 at 21:30
• You are interested in the product $xy$ of your two variables. On log scale hyperbolas $xy =$ constant are mapped to straight lines $\log x + \log y =$ another constant. I find straight lines easier to compare than hyperbolas. Also, log scale will spread your data more evenly. – Nick Cox Apr 24 '19 at 21:36
• Thanks for explaining, @NickCox. It's a big help. – DavidS Apr 25 '19 at 17:10

• Just checking, but I think you must mean TOTALAVERAGE = (sum of all (NUM_TRANSACTIONS*AVERAGE))/(sum of all NUM_TRANSACTIONS)? – DavidS Apr 24 '19 at 18:49