Category : Financial and Statistics
Archive   : STATPA.ZIP
Filename : STATPACK.XLM

 
Output of file : STATPACK.XLM contained in archive : STATPA.ZIP

@ ¹#ÑN0 d
ü©ñÒMbP?"*+%1 ÈHelv2"1 ÈHelv2¼"1 ÈHelv2"1 ÈHelv2¼"&fPage &p&è?'è?(ð?)ð[email protected]$¶!$¶!$¶!$¶!$ ¶!$ ¶!$

¶!$¶!
TEST.XLS
STATS.XLSGeneral00.00#,##0 #,##0.00$#,##0 ;($#,##0)$#,##0 ;[Red]($#,##0)$#,##0.00 ;($#,##0.00)$#,##0.00 ;[Red]($#,##0.00)0%0.00% 0.00E+00m/d/yy d-mmm-yyd-mmmmmm-yy
h:mm AM/PM
h:mm:ss AM/PMh:mmh:mm:ss m/d/yy h:mm m/ CalcFDist,  m/ CalcTDist,
m/
CalculateSums"CORR, Correlation­®çaè? COUNTERCOUNTERCCOUNTERRCriteriaDatabase Data_Form DFdfDenomdfNum DiffXY, dXYÀ  E_D<
E_D2ˆ E_N
E_Nx

E_Ny  E_X
E_X2G
E_XY‰  E_Y‚
E_Y2J"FDIST,  FVAL…ëQ¸^[email protected]  JJÇqÇqÌ?  KKÇqÇqŒ?  LLÍ VW¾²@ mywordÕ\~-X~
Print_Area Print_Titles PROBµ¹ªàwë? Recorder RR"RTVAL,
 RVAL333333ã?  Sd^´:%7é?  SEM6FuÏôÙ@  SmallF,  SmallR,
 SmallT,
