Finding Trend?

[15dgs]

Hello all!

I am working on a project that tracked participants eyes as they looked at various pictures. I now have several tables (for each of the different participants) and need a way to determine a trend. The tables currently have, where they looked (Location 1, 2, 3, 4, ext.) and how long they looked there for before looking away. Does anyone have any ideas how I can make excel find a trend between all of these tables? My main concern is that each table is a different size because everyone looked at different points for different amounts of time.

Thanks,
15dgs

 

[hawk771960]

Would you mind posting 2 examples of the data captured by your participants?

 

[15dgs]

Participant 1

[TABLE="width: 105"]
<colgroup><col width="47" style="width:35pt"><col width="58" style="width:44pt"></colgroup><tbody>[TR]
[TD="class: xl58, width: 47"]Location Looked[/TD]
[TD="class: xl58, width: 58, align: center"]Time Looked For[/TD]
[/TR]
[TR]
[TD="class: xl58, align: right"]10[/TD]
[TD="class: xl58, align: right"]217[/TD]
[/TR]
[TR]
[TD="class: xl58, align: right"]1[/TD]
[TD="class: xl58, align: right"]167[/TD]
[/TR]
[TR]
[TD="class: xl58, align: right"]2[/TD]
[TD="class: xl58, align: right"]550[/TD]
[/TR]
[TR]
[TD="class: xl58, align: right"]3[/TD]
[TD="class: xl58, align: right"]233[/TD]
[/TR]
[TR]
[TD="class: xl58, align: right"]4[/TD]
[TD="class: xl58, align: right"]467[/TD]
[/TR]
[TR]
[TD="class: xl58, align: right"]5[/TD]
[TD="class: xl58, align: right"]400[/TD]
[/TR]
[TR]
[TD="class: xl58, align: right"]6[/TD]
[TD="class: xl58, align: right"]2067[/TD]
[/TR]
[TR]
[TD="class: xl58, align: right"]7[/TD]
[TD="class: xl58, align: right"]1417[/TD]
[/TR]
[TR]
[TD="class: xl58, align: right"]1[/TD]
[TD="class: xl58, align: right"]567[/TD]
[/TR]
[TR]
[TD="class: xl58, align: right"]4[/TD]
[TD="class: xl58, align: right"]200[/TD]
[/TR]
[TR]
[TD="class: xl58, align: right"]10[/TD]
[TD="class: xl58, align: right"]283[/TD]
[/TR]
[TR]
[TD="class: xl58, align: right"]5[/TD]
[TD="class: xl58, align: right"]426[/TD]
[/TR]
[TR]
[TD="class: xl58, align: right"]2[/TD]
[TD="class: xl58, align: right"]483[/TD]
[/TR]
</tbody>[/TABLE]


Participant 2


[TABLE="width: 105"]
<colgroup><col width="47" style="width:35pt"> <col width="58" style="width:44pt"> </colgroup><tbody>[TR]
[TD="class: xl58, width: 47, align: right"]Location Looked


1[/TD]
[TD="class: xl58, width: 58, align: right"]Time Looked For

6633.5[/TD]
[/TR]
[TR]
[TD="class: xl58, align: right"]5[/TD]
[TD="class: xl58, align: right"]5783[/TD]
[/TR]
[TR]
[TD="class: xl58, align: right"]8[/TD]
[TD="class: xl58, align: right"]1966.5[/TD]
[/TR]
[TR]
[TD="class: xl58, align: right"]7[/TD]
[TD="class: xl58, align: right"]1064[/TD]
[/TR]
[TR]
[TD="class: xl58, align: right"]6[/TD]
[TD="class: xl58, align: right"]116[/TD]
[/TR]
[TR]
[TD="class: xl58, align: right"]3[/TD]
[TD="class: xl58, align: right"]349.9[/TD]
[/TR]
[TR]
[TD="class: xl58, align: right"]2[/TD]
[TD="class: xl58, align: right"]3833.5[/TD]
[/TR]
[TR]
[TD="class: xl58, align: right"]10[/TD]
[TD="class: xl58, align: right"]453[/TD]
[/TR]
</tbody>[/TABLE]




Participant 3

[TABLE="width: 105"]
<colgroup><col width="47" style="width:35pt"> <col width="58" style="width:44pt"> </colgroup><tbody>[TR]
[TD="class: xl58, width: 47, align: right"]Location Looked


1[/TD]
[TD="class: xl58, width: 58, align: right"]Time Looked For

5178.8[/TD]
[/TR]
[TR]
[TD="class: xl58, align: right"]5[/TD]
[TD="class: xl58, align: right"]1201.2[/TD]
[/TR]
[TR]
[TD="class: xl58, align: right"]8[/TD]
[TD="class: xl58, align: right"]185[/TD]
[/TR]
[TR]
[TD="class: xl58, align: right"]7[/TD]
[TD="class: xl58, align: right"]8698.6[/TD]
[/TR]
[TR]
[TD="class: xl58, align: right"]6[/TD]
[TD="class: xl58, align: right"]85[/TD]
[/TR]
[TR]
[TD="class: xl58, align: right"]9[/TD]
[TD="class: xl58, align: right"]1149.7[/TD]
[/TR]
[TR]
[TD="class: xl58, align: right"]10[/TD]
[TD="class: xl58, align: right"]2701.9[/TD]
[/TR]
</tbody>[/TABLE]


Sorry about the weird formatting, thank you!!