Category : Lotus and other Spreadsheets
Archive   : POWER123.ZIP
Filename : SREGR.WKS

 o/





ÿq H  
AAGEN

BBLANK

CALCCALCAREA.X
COPYRIGHT

COPYRIGHT_P1

DEFCALCAREA k kDEFINPUTAREAkkDEFOBSNOSkkDFGRAPH
=
=GRAPHMENU==GRAPHOPTGGINPTMENUINPUT
--INPUTAREA
-X
INPUTINSTR  INPUTINSTR2

INSTR./MENUNNUMBER__NUMBERCONF__OBSNOS-X
PALIGNRRPRINTVVRESULTS22S2X!!S2Y""SB&&SETSKIP
G
GSY|X$$TEMPUPDOWN88XINPUT--XMEANXY--YINPUT
-
-YMEAN\0

\B

\I



\M

\PMMÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ
ÿÿÿÿÿÿÿÿ0
-ÿÿÿÿÿÿÿÿ¨ ÿÿÿÿÿÿÿÿÿ# ÿÿÿÿÿ ÿÿÿÿÿÿÿÿ$
%ò &ò '((
LB)
'*ÿÿÿÿÿÿÿÿ-µ
-ÿÿÿÿ-ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ-ÿÿBÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ





LINEAR REGRESSION Estimate Confidence Limits X Values Y Values Regr. Line Y Estimate Ordinate qq
ÿ\=ÿ
\=ÿ\=ÿ\=ÿ\=ÿ'\0: \B: ÿ"TEMP: ù¿-€ú¿.€R

ÿ
'\I: ÿ
'SREGR4
' Copyright (c) 1984, Wildfire Technology Inc.ÿ
'/dfobsnos~1~~~ ÿ
'{esc}{esc}{esc}{esc}{esc} ÿ

'{esc}{esc}{esc}{esc}{esc}ÿ\-ÿ
\-ÿ\-ÿ\-ÿ\-ÿ'/ruinputarea~/wgpe ÿ'{esc}{esc}{esc}{esc}{esc} ÿ
'{esc}{esc}{esc}{esc}{esc}2ÿ
' SIMPLE LINEAR REGRESSION WORKSHEETÿ'{home}/xmmenu~"ÿ'{home}/ruinputarea~/xmmenu~&ÿ
'{home}/ruinputarea~/xminptmenu~ÿ\=ÿ
\=ÿ\=ÿ\=ÿ\= ÿ'MENU:ÿ'Regression Line is Y=!ÿð
€€
€€
€€
 ÿ^+ X *ÿð
€€
€€  ÿ'Input ÿ'Blankÿ'Calcÿ'Results ÿ 'Graph ÿ
'Print
ÿ'Agendaÿ 'Quitÿ'Input Dataÿ'Clear Input Fieldsÿ'Calculate Resultsÿ'Show Resultsÿ 'Show Graphsÿ
'Print Results+ÿ'Return to Worksheet Selection Agendaÿ 'Exit to 1-2-3;ÿ'Correlation Coefficient (r) is ....................."„ð
€€
€€
€€# ÿ'/xminptmenu~ÿ'/xmblank~ÿ'/xgcalc~ÿ'/xmresults~Nÿ '/xi@count(e46.e48)<3~//{esc}/xlInsufficient Data to Plot.~temp~/xmmenu~
ÿ
'/xg\P~ÿ'/xmagen~
ÿ '/xq;ÿ 'r-squared is .......................................„ ð

€ÿ¿
ÿ '/XGgraph~4
' Copyright (c) 1984, Wildfire Technology Inc.'ÿ'Significance Test of Regression:7ÿ '(Testing the hypothesis that the slope is zero.)
ÿ 'BLANK: ÿ 'AGEN: ÿ
'No
ÿ
'Yes ÿ
'No
ÿ

'Yes;ÿ'Student's t-statistic ..............................ƒð

