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:
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.)
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