LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Ms MIS
 
Posts: n/a
Default Frequency distribution

I have a worksheet with two columns of data

Column A has contains a reference code, d1, d2, d3....and so on to d6
however, this code can occur more than once.
Column B has a random number against the reference codes (could be anything
between 1 -100) e.g.

d1 5
d2 7
d1 10
d3 1
d1 5
d5 6
d4 20
d4 5
d6 15
d5 6
d1 10

I would like to calculate the number of occurances of each reference code
with each number, i.e. the number of d1's with number 5 = 2, the number of
d1's with 10 = 1.

Can anyone help?

Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting - Frequency distribution. Stats guru Excel Discussion (Misc queries) 1 April 4th 05 04:16 AM
How do I create a Histogram for relative frequency distributions? pipereed Excel Discussion (Misc queries) 1 February 28th 05 03:40 AM
Frequency for Histograms in Excel Jim Charts and Charting in Excel 7 February 24th 05 07:33 PM
Cumulative Frequency Chris Grant Charts and Charting in Excel 2 February 3rd 05 05:49 AM


All times are GMT +1. The time now is 05:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"