![]() |
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 |
All times are GMT +1. The time now is 06:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com