Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Time interval data and weighting

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
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
Help with time interval [email protected] Excel Worksheet Functions 10 December 27th 08 11:08 PM
x-axis time interval John Charts and Charting in Excel 1 June 7th 08 02:23 AM
Grouping a Set of Data By Time Interval Jon[_5_] Excel Discussion (Misc queries) 2 September 14th 07 09:06 AM
weighting data mmcap Excel Worksheet Functions 1 January 31st 07 06:44 PM


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