Category : Lotus and other Spreadsheets
Archive : ASAPHYS.ZIP
Filename : STATDEML.WK1

Output of file : STATDEML.WK1 contained in archive : ASAPHYS.ZIP

Uÿÿq -HG!PSY\OTHER\,ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿ# ÿÿÿÿÿ$%&'(
PB)'*ÿÿÿÿÿÿÿÿ-µ $,ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿà7à7à7à7Best Fit Line......E/.......F/...EXERCISE FOUR XaxisYaxisDATA VALUES BEST FIT LINE .ÅCURVEFIT\OTHER\ LULUÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿà7à7à7à7Best Fit Curve.....E/......LINEFITRRRRRRRRRRRRe.....E/......LINEFITXaxisYaxisDATA VALUES BEST FIT LINE .ÅLINEFIT\OTHER\ $,ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿà7à7à7à7Best Fit Line......E/.......F/...EXERCISE FOUR XaxisYaxisDATA VALUES BEST FIT LINE 0#ÿ'STATISTICAL DEMO SPREADSHEETÿ'exercise 1 ÿ"g=
ÿ#@ÿ'Linear regression:ÿ^Xÿ^(X-)ÿ^(X-)^2ÿ'(these x and y's
ÿ^Y^2
ÿ`ffff"@ÿ 3333ã¿
ÿ¿
ÿÀ£p=
×?ÿ¿
ÿ'are made up)
ÿ`ffff"@ÿ 3333ã¿
ÿ¿
ÿÀ£p=
×?ÿ¿
ÿ^Xÿ^Y
ÿ^X*Y
ÿ^X^2 ÿ^X^2*Yÿ^(X-)^2
ÿ^Y^2
ÿÀÌÌÌÌ"@ÿÙ¿
ÿ¿
ÿ®GázÄ?ÿ¿
ÿ"(a7*b7)
ÿ"(a7^2)ÿ"(a7^2*b7)ÿ"(a7-$a$17)^2
ÿ^(b7^2)
ÿà7ú¿

ÿÀÌÌÌÌ#@ÿ¹?
ÿ¿
ÿ®Gáz?ÿ¿

ÿà7ú¿

ÿ 3333$@ÿ 3333Ó?
ÿ¿
ÿÀ£p=
·?ÿ¿
ÿ ð?ÿ ð?ÿ ð?
þ¿ÿ¿ÿ ð?ý¿
ÿ ð?ü¿
ý¿ ÿ 0@û¿

ÿ ð?ú¿

ÿ à7ú¿
ÿ
@ÿ
@ÿ
$@
þ¿ÿ¿ÿ
@ý¿
ÿ
4@ü¿
ý¿ ÿ
"@û¿

ÿ
9@ú¿

