Comparing data from two different matrix

[gisluis]

I have two matrix's with Station to Station information. First Matrix's has Station to Station Milage. The second matrix has Station to Station number of commuters.

There are a total of 54 Stations.

I want to create a bell curve chart/graph that shows the total number of commuters and the miles they travel. I need all of the miles within the first matrix to be included and the commuters to be added together is the milage is the same. Basically merging the two matrix into one.

I am a newbie, and would appreciate your help. Or at least a direction of where to look. thanks,

 

[NdNoviceHlp]

Welcome to the Board! You better give these guys some more info. Your project seems interesting. I'll get the ball rolling with these... Do you want a spreadsheet or VBA solution? Where is your data? Are you saying that Matrix1 first array position represents total miles which you want to multiply by Matrix2 first array position which is total commuters? This total then represents your total sample for construction of your normal curve? (I believe Tushar Meta's site has some info re. normal curves). Hope this helps. Dave