LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 12
Default Bin, Distribution multiple objects???

Good morning!

I am having a problem trying to analyze the following data:

Sample of many different processes, and how long they took. I need to take
the data below (2-5K occurances) and set-up a table delineating each Process
and each occurance (time). The output I'd like is shown at the bottom of
this post. I'd like to use Bin/Histogram to summarize this data.
Unfortunately, I can't figure how to seperate the occurance by process so
that I can use the Analytic tools for Histogram. Does anyone have any
suggestions? THANKS! -Bill

Hour Process
0.2 C
0.1 A
1.3 V
5 G
6.2 R
5.3 S
0.3 G
0.4 A
0.9 A
0.4 C
0.2 B
0.6 F
0.2 B
0.3 B
0.1 B

What I'd like it to look like:

Process Occurance Times
A 0.1 0.4 0.9
B 0.2 0.2 0.3 0.1
C 0.2 0.4
F 0.6
V 1.3
G 5 0.3
R 6.2
S 5.3

 
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
how to delete multiple autoshape or objects in excel ron Excel Discussion (Misc queries) 4 January 26th 06 11:01 PM
delete multiple autoshapes or objects in excel ron Excel Discussion (Misc queries) 3 January 26th 06 03:01 PM
How do I make excel hide columns when it says cannot move objects Dale Excel Discussion (Misc queries) 0 November 10th 05 02:44 PM
How do i auto create multiple files from 1 with multiple sheets Kathy Excel Worksheet Functions 0 July 26th 05 01:23 AM
how can I select multiple drawing objects at once ExcelUser Excel Discussion (Misc queries) 1 February 11th 05 10:42 AM


All times are GMT +1. The time now is 09:47 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"