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}[email protected]($
regression independent‰))~LL3<ÿ1[email protected](B21..B26){ABS}+$SLOPE*($A$21{ABS 3}[email protected]($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ÿÿÿÿÿÿÿÿÿÿÿ ÿ
ÿ ÿ ÿ