W
William Elerding
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
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