Generating frequency distributions with Excel
Category: Mac, Category: MS Excel
Originally posted on my iBlog 21 December 2002.
I've written this down because I keep forgetting it. This is how you take one column of numbers and turn them into a table of frequencies (e.g., to make a histogram of class exam scores).
First column (Ax:Ay) is the data
Second column (Bx:Bw) are the frequency categories (e.g., 10, 20, 30, etc.)
Beginning with the uppermost cell, select the cells in the third column alongside the frequency categories (i.e., Cx:Cw). Without deselecting, type "=frequency(Ax:Ay, Bx:Bw)". Now press command-return. All of the cells in this column will fill with the frequencies.
Originally posted on my iBlog 21 December 2002.
I've written this down because I keep forgetting it. This is how you take one column of numbers and turn them into a table of frequencies (e.g., to make a histogram of class exam scores).
First column (Ax:Ay) is the data
Second column (Bx:Bw) are the frequency categories (e.g., 10, 20, 30, etc.)
Beginning with the uppermost cell, select the cells in the third column alongside the frequency categories (i.e., Cx:Cw). Without deselecting, type "=frequency(Ax:Ay, Bx:Bw)". Now press command-return. All of the cells in this column will fill with the frequencies.
