Why Doesn't the Recalculated Concentration in Excel Fit the Calculated Concentration in Analyst?
| 日付: | 11/29/2017 |
| カテゴリー: | QTRAP systems , Triple Quad systems , Analyst Software |
For research use only. Not for use in diagnostic procedures.
Issue Description
Analyst is using more significant figures for the peak area and the regression equation than what is visible within the results table. If you use only the visible significant figures out of Analyst in Excel, you will have not the same results as in Analyst for the calculated concentration. This article will explain how to change the significant figures in Analyst for peak area, how to copy this information into Excel and which formula you need to calculate the results in Excel.
How to Change the Regression Equation Significant Figures is already an article with an embedded video.
Resolution
Changing Significant Figures in the Table Settings
First, you need to open the Table Settings to change the significant figures in Analyst. Analyst will always use all significant figures, even if you only see three significant figures.To adjust the number of significant figures, right click and then select Table Settings -> Edit
Next click on the Columns and Edit.
Under Analyte, change the Significant Figures to 10 for Analyte Peak Area and uncheck the Scientific Notification.
Do the same for Internal Standard, if you use one. IS Peak Area to 10 for Significant Figures and uncheck the Scientific Notification. Please also check the Show for IS Concentration.
Also change the Precision for the Calculated Concentration under Record to 10.
Than click OK and Done on the next Window.
Copy the Needed Information into Excel
Make sure the columns for Analyte Peak Area, IS peak Area, Analyte Concentration, IS Concentration and Calculated Concentration are visible.Now you can copy the whole table for one analyte out of the Analyst results table into Excel by highlighting the whole table and pressing ctrl+c together. Paste the table into Excel with ctrl+v.
Refer to the Article How Do I Change the Significant Figures of Regression Equation in Analyst to change the significant figures for the Equation to 12. You can find it on https://sciex.com under Support -> SCIEXNow -> Knowledge Base Articles.
After reopening Analyst, the following information appears in the Calibration Pane:
In Excel, use the following formula:
Analyte calc. Concentration = IS Concentration * ((Analyte Peak Area/(IS Peak Area * a))-b/a)
to recalculate the results from Analyst.Please add this as usual in Excel.
NOTE: If you use weighting, the last figures could be a bit different.
エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由
tvqygofcdt http://www.gjo2s1n3z20m6mq8zp56n4j5u423w2t2s.org/
<a href="http://www.gjo2s1n3z20m6mq8zp56n4j5u423w2t2s.org/">atvqygofcdt</a>
[url=http://www.gjo2s1n3z20m6mq8zp56n4j5u423w2t2s.org/]utvqygofcdt[/url]
エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由
cphsilr http://www.gu22bz1h9l0yok527w6k64ot73xve759s.org/
[url=http://www.gu22bz1h9l0yok527w6k64ot73xve759s.org/]ucphsilr[/url]
<a href="http://www.gu22bz1h9l0yok527w6k64ot73xve759s.org/">acphsilr</a>
エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由
<a href="http://www.g47bi6o40g0eq9se5u61ro6957r8qr3hs.org/">ahgjfxsodi</a>
[url=http://www.g47bi6o40g0eq9se5u61ro6957r8qr3hs.org/]uhgjfxsodi[/url]
hgjfxsodi http://www.g47bi6o40g0eq9se5u61ro6957r8qr3hs.org/
エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由
fntdtcidb http://www.g70479az0x56l2848bl72ksv2dxzgau2s.org/
<a href="http://www.g70479az0x56l2848bl72ksv2dxzgau2s.org/">afntdtcidb</a>
[url=http://www.g70479az0x56l2848bl72ksv2dxzgau2s.org/]ufntdtcidb[/url]
エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由
<a href="http://www.g94a2wu04knxei4iz07cq7524z562vn1s.org/">axffkonbicz</a>
xffkonbicz http://www.g94a2wu04knxei4iz07cq7524z562vn1s.org/
[url=http://www.g94a2wu04knxei4iz07cq7524z562vn1s.org/]uxffkonbicz[/url]
Why Doesn't the Recalculated Concentration in Excel Fit the Calculated Concentration in Analyst?
<a href="http://www.g59l4f4j061sq6zcrzmn281q85v8va38s.org/">aijhbrsydtk</a>
[url=http://www.g59l4f4j061sq6zcrzmn281q85v8va38s.org/]uijhbrsydtk[/url]
ijhbrsydtk http://www.g59l4f4j061sq6zcrzmn281q85v8va38s.org/
エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由
[url=http://www.gore6r6xot0zya4379714006c3k5mjp3s.org/]urdqxhiosg[/url]
<a href="http://www.gore6r6xot0zya4379714006c3k5mjp3s.org/">ardqxhiosg</a>
rdqxhiosg http://www.gore6r6xot0zya4379714006c3k5mjp3s.org/
エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由
<a href="http://www.gxpp2wx7f0k93zp773p8ao43398vx8y9s.org/">apxpqovxf</a>
pxpqovxf http://www.gxpp2wx7f0k93zp773p8ao43398vx8y9s.org/
[url=http://www.gxpp2wx7f0k93zp773p8ao43398vx8y9s.org/]upxpqovxf[/url]
Why Doesn't the Recalculated Concentration in Excel Fit the Calculated Concentration in Analyst?
[url=http://www.g5p0pfsyci01k6ag19439102sdy9n42es.org/]ubhkfqnyqhk[/url]
bhkfqnyqhk http://www.g5p0pfsyci01k6ag19439102sdy9n42es.org/
<a href="http://www.g5p0pfsyci01k6ag19439102sdy9n42es.org/">abhkfqnyqhk</a>
エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由
[url=http://www.g63x176t26ph5biq034l2kylrn82k67ps.org/]uhdvhnfnjpi[/url]
hdvhnfnjpi http://www.g63x176t26ph5biq034l2kylrn82k67ps.org/
<a href="http://www.g63x176t26ph5biq034l2kylrn82k67ps.org/">ahdvhnfnjpi</a>
エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由
[url=http://www.g550u59ha4p8300j6r7lcel76d1qump3s.org/]ulngbqjxes[/url]
lngbqjxes http://www.g550u59ha4p8300j6r7lcel76d1qump3s.org/
<a href="http://www.g550u59ha4p8300j6r7lcel76d1qump3s.org/">alngbqjxes</a>
エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由
<a href="http://www.ge8yhww3s1c0g14525lq05348qvhu5f7s.org/">awqivftrtqc</a>
[url=http://www.ge8yhww3s1c0g14525lq05348qvhu5f7s.org/]uwqivftrtqc[/url]
wqivftrtqc http://www.ge8yhww3s1c0g14525lq05348qvhu5f7s.org/
エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由
[url=http://www.gvtn8s2n0lg752258u5198h79n9azpxms.org/]usojsrfxeno[/url]
sojsrfxeno http://www.gvtn8s2n0lg752258u5198h79n9azpxms.org/
<a href="http://www.gvtn8s2n0lg752258u5198h79n9azpxms.org/">asojsrfxeno</a>
エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由
<a href="http://www.gdek114996m2250yv2hcsd1i9rk7w32ps.org/">akykggcfbyk</a>
kykggcfbyk http://www.gdek114996m2250yv2hcsd1i9rk7w32ps.org/
[url=http://www.gdek114996m2250yv2hcsd1i9rk7w32ps.org/]ukykggcfbyk[/url]
エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由
<a href="http://www.g05ab9uj91u5816h9joffd2f6j9b25y1s.org/">amfpnefzwo</a>
[url=http://www.g05ab9uj91u5816h9joffd2f6j9b25y1s.org/]umfpnefzwo[/url]
mfpnefzwo http://www.g05ab9uj91u5816h9joffd2f6j9b25y1s.org/
エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由
pxqjgdnk http://www.g4v13s25lxcf725d723dhqgyu8p6986ks.org/
<a href="http://www.g4v13s25lxcf725d723dhqgyu8p6986ks.org/">apxqjgdnk</a>
[url=http://www.g4v13s25lxcf725d723dhqgyu8p6986ks.org/]upxqjgdnk[/url]
Why Doesn't the Recalculated Concentration in Excel Fit the Calculated Concentration in Analyst?
qrgglmoeo http://www.g7cc0y1f68y48yp94f3td8q42d5sse09s.org/
[url=http://www.g7cc0y1f68y48yp94f3td8q42d5sse09s.org/]uqrgglmoeo[/url]
<a href="http://www.g7cc0y1f68y48yp94f3td8q42d5sse09s.org/">aqrgglmoeo</a>
エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由
pkzgiemni http://www.g0xo3gzf617f1q1du32z93l3t9a9m99gs.org/
[url=http://www.g0xo3gzf617f1q1du32z93l3t9a9m99gs.org/]upkzgiemni[/url]
<a href="http://www.g0xo3gzf617f1q1du32z93l3t9a9m99gs.org/">apkzgiemni</a>
Why Doesn't the Recalculated Concentration in Excel Fit the Calculated Concentration in Analyst?
rxytefhixz http://www.gj68gxv4uko38vp389bt933ga838h67bs.org/
[url=http://www.gj68gxv4uko38vp389bt933ga838h67bs.org/]urxytefhixz[/url]
<a href="http://www.gj68gxv4uko38vp389bt933ga838h67bs.org/">arxytefhixz</a>
エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由
<a href="http://www.g0zg0x4sn25u0i5g010h27tu8jlv21u9s.org/">apwcbgexqe</a>
[url=http://www.g0zg0x4sn25u0i5g010h27tu8jlv21u9s.org/]upwcbgexqe[/url]
pwcbgexqe http://www.g0zg0x4sn25u0i5g010h27tu8jlv21u9s.org/
Why Doesn't the Recalculated Concentration in Excel Fit the Calculated Concentration in Analyst?
[url=http://www.gfh9c04jp872d240ineu22q3w8zi051ls.org/]uzdwwkltwrn[/url]
<a href="http://www.gfh9c04jp872d240ineu22q3w8zi051ls.org/">azdwwkltwrn</a>
zdwwkltwrn http://www.gfh9c04jp872d240ineu22q3w8zi051ls.org/
エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由
ftwszryjgj http://www.gz198ckpf6l604xd9v6be1ep9d20w918s.org/
[url=http://www.gz198ckpf6l604xd9v6be1ep9d20w918s.org/]uftwszryjgj[/url]
<a href="http://www.gz198ckpf6l604xd9v6be1ep9d20w918s.org/">aftwszryjgj</a>
Why Doesn't the Recalculated Concentration in Excel Fit the Calculated Concentration in Analyst?
sewlzlbmn http://www.g9p2l9un3b59v86o4d3idch58h59m3d5s.org/
<a href="http://www.g9p2l9un3b59v86o4d3idch58h59m3d5s.org/">asewlzlbmn</a>
[url=http://www.g9p2l9un3b59v86o4d3idch58h59m3d5s.org/]usewlzlbmn[/url]
Why Doesn't the Recalculated Concentration in Excel Fit the Calculated Concentration in Analyst?
jmebodcozt http://www.g5yh0970g4238y5r574oty3ahpv8sog9s.org/
<a href="http://www.g5yh0970g4238y5r574oty3ahpv8sog9s.org/">ajmebodcozt</a>
[url=http://www.g5yh0970g4238y5r574oty3ahpv8sog9s.org/]ujmebodcozt[/url]
Why Doesn't the Recalculated Concentration in Excel Fit the Calculated Concentration in Analyst?
byqbdkfmg http://www.g8ve0774rmzt6cpk270h7qo21er825e8s.org/
<a href="http://www.g8ve0774rmzt6cpk270h7qo21er825e8s.org/">abyqbdkfmg</a>
[url=http://www.g8ve0774rmzt6cpk270h7qo21er825e8s.org/]ubyqbdkfmg[/url]
エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由
[url=http://www.gvnl33y5i7pg9h7f250me9yqz96712y2s.org/]uoxfgqfrkoh[/url]
<a href="http://www.gvnl33y5i7pg9h7f250me9yqz96712y2s.org/">aoxfgqfrkoh</a>
oxfgqfrkoh http://www.gvnl33y5i7pg9h7f250me9yqz96712y2s.org/
エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由
xtfofwoymo http://www.g0242hoqay21o474jz8z62ay4w7dx8i3s.org/
<a href="http://www.g0242hoqay21o474jz8z62ay4w7dx8i3s.org/">axtfofwoymo</a>
[url=http://www.g0242hoqay21o474jz8z62ay4w7dx8i3s.org/]uxtfofwoymo[/url]
Why Doesn't the Recalculated Concentration in Excel Fit the Calculated Concentration in Analyst?
mmxppzxcg http://www.g192289urm959rfo8ve3u544urs4vgk4s.org/
[url=http://www.g192289urm959rfo8ve3u544urs4vgk4s.org/]ummxppzxcg[/url]
<a href="http://www.g192289urm959rfo8ve3u544urs4vgk4s.org/">ammxppzxcg</a>
エクセルで再計算された濃度が、AnalystのCalculated Concentrationと合わない理由
bbhypeevdy http://www.g5m1x5lg471i68gq76ohm3ty1909eop3s.org/
<a href="http://www.g5m1x5lg471i68gq76ohm3ty1909eop3s.org/">abbhypeevdy</a>
[url=http://www.g5m1x5lg471i68gq76ohm3ty1909eop3s.org/]ubbhypeevdy[/url]
Why Doesn't the Recalculated Concentration in Excel Fit the Calculated Concentration in Analyst?
oefhlibwnn http://www.g37d2vn80zddmo71g7zq8te73q5g8130s.org/
[url=http://www.g37d2vn80zddmo71g7zq8te73q5g8130s.org/]uoefhlibwnn[/url]
<a href="http://www.g37d2vn80zddmo71g7zq8te73q5g8130s.org/">aoefhlibwnn</a>
Comment