Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to delete multiple autoshape or objects in excel | Excel Discussion (Misc queries) | |||
delete multiple autoshapes or objects in excel | Excel Discussion (Misc queries) | |||
How do I make excel hide columns when it says cannot move objects | Excel Discussion (Misc queries) | |||
How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
how can I select multiple drawing objects at once | Excel Discussion (Misc queries) |