Category : Lotus and other Spreadsheets
Archive   : BEST_FIT.ZIP
Filename : BEST_FIT.WQ1

 
Output of file : BEST_FIT.WQ1 contained in archive : BEST_FIT.ZIP
 Q
N–NN

œ
/ÿÿ&ñ +H- 
  
? d š™žðÿð›@4à 4à4à4à á ááá  CELL_ADDRƒ¤?LL  CELL_LENGÁ™ÿÿNN COUNTERîxƒ¤?MM FORM<Êîxƒ¤?KK HELP1Êy‚ƒ¤?


HELP2ÊŠ‚ƒ¤?

 NAME_INDLT_FIT.""  NEXT_CELLT_FIT.!! \A?<ʧvƒ¤? \H?<Êyƒ¤?

ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ0ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿ# ÿÿÿÿÿÿÿÿŸ ÿÿÿÿÿÿÿÿ  ÿÿÿÿÿÿÿÿ¡ ÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ$%&'\027E\027&l1o5.45C\027(s16.66H(
ÿ݀ÿ€ÿ@ó»d¼)'*ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿfÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿgÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿµQÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿi(ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ¶ÿÿÿÿÿÿÿÿ·"ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ{®Gázt?¹-Êÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ  16.,,WQ1#ÿÿ&'¼ÿÿÿÿÿÿÿRO.MUMNO123.MUXYZ[\]²± QRSTUVWXYZ{|}~€šEAŽA€EEEIIIŽ’’™OUUY™šœžŸAIOU¥¥¦¨©ª«¬­®¯°±²³´µ¶·¸¹º¼½¾¿ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞßàáâäåæçèéêëìíîïðñòóôõöqq

á$áááááq ? {BEEP}5 <Y0©Œÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ¢5ÿ'Lÿÿø£Nÿ
zàš$xÿÿÿÿ½¿¾ÀÁ 

)ÿ'"* * * PRESS FOR HELP * * * ÿ'\Aÿ!' NEXT_CELLÿ"'NAME_IND ÿK'FORMÿL' CELL_ADDRÿM'COUNTERÿN' CELL_LENGÿ'AUTHOR:
ÿ'MACRO:ÿ'EXECUTE: ÿ 'DATE:ÿ 'DESCRIP: ÿ
'HELP:ÿ'{INDICATE BEST}ÿ'{/ Regression;Reset}%ÿ'{/ Regression;Independent}{?}~#ÿ'{/ Regression;Dependent}{?}~ÿ'{WINDOWSOFF}{PANELOFF}%ÿ'{/ Regression;Output}R_OUTPUT~ ÿ'{/ Regression;Intercept}Cÿ'{/ Regression;Go}ÿ'{GOTO}R_OUTPUT~2ÿ'+{/ Name;Create}SLOPE~{BS}{RIGHT 2}{DOWN 7}~2ÿ'+{/ Name;Create}COUNT~{BS}{RIGHT 3}{DOWN 4}~.ÿ ''{ONERROR NEXT_CELL}{/ Name;Delete}XIND~,ÿ!'%{/ Name;Create}XIND~{RECALC NAME_IND}.ÿ"ŽTð
regression independent‰3
ÿ"XINDÿ#'~5ÿ$'.{/ Name;Create}IND_BLK~{BS}.{RIGHT 3}{DOWN 9}~ÿ%'{GOTO}R_OUTPUT~,ÿ&'%{RIGHT 1}{DOWN 9}{windowson}{panelon}0ÿ''){/ Block;Copy}{BS}{CHOOSE}{EDIT}BEST_FIT~9ÿ('2{LET CELL_LENG,@LENGTH(@CELLPOINTER("Address"))-2}ÿ)'{EDIT}{BS CELL_LENG} ÿ*'FORMÿ+'~~{windowsoff}{paneloff}ÿ,'{EDIT}{HOME}{DEL}ÿ-'~4ÿ.'-{LET $CELL_ADDR,@INDEX([]IND_BLK,1,9):Value}~ÿ/'{GOTO}R_OUTPUT~ÿ0'{RIGHT 5}BF_SERIES{DOWN}ÿ1‚Að~vv@AVG(
regression dependent‰){ABS}+$SLOPE*(contentsl{ABS 3}-@AVG($
regression independent‰))~LL3<ÿ16@AVG(B21..B26){ABS}+$SLOPE*($A$21{ABS 3}-@AVG($XIND))~1ÿ2'*{LET $COUNTER,@INDEX([]IND_BLK,3,4):Value}1ÿ3'*{/ Block,Copy}~{DOWN}.{DOWN ($COUNTER-2)}~1ÿ4'*{/ Name,Create}BF_SERIES~{BS}.{END}{DOWN}~ÿ5'{/ Graph,ResetAll}ÿ6'{/ Graph,Type}X)ÿ7'"{/ 1Series;Color}{EDIT}LIGHT CYAN~,ÿ8'%{/ 2Series;Color}{EDIT}LIGHT MAGENTA~%ÿ9'{/ Graph;GridFill}{EDIT}BLACK~ÿ:'{/ XAxis;Labels}XIND~ÿ;'{/ 1Series;Block},ÿ<Sð
regression dependent‰3ÿ<B21..B26ÿ='~ÿ>'{/ CompGraph;AFormat}Sÿ?'{/ 1Series;Markers}C"ÿ@'{/ 2Series;Block}BF_SERIES~ÿA'{/ CompGraph;BFormat}LÿB'{/ Graph;View} ÿC'{/ Name;Delete}BF_SERIES~ÿD'{/ Name;Delete}COUNT~ÿE'{/ Name;Delete}SLOPE~ÿF'{/ Name;Delete}XIND~ÿG'{/ Name;Delete}IND_BLK~ÿH'
{INDICATE}ÿK'@CELL("address",XIND) ÿL'$A$21
ÿM
ÿNÿ' Stacy Stewartÿ' Best Fitÿ' ÿ '
May 22, 1991!ÿ ' This macros plots a best ÿ ' fit lineÿ
'  ÿ '\H ÿ 'HELP1 ÿ 'HELP2ÿ
'{MESSAGE HELP1,7,7,0}ÿ
'{MESSAGE HELP2,7,3,0}<ÿ
'5This macro performs a regression analysis on two sets<ÿ
'5of points and then plots the points along with a best;ÿ
'4fit line for those points. You will be prompted for?ÿ
'8the independent and dependent variables which are needed*ÿ

'#to perform the regression analysis. ÿ
^PRESS ANY KEY TO CONTINUE=ÿ
'61) Open the spreadsheet that contains your independent"ÿ
' and dependent variables.>ÿ
'72) This macro requires a blank area of your spreadsheetCÿ
'< to place the regression data. This area must be at least@ÿ
'9 7 columns wide and as many rows as there are points inCÿ
'< the analysis. The upper left cell of this block must be Aÿ
': named R_OUTPUT. Use the /Edit | Names | Create to nameÿ
'
this cell.Bÿ
';3) Press Alt-A to execute the macro. The macro will promptCÿ
'< you for your independent and dependent variables, perform@ÿ
'9 a linear regression analysis, and determine the points+ÿ
'$ needed to plot the best fit line. ÿ
^PRESS ANY KEY TO CONTINUEÿJÿHÿHÿ Hÿ
Hÿ Hÿ Hÿ
Hÿÿÿÿÿÿÿÿÿÿÿ ÿ
ÿ ÿ ÿ


  3 Responses to “Category : Lotus and other Spreadsheets
Archive   : BEST_FIT.ZIP
Filename : BEST_FIT.WQ1

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

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

  3. 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/