€ø¿
€€ !*ÿ'Leave Data Intact. Return to Menu.!ÿ'Erase All X-Y Data Values.-ÿ 'Return to Main Menu in This Worksheet.*ÿ
'Exit to Worksheet Selection Agenda.;ÿ'Number of Degrees of Freedom .......................ÿ
€€
Tÿ'/xmmenu~ÿ'/reinputarea~ÿ '/xmmenu~ÿ
'/fragenda~ÿ'/xmmenu~ÿ'INPTMENU:ÿ'XYPairsÿ'YXPairs ÿ'Est-X ÿ'Range
ÿ 'Numberÿ
'Quit)ÿ
' Intermediate Results Area(ÿ'Enter Data in X-Y Pairs (X First)(ÿ'Enter Data in Y-X Pairs (Y First)8ÿ'Enter X-Values For Which Y Estimates Are Required+ÿ'Use Standard 'Range Input' Facility.>ÿ 'Set Maximum Number of Observations (erases input area).ÿ
'Return to Main Menu)ÿ
' --------------------------ÿ'/ruinstr~/cinputinstr2~instr~/ruinstr~-ÿ'/ruinstr~/cinputinstr2~instr~/ruinstr~-ÿ'/ruinstr~/cinputinstr2~instr~/ruinstr~,ÿ'/ruinstr~/cinputinstr~instr~/ruinstr~ÿ '/xmnumberconf~ÿ
'/xmmenu~"ÿ'{goto}temp~@count(b46.b47)~"ÿ'{goto}temp~@count(b46.b47)~"ÿ'{goto}temp~@count(b46.b47)~ÿ'/riinputarea~;ÿ'Number of Observations .............................ÿð?
ý¿€R
%ÿ'{home}{pgdn}{pgdn}{goto}input~%ÿ'{home}{pgdn}{pgdn}{goto}input~%ÿ'{home}{pgdn}{pgdn}{goto}input~ÿ'/xminptmenu~ÿ'/xitemp=2~{end}{down}ÿ'/xitemp=2~{end}{down}ÿ'/xitemp=2~{end}{down};ÿ'Mean Value of X ....................................ÿ
þ¿€Q
ÿ'/xitemp>0~{down}ÿ'/xitemp>0~{down}ÿ'/xitemp>0~{down}ÿ 'INPUTINSTR:ÿ
'INPUTINSTR2:;ÿ'Mean Value of Y ....................................ÿ
ý¿€Q
ÿ'{right} ÿ'{?}{right}{?}{left}{down}ÿ'{right}"ÿ 'Enter Y-Values in Column B. ÿ
'Press Ctrl-Break to Stop.;ÿ'Mean Value of (X*Y) ................................ÿ
€€Q
'ÿ'{?}{left}{?}{right}{down}/xgf28~ÿ'/xgg27~ÿ'{?}{down}/xgh28~"ÿ 'Enter X-Values in Column C.$ÿ
'Then Press Alt-M to Get Menu.;ÿ'Corrected Sum of Squares of X ......................ÿ

þ¿€W
 ÿ'CALC:;ÿ'Corrected Sum of Squares of Y ......................ÿ

ý¿€W
Gÿ'/xi@count(b46.b48)<3~/xlInsufficient Data entered.~temp~/xmmenu~;ÿ'Corrected Sum of Cross-Products (X*Y) ..............ÿ
€€P
ÿ'/wgpd/recalcarea~Aÿ '{home}{pgdn}{pgdn}{goto}input~/rncyinput~{bs}.{end}{down}~;ÿ!'Variance of X ...................................... ÿ!
۟

 Tÿ!'{right}/rncxinput~{bs}.{left}{end}{down}{right}~/rncxvalues~{bs}.{end}{down}~;ÿ"'Variance of Y ...................................... ÿ"
۟

 5ÿ"'{right}/rncyest~{bs}.{left}{end}{down}{right}~;ÿ#'Unexplained Variance of Y, Given X .................<ÿ#ð-
€ô¿


€ô¿

€ÿ¿
€þ¿
ۋ
ÿ#'/wgpd/c~.yest~;ÿ$'Standard Deviation of Y, Given X ...................ÿ$ð
€ÿ¿#Mÿ$'{right}/rncxy~{bs}.{left}{left}{left}{end}{down}{right}{right}{right}~ÿ%'/c~.xy~;ÿ&'Standard Deviation of Slope (b) ....................'ÿ&ð
€þ¿
ۖ

€û¿# *ÿ&'{home}{pgdn}{goto}n~@count(yinput)~ ÿ''{down}{down}@avg(xinput)~ÿ('{down}@avg(yinput)~ÿ
)' DATA INPUT AREAÿ)'{down}@avg(xy)~$ÿ
*' Enter Pairs of Values Below#ÿ*'{down}{down}+n*@var(xinput)~ÿ+'Observationÿ+'{down}+n*@var(yinput)~
ÿ,"Numberÿ
,"Y-Valueÿ,"X-Valueÿ,"Y-Estimate
ÿ,"Y*Xÿ,'{down}@sum(xy)~ 
- -!ÿ-ð


ÿ¿€ )ÿ-
ý¿€


þ¿€