ÿ
à7ú¿
ÿ
@ ú¿þ¿Rÿ
Âõ(\ï? ú¿þ¿P
ÿ
'sumÿ@ÿ@ÿ5@
þ¿ÿ¿ÿ"@ý¿
ÿO@ü¿
ý¿ ÿ@û¿

ÿH@ú¿

ÿà7ú¿
ÿ @ÿ "@ ÿ B@
þ¿ÿ¿ÿ 0@ý¿
ÿ b@ü¿
ý¿ ÿ ð?û¿

ÿ @T@ú¿

ÿ à7ú¿
`UÜ?
þ¿þ¿ #ÿ
@ÿ
"@ ÿ
F@
þ¿ÿ¿ÿ
9@ý¿
ÿ
l@ü¿
ý¿ÿ
à7ÿ
@T@ú¿

ÿ
à7ú¿
ÿ@ÿ&@ÿP@
þ¿ÿ¿ÿB@ý¿
ÿÀx@ü¿
ý¿ ÿð?û¿

ÿ@^@ú¿

ÿà7ú¿
ÿ@ÿ.@ÿ@Z@
þ¿ÿ¿ÿH@ý¿
ÿø@ü¿
ý¿ ÿ@û¿

ÿ l@ú¿

ÿà7ú¿
ÿ @ÿ1@ÿa@
þ¿ÿ¿ÿP@ý¿
ÿ@ü¿
ý¿ ÿ"@û¿

ÿr@ú¿

ÿà7ú¿
ÿ"@ ÿ4@ÿf@
þ¿ÿ¿ÿ@T@ý¿
ÿP@ü¿
ý¿ ÿ0@û¿

ÿy@ú¿
ÿ@ õ¿þ¿Qã8ã$@ õ¿þ¿Qÿ'averagesÿ"@avg(a7..a16)ÿN@ ý¿õ¿Pÿ"sum(x-)^2 ÿF@ û¿ó¿PÿW@ û¿ó¿Pÿ'sumsÿ"@sum(a7..a16)ÿ"@ ù¿ñ¿Rÿ^N ÿ'countÿ"@count(a4..a12)ÿ'STANDARD DEVIATIONÿ^=ÿ Ëé§@
ù¿ý¿ý¿ #ÿ"@sqrt(F14/A18)ÿ'in xÿ Ëé§@ ý¿õ¿ý¿í¿Xÿ"or @stdÿ'Curvefitting ÿ ^b=Rÿ ã8ãØ¿Cö¿ñ¿é¿Pÿ¿ö¿ñ¿é¿P
ÿ¿ø¿ñ¿é¿Pÿ¿ö¿
ÿ ^m=Lÿ @UUUU@=ü¿ø¿þ¿ñ¿þ¿é¿Pü¿ö¿ý¿ö¿
ü¿ø¿ÿ¿ñ¿ÿ¿é¿Pü¿ö¿
"ÿ"'Least squares line y valuesÿ"'Correlation
""$ÀqÇqü? å¿ ÿ$^r=j$À/tYï?[û¿ô¿ý¿í¿ý¿å¿Pû¿ò¿ü¿ò¿
û¿ô¿þ¿í¿þ¿å¿Pû¿ò¿
û¿ô¿í¿å¿Pü¿ò¿
# $"% ã8@ å¿ %"&ÀqÇq@ å¿ &"' ã8 @ å¿ '"(ã8ã$@ å¿ (")à8ã8)@ å¿ )"* ã8-@ å¿ *"+ÀqÇñ0@ å¿ +",`Çq3@ å¿ , -ÿ.\*ÿ.\*ÿ.\*ÿ.\*ÿ.\*ÿ.\*ÿ.\*ÿ.\*ÿ0'Parabolic curve fittingÿ3^Xÿ3^Y
ÿ3^X*Y
ÿ3^X^2
ÿ3^X^3
ÿ3^X^4 ÿ3^X^2*Yÿ5ð?ÿ5ð?ÿ5ð?
þ¿ÿ¿ÿ5ð?ý¿
ÿ5ð?ü¿
5ð?û¿
ÿ5ð?
ý¿û¿ÿ6@
ÿ6ÿ6$@
þ¿ÿ¿ÿ6@ý¿
ÿ6 @ü¿
60@û¿
ÿ64@
ý¿û¿ÿ7@
ÿ7
ÿ7>@
þ¿ÿ¿ÿ7"@ý¿
ÿ7;@ü¿
7@T@û¿
ÿ7V@
ý¿û¿ÿ8@
ÿ8ÿ8T@
þ¿ÿ¿ÿ80@ý¿
ÿ8P@ü¿
8p@û¿
ÿ8t@
ý¿û¿ÿ9@
ÿ9ÿ9à`@
þ¿ÿ¿ÿ99@ý¿
ÿ9@_@ü¿
9@û¿
ÿ9@
ý¿û¿ÿ:@
ÿ:'ÿ:@m@
þ¿ÿ¿ÿ:B@ý¿
ÿ:k@ü¿
:@@û¿
ÿ:ð@
ý¿û¿ÿ;@
ÿ;1ÿ;pu@
þ¿ÿ¿ÿ;H@ý¿
ÿ;pu@ü¿
;Â¢@û¿
ÿ;Â¢@
ý¿û¿ÿ< @
ÿ<<ÿ<~@
þ¿ÿ¿ÿ<P@ý¿
ÿ<@ü¿
<°@û¿
ÿ<®@
ý¿û¿ÿ="@
ÿ=Uÿ=è@
þ¿ÿ¿ÿ=@T@ý¿
ÿ=È@ü¿
=¡¹@û¿
ÿ=åº@
ý¿û¿
ÿ>

ÿ>cÿ>ð@
þ¿ÿ¿ÿ>Y@ý¿
ÿ>@@ü¿
>Ã@û¿
ÿ>VÃ@
ý¿û¿ÿ@K@ õ¿þ¿Pÿ@°x@ õ¿þ¿Pÿ@ø§@ õ¿þ¿Pÿ@x@ õ¿þ¿Pÿ@¢§@ õ¿þ¿Pÿ@@½Ø@ õ¿þ¿Pÿ@ðØ@ õ¿þ¿Pÿ@^sumsÿB$@ ü¿ó¿R ÿB'countÿE' coefficients:ÿE^aÿE^bÿE^cF`>øì?F¼
Åì?F`~!""Ò¿ÿH'least squares parabola
ÿH'matrixÿJ^y valuesÿJx@ÿ¿ö¿ÿJK@û¿ö¿ÿJ$@ÿ¿ø¿ÿJ°x@ú¿ö¿
ÿJ`>øì?ÿK^actual y valuesÿK¢§@õ¿ÿKx@ÿ¿ÿ¿ÿKK@ÿ¿ÿ¿ÿKø§@û¿õ¿
ÿK¼
Åì?2ÿLàÁyJø?#Fé¿
Fé¿ F ÿLð?ÿL'(not bad, huh?)ÿL@½Ø@ô¿ÿL¢§@ÿ¿ÿ¿ÿLx@ÿ¿ÿ¿ÿLðØ@ÿ¿ô¿
ÿL`~!""Ò¿2ÿMZ(n@#Fé¿
Fé¿ F
ÿM2ÿN³É&%@#Fé¿
Fé¿ F
ÿN
2ÿOÀ OÉ1@#Fé¿
Fé¿ F
ÿO2ÿPH½Ô:@#Fé¿
Fé¿ F
ÿP2ÿQ@z©×B@#Fé¿
Fé¿ F
ÿQ'2ÿRÌÌÌ,I@#Fé¿
Fé¿ F
ÿR12ÿSM6Ù4P@#Fé¿
Fé¿ F
ÿS<2ÿTÀrþ,GT@#Fé¿
Fé¿ F
ÿTU2ÿU@Ö¾aÍX@#Fé¿
Fé¿ F
ÿUc

3 Responses to “Category : Lotus and other Spreadsheets
Archive : ASAPHYS.ZIP
Filename : STATDEML.WK1
”

Daniel says:

January 27, 2013 at 3:59 pm

Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!
Joshie says:

March 18, 2014 at 4:57 pm

This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.
DiskingRound says:

January 14, 2015 at 10:57 pm

But one thing that puzzles me is the “mtswslnkmcjklsdlsbdmMICROSOFT” string. There is an article about it here. It is definitely worth a read: http://www.os2museum.com/wp/mtswslnk/

3 Responses to “Category : Lotus and other SpreadsheetsArchive : ASAPHYS.ZIPFilename : STATDEML.WK1”

3 Responses to “Category : Lotus and other Spreadsheets
Archive : ASAPHYS.ZIP
Filename : STATDEML.WK1
”