Date: Thu, 17 Oct 2002 11:48:44 +0000
Reply-To: Ahmed El-Masry <elmasry10@hotmail.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Ahmed El-Masry <elmasry10@hotmail.com>
Subject: paired t-test
Content-Type: text/html
<html><div style='background-color:'><DIV>Hello,</DIV>
<DIV>I have regression coefficients for 401 companies of two variables and now I need to do paired t-test to test whether there are significant differences regarding these two variables or not for each company. I have got the standard error for each variable.</DIV>
<DIV> </DIV>
<DIV>here is a example for my data</DIV>
<DIV>
<TABLE style="WIDTH: 240pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=319 border=0 x:str>
<COLGROUP>
<COL style="WIDTH: 106pt; mso-width-source: userset; mso-width-alt: 5156" width=141>
<COL style="WIDTH: 73pt; mso-width-source: userset; mso-width-alt: 3547" width=97>
<COL style="WIDTH: 61pt; mso-width-source: userset; mso-width-alt: 2962" width=81>
<TBODY>
<TR style="HEIGHT: 12.75pt" height=17>
<TD class=xl27 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; WIDTH: 106pt; BORDER-BOTTOM: #c0c0c0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=141 height=17>
<P><STRONG><FONT face="Times New Roman" size=2></FONT></STRONG> </P>
<P><STRONG><FONT face="Times New Roman" size=2>Name </FONT></STRONG></P></TD>
<TD class=xl27 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; WIDTH: 73pt; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" width=97><STRONG><FONT face="Times New Roman" size=2> Unexpected</FONT></STRONG></TD>
<TD class=xl27 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; WIDTH: 61pt; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" width=81><STRONG><FONT face="Times New Roman" size=2> expected</FONT></STRONG></TD></TR>
<TR style="HEIGHT: 12.75pt" height=17>
<TD class=xl24 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17><FONT face="Times New Roman" size=2>10 Group</FONT></TD>
<TD class=xl26 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="-0.2607088779653835"><FONT face="Times New Roman" size=2>-0.26071</FONT></TD>
<TD class=xl25 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="-0.19790901943488193"><FONT face="Times New Roman" size=2>-0.1979</FONT></TD></TR>
<TR style="HEIGHT: 12.75pt" height=17>
<TD class=xl24 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17><FONT face="Times New Roman" size=2>4imprint Group</FONT></TD>
<TD class=xl26 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="-3.6560056171664544E-2"><FONT face="Times New Roman" size=2>-0.03656</FONT></TD>
<TD class=xl25 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="0.13395297597618458"><FONT face="Times New Roman" size=2>0.1340</FONT></TD></TR>
<TR style="HEIGHT: 12.75pt" height=17>
<TD class=xl24 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17><FONT face="Times New Roman" size=2>600 Group</FONT></TD>
<TD class=xl26 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="0.42043817857547955"><FONT face="Times New Roman" size=2>0.42044</FONT></TD>
<TD class=xl25 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="0.26831175959355502"><FONT face="Times New Roman" size=2>0.2683</FONT></TD></TR>
<TR style="HEIGHT: 12.75pt" height=17>
<TD class=xl24 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17><FONT face="Times New Roman" size=2>Abbot Group</FONT></TD>
<TD class=xl26 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="-1.2741928159212814E-2"><FONT face="Times New Roman" size=2>-0.01274</FONT></TD>
<TD class=xl25 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="-0.11332361883373662"><FONT face="Times New Roman" size=2>-0.1133</FONT></TD></TR>
<TR style="HEIGHT: 12.75pt" height=17>
<TD class=xl24 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17 x:str="Actionleisure "><FONT face="Times New Roman" size=2>Actionleisure </FONT></TD>
<TD class=xl26 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="-0.49585445558204561"><FONT face="Times New Roman" size=2>-0.49585</FONT></TD>
<TD class=xl25 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="-4.1173651315081765E-2"><FONT face="Times New Roman" size=2>-0.0412</FONT></TD></TR>
<TR style="HEIGHT: 12.75pt" height=17>
<TD class=xl24 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17><FONT face="Times New Roman" size=2>African Lakes</FONT></TD>
<TD class=xl26 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="0.2106036234988129"><FONT face="Times New Roman" size=2>0.21060</FONT></TD>
<TD class=xl25 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="-0.17358826890884135"><FONT face="Times New Roman" size=2>-0.1736</FONT></TD></TR>
<TR style="HEIGHT: 12.75pt" height=17>
<TD class=xl24 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17><FONT face="Times New Roman" size=2>Aga Foodservice</FONT></TD>
<TD class=xl26 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="0.24787987917307286"><FONT face="Times New Roman" size=2>0.24788</FONT></TD>
<TD class=xl25 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="-8.5071338228947732E-2"><FONT face="Times New Roman" size=2>-0.0851</FONT></TD></TR>
<TR style="HEIGHT: 12.75pt" height=17>
<TD class=xl24 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17><FONT face="Times New Roman" size=2>Aggregate Industries</FONT></TD>
<TD class=xl26 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="0.56640634102627863"><FONT face="Times New Roman" size=2>0.56641</FONT></TD>
<TD class=xl25 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="-0.65663896845303116"><FONT face="Times New Roman" size=2>-0.6566</FONT></TD></TR>
<TR style="HEIGHT: 12.75pt" height=17>
<TD class=xl24 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17><FONT face="Times New Roman" size=2>Airflow Streamlines</FONT></TD>
<TD class=xl26 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="-0.23868250351395773"><FONT face="Times New Roman" size=2>-0.23868</FONT></TD>
<TD class=xl25 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="-7.8126195008069291E-2"><FONT face="Times New Roman" size=2>-0.0781</FONT></TD></TR>
<TR style="HEIGHT: 12.75pt" height=17>
<TD class=xl24 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17><FONT face="Times New Roman" size=2>Albert Fisher</FONT></TD>
<TD class=xl26 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="0.38284163250317543"><FONT face="Times New Roman" size=2>0.38284</FONT></TD>
<TD class=xl25 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="-1.1289715416251962"><FONT face="Times New Roman" size=2>-1.1290</FONT></TD></TR>
<TR style="HEIGHT: 12.75pt" height=17>
<TD class=xl24 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17><FONT face="Times New Roman" size=2>Albion</FONT></TD>
<TD class=xl26 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="-7.4192577506335261E-2"><FONT face="Times New Roman" size=2>-0.07419</FONT></TD>
<TD class=xl25 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="0.39159767220772873"><FONT face="Times New Roman" size=2>0.3916</FONT></TD></TR>
<TR style="HEIGHT: 12.75pt" height=17>
<TD class=xl24 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17><FONT face="Times New Roman" size=2>Alexon Group</FONT></TD>
<TD class=xl26 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="-5.3200248822717726E-2"><FONT face="Times New Roman" size=2>-0.05320</FONT></TD>
<TD class=xl25 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="5.681905990229006E-2"><FONT face="Times New Roman" size=2>0.0568</FONT></TD></TR>
<TR style="HEIGHT: 12.75pt" height=17>
<TD class=xl24 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17><FONT face="Times New Roman" size=2>Alldays</FONT></TD>
<TD class=xl26 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="-0.21981589814965136"><FONT face="Times New Roman" size=2>-0.21982</FONT></TD>
<TD class=xl25 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="-0.18748290745025478"><FONT face="Times New Roman" size=2>-0.1875</FONT></TD></TR>
<TR style="HEIGHT: 12.75pt" height=17>
<TD class=xl24 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17><FONT face="Times New Roman" size=2>Allied Domecq</FONT></TD>
<TD class=xl26 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="0.37072813220697709"><FONT face="Times New Roman" size=2>0.37073</FONT></TD>
<TD class=xl25 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="5.1945526072977484E-2"><FONT face="Times New Roman" size=2>0.0519</FONT></TD></TR>
<TR style="HEIGHT: 12.75pt" height=17>
<TD class=xl24 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17><FONT face="Times New Roman" size=2>Alvis</FONT></TD>
<TD class=xl26 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="-0.17384800950364773"><FONT face="Times New Roman" size=2>-0.17385</FONT></TD>
<TD class=xl25 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="-0.11357457778036446"><FONT face="Times New Roman" size=2>-0.1136</FONT></TD></TR>
<TR style="HEIGHT: 12.75pt" height=17>
<TD class=xl24 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17><FONT face="Times New Roman" size=2>Andrews Sykes</FONT></TD>
<TD class=xl26 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="0.11856398199099771"><FONT face="Times New Roman" size=2>0.11856</FONT></TD>
<TD class=xl25 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="6.1531182560855553E-2"><FONT face="Times New Roman" size=2>0.0615</FONT></TD></TR>
<TR style="HEIGHT: 12.75pt" height=17>
<TD class=xl24 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17><FONT face="Times New Roman" size=2>Anite Group</FONT></TD>
<TD class=xl26 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="0.22265467340381701"><FONT face="Times New Roman" size=2>0.22265</FONT></TD>
<TD class=xl25 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0; BACKGROUND-COLOR: transparent" align=right x:num="-0.23405503139904438"><FONT face="Times New Roman" size=2>-0.2341</FONT></TD></TR></TBODY></TABLE></DIV>
<DIV></DIV>
<DIV>.</DIV>
<DIV>.</DIV>
<DIV>.</DIV>
<DIV>and so on</DIV>
<DIV> </DIV>
<DIV>Thank you in advance for your help,</DIV>
<DIV> </DIV>
<DIV>Ahmed</DIV>
<DIV> </DIV></div><br clear=all><hr>Surf the Web without missing calls! Get MSN Broadband. <a href="http://g.msn.com/8HMAEN/2022">Click Here</a> </html>
| 
