WPC$ 2BPZCourier 10cpi#|xCx6X@8;X@HP LaserJet IIIDHPLASIII.PRSx  @,\,JLX@#|x27B ZyX+Courier 10cpiCourier 10cpi (Bold)CG Times (Scalable)HP LaserJet IIIDHPLASIII.PRSx  @,\,JLX@?xxx,Cx6X@8;X@?xxx,x `B;XV"G($,#hG P7hP"m+O6^$(8<><q*"xxxxWWxxxWWkkxxx=~1.1 right )~ THEN~ CF ~is~ acceptable. x6X@8;X@x6X@8;X@x6X@8;X@8IF8CF-8THENe 8CF 8is 8 acceptableZdk808.x890818. 818.H8`8@$(#(#(#(#X!A'#$ 4. Press the "home" key to return to the main menu. 0*0*0*a'#6 6 '#O '#0'#)'#!'#A  ?  C. Method comparison with a paired sampling train: 1.Press "ALT" "P" to locate this spreadsheet. 2.Enter the standard deviation of the validated method, the results for the proposed method, and the validated method results. To enter the data use the arrow keys to place the curser over the desired cell and key in the corresponding result. These entry cells should be unprotected and therefore blue. NOTE: The spreadsheet was developed with the assumption that all concentration data is in comparable units, (i.e. all entries in  C( g/m3 or ppm.)  3.The spreadsheet will display results for the following: a. Relative standard deviation: >a#x_dddddD ddCxvSDd~=~ sqrt { {sum from 1 to 9 {{(VP)}^{2}~~ left ( {sum from 1 to 9 {(VP)}} right ) ^{2} over {9} } } over {n1}}x6X@8;X@x6X@8;X@x6X@8;X@SDdV Px Vh P8n 8TTwS(SSS;SSSNSSRYroI/hjiX /oX qX psI91()23 93 1 ( ) 2 <981>$(#(#(#(#@!a'#$` ` V: Validated method results ` ` P: Proposed method results ` ` n: Number of runs (9) b. Standard deviation of the proposed method: B#xdddddddCxSDp~=~SDd~~SDvx6X@8;X@x6X@8;X@x6X@8;X@8SDp8SDd28SDv8b8B$(#(#<(#(#X!'#$ ` ` SDv: Standard deviation of validated method (given) c. Proposed method variance: =#x,#dddddddCxSp^{2}=SDp^{2}x6X@8;X@x6X@8;X@x6X@8;X@8Sp8SDpz2jz2n8=$(#(#|(#(#X!'#$ d. Validated method variance: >#x'dddddddCMPVARxSv^{2}=SDv^{2} x6X@8;X@x6X@8;X@x6X@8;X@8Sv8SDvz2jz2n8>$(#(#d"(#(#X!'#$ e. Variance acceptance status: #x*dddddUddCVARACCMQx:IF~ Sp^{2}~ <= ~Sv^{2}~ THEN~ (Variance ~is~ acceptable). x6X@8;X@x6X@8;X@x6X@8;X@8IFZ8Sp8Sv8THENB8VarianceZ 8is 8 acceptablefz2z28(R8)8.8$(#(#L&(#(#X!'#$p(0*0*0*Q'#a'#,#'#A%''#))*'#-pԌf. Calculated tValue: #xxddddd<ddCTVALMQx5t-VALUE~=~dm over left ({SDd over {sqrt{n}}} right ) x6X@8;X@x6X@8;X@x6X@8;X@!tVALUE{XdmG?SDd8n[$hiop* O$(#(#(#(#!'#$` ` dm: Average difference between validated & proposed g. Bias acceptance status: "#x dddddddCTVALACCx8IF~ t-VALUE (calculated)~ <= ~t-VALUE (critical)~ THEN~ x6X@8;X@x6X@8;X@x6X@8;X@8IFZ8tJ8VALUE8 calculatedj 8tZ 8VALUE*8critical8THEN8 8 88( 8)8(8)"$(#(#(#(#X!'#$ #xdddddddCBNSSx+Bias~ is~ not ~statistically ~significant. x6X@8;X@x6X@8;X@x6X@8;X@8BiasJ8isb8 statistically 8 significant88.߁$(#(# (#(#X!'#$ >!#xdddddddCTCRITx0Critical~ t-VALUE~=~1.397~ (n~=~9, alpha~=~80%) x6X@8;X@x6X@8;X@x6X@8;X@8Critical*8t8VALUE 8n88 8.881 8. 8397J 8(b 89 8,8808%f8)R8>$(#(#(#(#X!!'#$ h. Correction factor: A#xsdddddddCCFMQx@CF~=~1+ left (dm over {avg.~ of~ 8~ Validated ~samples} right ) x6X@8;X@x6X@8;X@x6X@8;X@CF dm8avg8of8 Validatedc 8samplesZ*18.88gnf$(#(#(#(# !A'#$ i. Correction factor acceptance status: @a#xXddddd0ddCCFACCMQxAIF~ left ( 0.9~ <= ~CF~>=~1.1 right )~ THEN~ CF ~is~ acceptable. x6X@8;X@x6X@8;X@x6X@8;X@8IF8CF-8THENe 8CF 8is 8 acceptableZdk808.x890818. 818.H8`8@$(#(#(#(#X!a'#$ 4. Press the "home" key to return to the main menu. 0*0*0*ax'#  '#y'#'#!'#~AX'#Qa  ?  D. Isotopic Spiking with a paired or quadruplicate sampling train: 1.Press "ALT" "I" to locate this spreadsheet. 2.Enter the number of samples used for the validation analysis, enter the value of the isotopic spike, and enter the results of the proposed method samples. To enter the data use the arrow keys to place the curser over the desired cell and key in the corresponding result. These entry cells should be unprotected and therefore blue. NOTE: The spreadsheet was developed with the assumption that all concentration data is in comparable units, (i.e. all entries in  C( g/m3 or ppm.)  3.The spreadsheet will display results for the following: a. Bias: :#xdddddddCx B~=~Sm~~CSx6X@8;X@x6X@8;X@x6X@8;X@8B8Sm8CS88:$(#(#(#(#X!'#$ b. Mean: #xdddddHddCxk7Sm~=~ {sum {(Spiked~ sample~ results~ ~ CS)}} over {n}x6X@8;X@x6X@8;X@x6X@8;X@!Sm<Spiked'<sampleO <results<CS 8ni <WtI<(<)k$(#(#(#(#!'#$` ` CS: Calculated value for the isotopic spike. c. Standard deviation: 4#x6dddddnddCRSDMQx, SD~=~ sqrt{{SUM {(Si-Sm)^{2}}} over {n-1}} x6X@8;X@x6X@8;X@x6X@8;X@SD<Si <Sm8nZ<08(*T*NS*S*RI*<(<)r~2814$(#(#<(#(#!'#$` ` Si: Individual spiked samples d. Standard deviation of the mean: h#x,#dddddddCxSDM~=~SD over sqrt {n}x6X@8;X@x6X@8;X@x6X@8;X@!SDM?SD_8n _Oh$(#(#|(#(# !'#$` ` n: Number of samples e. Calculated tValue: #xs(dddddUddCTVALMQx&-t-VALUE~=~{left LINE B right line} over {SDM}x6X@8;X@x6X@8;X@x6X@8;X@!tVALUE<B8SDM-  &ߣ$(#(##(#(# !'#$ f. Bias acceptance status: "! #xdddddddCTVALACCx8IF~ t-VALUE (calculated)~ <= ~t-VALUE (critical)~ THEN~ x6X@8;X@x6X@8;X@x6X@8;X@8IFZ8tJ8VALUE8 calculatedj 8tZ 8VALUE*8critical8THEN8 8 88( 8)8(8)"(0*0*0*a'#'#'# ,#'#,&('#z+'#!Ԍ$(#(#(#(#X!!'#$A#xdddddddCBNSSx+Bias~ is~ not ~statistically ~significant. x6X@8;X@x6X@8;X@x6X@8;X@8BiasJ8isb8 statistically 8 significant88.߁$(#(#X(#(#X!A'#$ -a#x( dddddddCTCRITx0Critical~ t-VALUE~(n (12  20), alpha~=~95%) x6X@8;X@x6X@8;X@x6X@8;X@8Critical*8t8VALUEB8n8" 8V 88(8(2 812 820 8) 8,&8958%8)z 8-$(#(#x(#(#X!a'#$ g. Correction Factor: b#xsddddd%ddCxCF~=~1~+~B over CSx6X@8;X@x6X@8;X@x6X@8;X@!CFPB8CSi 91b$(#(#` (#(# !'#$ h. Relative standard deviation: n#xsdddddddCxRSD~=~100 times SD over Smx6X@8;X@x6X@8;X@x6X@8;X@!RSDSD8Sm'100n$(#(#(#(# !'#$ 4. Press the "home" key to return to the main menu. p0*0*0*Q'#!'# A( '#! a'#'#p  ?  E. Analyte spiking with a quadruplicate sampling train:  1.Press "ALT" "A" to locate this spreadsheet. 2.Enter the value of the spiked level, enter the results of the spiked samples (both trains, A & B), and enter the results of the unspiked samples (both trains, A & B). To enter the data use the arrow keys to place the curser over the desired cell and key in the corresponding result. These entry cells should be unprotected and therefore blue. NOTE: The spreadsheet was developed with the assumption that all concentration data is in comparable units, (i.e. all entries in  C( g/m3 or ppm.)  3.The spreadsheet will display results for the following: a. Standard deviation of the spiked samples: 6#x6dddddjnddCISOSDx- SDs~=~ sqrt{{SUM {(SA-SB)^{2}}} over {n-1}} x6X@8;X@x6X@8;X@x6X@8;X@SDs<SA<SB08n <8(TTNSSRrI<(r<)~2 816$(#(#(#(#!'#$` ` SA: Spiked samples train A ` ` SB: Spiked samples train B ` `  n: Number of runs b. Standard deviation of the unspiked samples: 6#x6dddddjnddCANASDSx- SDu~=~ sqrt{{SUM {(SC-SD)^{2}}} over {n-1}} x6X@8;X@x6X@8;X@x6X@8;X@SDu<SC<SD08n <8(TTNSSRrI<(r<)~2 816$(#(#(#(#!'#$` ` SC: Unspiked samples train C ` ` SD: UNspiked samples train B ` `  n: Number of runs c. Relative standard deviation of the spiked samples: E#xsd"dddddddCxRSDs~=~SDs over Smx6X@8;X@x6X@8;X@x6X@8;X@!RSDsdSDs8SmYGE$(#(#(#(# !'#$` ` Sm= Average of spiked samples d. Relative standard deviation of the unspiked samples: F!#xs'dddddddCANARSDSxRSDu~=~SDu over Sm x6X@8;X@x6X@8;X@x6X@8;X@!RSDudSDu8SmYGF$(#(#,#(#(# !!'#$` ` Sm= Average of unspiked samples `(0*0*0*A'#]'#-d"'#:%''#*!`Ԍe. Bias: aA#xxdddddddC xB~=~Sm~~Mm~~CSx6X@8;X@x6X@8;X@x6X@8;X@8B8Sm8Mm8CS888a$(#(#(#(#X!A'#$ f. Standard deviation of the mean: a#x` dddddddC xSDM~=~sqrt{SDs^{2}~+~SDu^{2}}x6X@8;X@x6X@8;X@x6X@8;X@8SDM8SDs 8SDu8=8Oz2z2ߒ$(#(#(#(#X!a'#$ g. Calculated tValue: #xsH dddddUddCISOTVAL x'.t-VALUE~=~{left LINE B right line} over {SDM} x6X@8;X@x6X@8;X@x6X@8;X@!tVALUE<B8SDM-  'ߤ$(#(#(#(# !'#$ h. Bias acceptance status: "#xdddddddCTVALACC x8IF~ t-VALUE (calculated)~ <= ~t-VALUE (critical)~ THEN~ x6X@8;X@x6X@8;X@x6X@8;X@8IFZ8tJ8VALUE8 calculatedj 8tZ 8VALUE*8critical8THEN8 8 88( 8)8(8)"$(#(#H (#(#X!'#$#xPdddddddCBNSS x+Bias~ is~ not ~statistically ~significant. x6X@8;X@x6X@8;X@x6X@8;X@8BiasJ8isb8 statistically 8 significant88.߁$(#(#(#(#X!'#$#xdddddddCTCRIT x<Critical~ t-VALUE~=~2.201~(n~=~12, alpha~=~95%, twotailed) x6X@8;X@x6X@8;X@x6X@8;X@8Critical*8t8VALUE 8nV8two68tailed88 88882 8. 8201J 8(b 812R8,v895f8%8,8)8ߓ$(#(#(#(#X!'#$ i. Correction Factor: c#xsddddd%ddCISOCF xCF~=~1~+~B over CS x6X@8;X@x6X@8;X@x6X@8;X@!CFPB8CSi 91c$(#(#(#(# !'#$ 4. Press the "home" key to return to the main menu.  ?X  F. Printing options: 1.Press "ALT" "C" to locate the menu. 2.Press "ALT" "" to print the method comparison quad train results. 3.Press "ALT" "" to print the method comparison paired train results. 4.Press "ALT" "" to print the isotopic spiking paired or quad train results. 5.Press "ALT" "" to print the analytye spiking quad train results. 6.Press the "home" key to return to the main menu.