Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On Oct 25, 7:51*pm, fluff wrote:
Hi, I have a tricky question: I am comparing time interval data between two groups. To simplify things, I'll use leaves for my example. Okay. There is a tree. There are three types of leaves on this tree: Red, Green and Yellow. There are equal numbers of leaves of each colour. The leaves fall to the ground one by one. I want to compare the time intervals between consecutive pairs of same coloured leaves falling to the ground with consecutive pairs of different coloured leaves falling to the ground. My data is in seconds. Here is my example : First data set *(Group 1) * * * * * * * * * * * * * * * * * * * * * * * * * * * COLUMN A time interval between red leaf and another red leaf = 8739 seconds time interval between yellow leaf and another yellow leaf = 7290749 seconds time interval between red leaf and another red leaf = 2093730 seconds time interval between green leaf and another green leaf = * * * * 27 seconds Second data set (Group 2) * * * * * * * * * * * * * * * * * * * * * * * * * *COLUMN B time interval between red leaf and a green leaf = 853567seconds time interval between yellow leaf and a red leaf = 466 seconds time interval between red leaf and a green leaf = 68086 seconds time interval between yellow leaf and a green leaf = 4787 seconds I want to compare the time intervals between column A and column B ( i.e does the data in column A have smaller mean time interval to the data in column B?) except I have to weight the data, because for example, there is more chance of a red leaf falling after a non red leaf (because there are two other different colours). Does this make sense? I hope someone can help me with this query. Many thanks. I forgot to mention... I need to know how to weight the data accordingly. Would anyone be able to help? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with time interval | Excel Worksheet Functions | |||
x-axis time interval | Charts and Charting in Excel | |||
Grouping a Set of Data By Time Interval | Excel Discussion (Misc queries) | |||
weighting data | Excel Worksheet Functions |