Response:

Hello! This was written 2012-JUN-28 at 13:26 AM ET.

Question: What is a frequency distribution?

Answer: A frequency distribution is a powerful, non-linear way to analyze your website performance data. It is a way to show the number of times (frequency) a data or value appears in a given range or interval (distribution). Consider these two basic examples:

Example One:

Take the following numbers 1, 2, 4, 7 and 9. How many are between 1-5? How many are between 6-10? (Three numbers (numbers 1, 2 and 4) are between 1-5. Two numbers (numbers 7 and 9) are between 6-10.)

Example Two:

Take the following hypothetical test letter grades A, B, A, B, A, C, B and D. How many of each letter grades are there? (There are three “A”. There are three “B”. There is one “C”. There is one “D”.)

Now we will use Excel’s FREQUENCY command to distribute thousands of Webpage Response times. Fear not! Just see the attached excel sheet showing how we came up with the following frequency distribution chart:

Document Complete / OnLoad:

_The following is optional reading material._

Download the excel file here: https://docs.google.com/open?id=0B9n5Sarv4oonRVZGTFlmaWk4S3c

#ExcelArrayFormula #ExcelStatistics #CatchpointUser #KeynoteUser #GomezUser #FrequencyDistribution

### Like this:

Like Loading...

*Related*

[…] on the Rates of Change (for a refresher on Frequency Distributions, consider reading Webtortoise: What the Frequency?) to answer the question(s), “How many Rates of Change were less than 1%? How many Rates of […]

Pingback by Configuring “Site is Slow” Performance Alerts « Web Tortoise — 2012-Nov-28 @ 11:33 AM EDT

[…] Excel Frequency Distribution: How many Response Times were between 0-1,000ms? How many Response Times were between […]

Pingback by WebTortoise Year in Review 2012 « Web Tortoise — 2012-Dec-20 @ 03:37 PM EDT