SQUARE[_~-u‡X~ SS"SUMSQ, SumX, SumXY, SumY,  S_2ˆ‡‡‡‡‡@ "TDIST,
"TNULL,TOTALGTOTAL_N
TOTAL_XÞ TOTAL_XYÔ×À  TOTAL_Y fÀ "TPAIRED, TT" TUNPAIRED, TVALÊõ;?…@  Tx2 Ty2 T_N
 T_XÞ T_X2 ä A  T_XYÔ×À  T_Y fÀ 
T_Y2ýX•_~[email protected]RX~ XXXÎüjP? Y[email protected]RX~ YYrË´Pú?  ZZ@.qä[email protected] #

T
x

Z
Ÿ
µ
8
s
²


O


v
Ð

¼
ç
Œ
Í

$
!
–
u
+

I
M
:
’
O
QÀSUMSQ0[email protected](SUMSQ(X1:Xn) - Calculates Sum of Squares QÀCORR>[email protected]6CORR(X1:Xn,Y1:Yn) - Calculates Correlation Coefficient
QÀTNULLG[email protected]?TNULL(X1:Xn) - Performs T-Test on One Group whether Ho is FalseRÀ TUNPAIRED9[email protected]1TUNPAIRED(X1:Xm,Y1:Yn) - Performs Unpaired T-TestRÀTPAIRED5 [email protected]-TPAIRED(X1:Xn,Y1:Yn) - Performs Paired T-Test

RÀTDISTB [email protected]:TDIST(T-Value, df) - Converts T-Value to Probability Value
RÀFDISTG
[email protected]?FDIST(F-Value, df Numerator, df Denominator) - Converts F-Value SÀSumXcÀ[email protected]cÀ[email protected]B[email protected]:(i.e., Is the Group Mean Significantly Different From "0")
Cÿÿ TVALBQC [email protected];This program is taken from "Some Common BASIC Programs" by  Cÿÿ FVALBQ4
[email protected],to probability. This program is taken from:Cÿÿ E_XBX![email protected]Setup Sum of Scores for XDÿÿSQUAREBQ'[email protected]Define Area for EX2 CalculationDÿÿ XBQ-[email protected]%Define Independent Variable (X) RangeDÿÿ XBQDÿÿ XBQDÿÿ XBQ
Dÿÿ
DFBQ? [email protected]7Lon Poole, Mary Borchers, and Carroll Donahue (OSBORNE/ Dÿÿ
dfNumBQA
[email protected]9"Some Common BASIC Programs" by Lon Poole, Mary Borchers,Dÿÿ E_X2BX"[email protected]Setup Sum of Squares for XDÿÿ
TOTALBX%[email protected]Define Variable for EX2 TotalDÿÿ YBQ+[email protected]#Define Dependent Variable (Y) Range&EÿÿEE_N#GALBX.[email protected]&Setup Count for Number of ObservationsEÿÿ YBQEÿÿ YBQ+
EÿÿC> B7B+ [email protected]#McGraw-Hill, Publishers, pp. 138-9)  EÿÿdfDenomBQ=
[email protected]5and Carroll Donahue (OSBORNE/McGraw-Hill, Publishers,6Eÿÿ|%C
CalculateSums#G4|ALB«)[email protected]!Calculate X Sums in this FOR-LOOP1Eÿÿ| CCOUNTERR#-ALB«[email protected] Row For-Loop7Fÿÿ|&#Gå|
AL#IALB7B&[email protected]If X Range <> Y Range - RETURNF*ÿÿ #0BÿB[email protected]:Calculate Sum of X - Subroutine SubX() Defined in Column Z'Fÿÿ|EE_Nx#G9|ALBX4[email protected],Setup Count for Number of Observations For X7Fÿÿ|&#G‘|
AL#IC|ALB7B& [email protected]If X Range <> Y Range - RETURN+
FÿÿC  B7B+ FÿÿC B7B
[email protected] pp. 138-9).;Gÿÿ|*EE_XC#G±|CBBX@@1Gÿÿ| CCOUNTERC#-|AMB«[email protected]Column For-Loop&Gÿÿ|EE_N#GH|ALBX.[email protected]&Setup Count for Number of ObservationsSG€ÿÿBSEMC C@|C Cá|+ACì|;ABXB[email protected]:Standard Error of Mean (SEM) Calculated Using The Formula:'Hÿÿ|EE_Ny#I»|ALBX4[email protected],Setup Count for Number of Observations For Y&Hÿÿ|EE_N#Gª|ALBX. [email protected]&Setup Count for Number of Observations&
HÿÿTVALC>†|
BX0 Hÿÿ|C| 
#*A5B@Hÿÿ|/EE_X2CÍ|#GH|CP| BBX@@FHÿÿ|5TTOTALC6#-‚|C!C)BBX[email protected]Add up Sum of SquaresI*ÿÿ #0l|BÿB[email protected]:Calculate Sum of X - Subroutine SubX() Defined in Column Z?[email protected]€7SEM <-- SQRT( (E(X^2) - (EX)^2/N) / (N - 1) ) / SQRT(N)I*ÿÿ #0B |BÿB[email protected]:Calculate Sum of X - Subroutine SubX() Defined in Column ZI*ÿÿ #Bÿ [email protected]0
IÿÿC>l| 
#,A5B Iÿÿ
XXBXIÿÿA®%[email protected]End of CalculateSums FOR-LOOPIÿÿA®[email protected] Next ColumnI*ÿÿ #2BÿB[email protected]:Calculate Cum of Y - Subroutine SubY() Defined in Column Z5J€ÿÿ$TVALCÕ|
Cü|C)BX4[email protected],T-Value (TVAL) Calculated Using The Formula:J*ÿÿ #2
|BÿB[email protected]:Calculate Cum of Y - Subroutine SubY() Defined in Column ZSJ€ÿÿBSEMC CC.
| C‰
|+AC”
|;ABXB [email protected]:Standard Error of Mean (SEM) Calculated Using The Formula:
Jÿÿ
SSBX0 Jÿÿ|CŒ| 
#*›|A5BJÿÿB7KÿÿA®[email protected]Next RowK*ÿÿ #1BÿD[email protected] |C BX0[email protected](Calculate Ex2 Term To Determine Variance> [email protected]€6SEM <-- SQRT( (E(D^2) - (ED^2/N) / (N - 1) ) / SQRT(N) 
KÿÿRR# ä| BX  KÿÿSS# BX Kÿÿ #6 |B7 [email protected]
Return EX2ˆ K€ÿÿw CorrelationC¤
|CC[ |%C-Cí |8CS |@Cþ |IAC |XC`C |iABX8 [email protected]0Calculate Correlation Coefficient Using Formula: Lÿÿ #>– |B7 @@" [email protected]€Ex2 <-- E(X^2) - (EX)^2/Nx5 L€ÿÿ$TVALC}
|
C1 |C)8
|BX4 [email protected],T-Value (TVAL) Calculated Using The Formula:
LÿÿZZ#>h | BX LÿÿTT#
BX ZÀSumY
[email protected]€r <-- (EN*EXY-EX*EY) / 
@@7
L€ÿÿ&Ty2C9 | CB |C BX0
[email protected](Calculate Ey2 Term To Determine Variance&
[email protected]€TVAL <-- (Mean(X-Y) - 0) / SEM

Mÿÿ
#A5
MÿÿZZ#Ü
| BX
Mÿÿ E_YBX!
[email protected]Setup Sum of Scores for Y7 [email protected]€/ (SQRT(EN*EX2-EX^2)*SQRT(EN*EY2-EY^2))) @@" [@€Ey2 <-- E(Y^2) - (EY)^2/Ny Mÿÿ #>¼ |B7 [email protected]
[@SmallT Mÿÿ
#A5 Mÿÿ E_Y2BX" [@Setup Sum of Squares for Y Mÿÿ #B7& [@Return correlation coefficient @@H M€ÿÿ7S_2C? [email protected]Cg |C
|+BX) [@!Calculate Variance Using Formula: @@
NÿÿSS# ˆ | BX [@SmallF6 Nÿÿ|%C
CalculateSums#I#|ALB«) [@!Calculate Y Sums in this FOR-LOOP
@@4
[@€,s2 <-- (Ex^2 + Ey^2) / ((Nx - 1) + (Ny - 1))
@@

Nÿÿ
RRBX
NÿÿSS#
Ü | BX;
Nÿÿ|*EE_YC
|#Io|CÕ|BBX[email protected]=N€ÿÿ,SdC3 C |C3|C|$ABX3[@+Estimate Population Variance Using Formula: @@$
OÿÿZZC>„
|BX  OÿÿTT#¨ | BX@Oÿÿ|/EE_Y2Cý |#IÚ|Câ| BBX[email protected]%\@€Sd <-- SQRT( S^2/Nx + S^2/Ny) @@
\@ CalcTDist$ OÿÿZZCL
|BXOÿÿA®%\@End of CalculateSums FOR-LOOP[email protected]GO€ÿÿ6TVALC" |
C|CÒ|C!|&C(1BX)\!Calculated T-Value Using Formula: @@(
PÿÿJJ C.BX \@ CalcFDistPÿÿB7%\€TVAL <-- (EX/Nx - EY/Ny) / Sd [email protected](
PÿÿKK C%BX( PÿÿJJ C.K|BXPÿÿ #>G|B7l
Pÿÿ[LLCCKC.ACï|9CKù|AC|SABX( QÿÿKK C<BX
\ÀSumXY^
QÿÿMC%‡| ;LLC{®Gáz´?C|.C%||;BXBl Qÿÿ[YYC|CK"|C4|.ACá|9CKë|AC|SABXRÿÿ E_XYBX!\@Setup Sum of Scores for Y[email protected]y
RÿÿhXXà?C£|½
ƒ2É?Cr|(O²žZ}½?Cƒ|96wô¿\‹6?C”|JëSŽÉâþ“?BX^ RÿÿMC<_| ;YYCJ{®Gáz´?CJí|.C<Ú|;BXB6Sÿÿ|%C
CalculateSums#GÍ|ALB«[email protected]>
Sÿÿ-XXCH 'à?Ajø@BXy SÿÿhXXà?CJ|½
ƒ2É?CJ¼|(O²žZ}½?CJÍ|96wô¿\‹6?CJÞ|JëSŽÉâþ“?BXSTÿÿ|BEE_XYCõ |#GM|C| B#I•|.C=|6BBX9
Tÿÿ(C>Ì| XXCHr|BXB> Tÿÿ-XXCHŒ| 'à?Ajø@BXTÿÿA®
Tÿÿ #H²|B79 Uÿÿ(CË| XXCHþ|BXBUÿÿB7
@@ Uÿÿ #H0|B7\ÀDiffXYUÿÿ E_DBX%\@Setup Sum of Scores for (X-Y)Uÿÿ E_D2BX(\@ Setup Sum of Squares for (X-Y)^26Uÿÿ|%C
CalculateSums#G5|ALB«

]ÀRTVAL0 ]@(RTVAL(r,N) - Converts r-value to t-valueIUÿÿ|8ddXY#GÏ|CS|B#IK|%C|-BBX
Vÿÿ RVALBQ*VÿÿE_DCŠ | CBX
Vÿÿ E_NBQ/VÿÿE_D2Cu
|
Ca|BX

"
!
–
"
ND
V€ÿÿ3TVALC'
C’ |AC'Î|'ABX3 ]+R-value converted to t-value using formula: VÿÿA®2! ]€*TVAL <-- RVAL * SQRT(N-2) / SQRT(1-RVAL^2)!WÿÿB7"
Wÿÿ #>v|B7= À¨>