I want to find out what the average screen resolution is for visitors to my website – or rather, what is the average width and the average height in pixels.
To qualify what I mean by "average" – and maybe "average" isn't the right word (though I think most of the respondents understood my meaning) – I would like to know when a hypothetical "average" visitor comes to my website, what would their screen height and width be?
I realize it's by no means the end of a comprehensive analysis of screen resolutions, and I recognize the saying that "analyzing averages tends to produce average results"…
My data looks like this:
+-------+--------+----------+
| Width | Height | Sessions |
+-------+--------+----------+
| 1366 | 768 | 72212 |
| 768 | 1024 | 71440 |
| 1920 | 1080 | 41332 |
| 1280 | 800 | 37427 |
| 1600 | 900 | 34688 |
| 1280 | 1024 | 27461 |
| 1440 | 900 | 27008 |
| 1024 | 768 | 26432 |
| 320 | 568 | 22239 |
| 1680 | 1050 | 16980 |
| 1280 | 720 | 16543 |
| 320 | 480 | 16400 |
| 360 | 640 | 13889 |
| 720 | 1280 | 9777 |
| 1093 | 614 | 9283 |
| 1536 | 864 | 8523 |
| 1920 | 1200 | 7110 |
| 2560 | 1440 | 4032 |
+-------+--------+----------+
I tried making a pivot table but that didn't work
My issue is that Sessions column, which obviously complicates things
Another question that comes to mind, and may also be answered through this analysis includes (though not officially a part of this question):
What % of sessions had a screen height/width of over/under X pixels?
As well as segmenting by desktop and tablet users
Best Answer
This is what I came up with.
Screenshot
Explained
Column F expresses the weight of the measurement in the series. Multiplying the height and the width by the fraction, will yield the corresponding fraction. A summation will yield a weighed height and width.
Example
I've created an example file for you: Average Resolution