ÿ-'/wgpe{home}{calc}ÿ.'/xmmenu~ÿ1'RESULTS: ÿ2'Finalÿ2'Intermedÿ2'Rawdataÿ2'Quit5ÿ3'View Regression Equation and Final Statistics.!ÿ3'View Intermediate Results.%ÿ3'View Raw Data and Y Estimates.ÿ3'Return to Main Menu.ÿ4'{goto}a1~ÿ4'{goto}a21~ÿ4'{goto}a41~{goto}a46~/wthÿ4'{home}/xmmenu~ÿ5'/xmresults~ÿ5'/xmresults~ÿ5'/xmupdown~ÿ7'UPDOWN:ÿ8'Down ÿ8'Upÿ8'Quitÿ9'Go Down to Next Page.ÿ9'Go Up to Previous Page.ÿ9'Return to Results Menu.ÿ:'{pgdn}/xmupdown~ÿ:'{pgup}/xmupdown~ÿ:'/wtc/xmresults~ÿ<'GRAPHMENU:
ÿ
<'GRAPH:ÿ='Rawdataÿ='Optionsÿ='Viewÿ='Quitÿ
='{goto}setskip~{down})ÿ>'Plot Raw Data and Regression Line.ÿ>'Set Graph Options.#ÿ>'Re-display the Latest Graph.ÿ>'Return to Main Menu.&ÿ
>'@MAX(1,@INT(@COUNT(xvalues)/5))(ÿ?'/gtxxxvalues~ayest~byinput~rcdefqÿ?'/xmgraphopt~ÿ?'/gvqÿ?'{home}/xmmenu~ÿ
?'{calc}~{edit}{home}'~/ÿ@'ola{esc}Regression Line~lb{esc}Raw Data~ÿ@'/xmgraphmenu~ÿ@'/xmgraphmenu~ÿ
@'/XCsetskip~
ÿA'falbsqÿ
A'{home}/XMgraphmenu~)ÿB'ts{esc}Raw Data & Regression Line~ÿC'qv{esc}{esc}ÿD'/xmgraphmenu~ÿF'GRAPHOPT:ÿ
F'SETSKIP: ÿG'Color
ÿG'B&WÿG'Quit ÿ
G'/GOSSÿH'Show Graphs in Color.!ÿH'Show Graphs in Monochrome.ÿH'Return to Graph Menu.
H'1
ÿI'/gocqq
ÿI'/gobqqÿI'/xmgraphmenu~
ÿ
I'~QQ/XRÿJ'/xmgraphopt~ÿJ'/xmgraphopt~
ÿL'\P:ÿM'/recopyright_p1~ÿN'/xmprint~ÿQ'PALIGN:,ÿR'/xlAlign Paper then Press ENTER~temp~
ÿS'/xr
ÿU'PRINT:ÿV'ResultsÿV'DataÿV'QuitMÿW'Print Regression Equation, Final Statistics, and Intermediate Results.&ÿW'Print Raw Data and Y Estimates.ÿW'Return to Main Menu.ÿX'/xcpalign~ÿX'/xcpalign~0ÿX'/ccopyright~copyright_p1~/rucopyright_p1~ÿY'/ppra1.e40~cbagpqÿY'{goto}a46~ÿY'{home}/xmmenu~ÿZ'/xmprint~8ÿZ'/ppr{bs}.{right}{right}{right}{right}{end}{down}~ÿ['cbobra41.e45~qagpqÿ\'/xmprint~ÿ^'NUMBERCONF:ÿ^'NUMBER: ÿ_'No
ÿ_'Yes ÿ_'/wgpdAÿ`'Do not erase and resize input area. Return to input menu.>ÿ`'Erase and resize input area, then return to input menu.3ÿ`'/xnEnter Max. Number of Observations ~temp~ÿa'/xminptmenu~ÿa'/xgnumber~Gÿa'{goto}temp~{edit}{home}45+@max(20,@min(2000,@int({end}))){calc}~ÿb'/xcdefobsnos~ÿc'/xcdefinputarea~ÿd'/xcdefcalcarea~ÿe'{home}/wgpeÿf'/xminptmenu~ÿj'DEFOBSNOS:ÿj'DEFINPUTAREA:ÿ j'DEFCALCAREA:ÿk'/reobsnos~/ctemp~f111~-ÿk'/reinputarea~/rpinputarea~/ctemp~h111~ÿ k'/recalcarea~/ctemp~j111~ ÿl'{goto}f111~{edit}{home}a~ ÿl'{goto}h111~{edit}{home}c~ ÿ l'{goto}j111~{edit}{home}e~ÿm'/rncobsnos~a46.ÿm'/rncinputarea~b46.ÿ m'/rnccalcarea~d47.n'a245n'd245 n'p245ÿo'~/dfobsnos~1~~~/xrÿo'~/ruinputarea~/xrÿ o'~/xr