1 / 6

User’s Guide to the ‘QDE Toolkit Pro’

Ch 13: 177. User’s Guide to the ‘QDE Toolkit Pro’. May 2, 2002. National Research Conseil national Council Canada de recherches. Excel Tools for Presenting Metrological Comparisons by B.M. Wood, R.J. Douglas & A.G. Steele. Chapter 13. Preparing ‘Lab Views’ of the Comparison.

ajay
Télécharger la présentation

User’s Guide to the ‘QDE Toolkit Pro’

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Ch 13: 177 User’s Guide to the ‘QDE Toolkit Pro’ May 2, 2002 National Research Conseil national Council Canada de recherches Excel Tools for Presenting Metrological Comparisons byB.M. Wood, R.J. Douglas & A.G. Steele Chapter 13. Preparing ‘Lab Views’ of the Comparison In this chapter, we present the facilities of the QDE Toolkit to automatically make a Lab view of the comparison from the perspective of any particular participant. The pooling statistics are then “exclusive statistics” for the particular participant, and represent his “rest of the world”. These are the views that a participating Lab may wish to use with their more interested clients. One workbook can hold the Lab views from each Lab, if desired.

  2. Ch 13: 178 QDE Toolkit Pro - Changing to a Lab View A measurement comparison can be presented from the perspective of any one participating Lab: “my Lab compared to the rest of the world”. It seems important to avoid the doubts that arise when “the rest of the world” is summarized by a KCRV to which you yourself have contributed. The QDE Toolkit Pro provides two ways of converting a comparison into the view from one Lab, whose value is “promoted” out of the Lab values, and treated as the RV. A new worksheet is created, where pooling plots and various “exclusive statistics” (Steele, Wood and Douglas, Metrologia38, 483-488 (2002) ) can be created.

  3. Ch 13: 179 QDE Toolkit Pro - Changing to a Lab View The QDE Toolkit Pro has two macros that convert a comparison into the view from one Lab. They differ in how they treat the reference Lab uncertainty.QDE2.xls!tk_RV0isLab_NewWorksheet creates a new worksheet with the zero reference changed to the Lab selected in Col A. The new worksheet is created with only a single reference value: the selected Lab. Only the zero of the comparison is shifted, and the RV Lab retains its uncertainty, degrees of freedom and correlations with other Labs. The zero shift is trivial, but the but the resulting worksheet facilitates the use of exclusive statistics and adds easily-explained clarity.QDE2.xls!tk_RVisLab_NewWorksheet creates a new worksheet in the same way, but explicitly calculates the pair uncertainties and attributes them to the difference (Labi-LabRV). All degrees of freedom and correlation information is used. Correlation coefficients of (Labi-LabRV) vs (Labj-LabRV) are calculated.

  4. Ch 13: 180 QDE Toolkit Pro - Changing to a Lab View This kind of lab view is likely to be a useful tool when a participating Lab needs to explain the relationship of its comparison results with the rest of the world. These lab views are independent of the KCRV. Very occasionally with this view, we may loose some useful opinion about where the ‘best’ SI value is. The two approaches are illustrated below: in both cases the RV is Lab 3 and is shown in red. Adjusted values are shown by gold/sand background colors.

  5. Ch 13: 181 QDE Toolkit Pro - Changing to a Lab View QDE2.xls!tk_RV0isLab_NewWorksheet creates a new worksheet with the zero reference changed to the Lab selected in Col A. The new worksheet is created with only a single reference value: the selected Lab. Only the zero of the comparison is shifted, and the RV Lab retains its own uncertainty, etc. You can make a separate worksheet for each Lab, as has been done here for Lab 3. Note that the pooled curves (black and blue) and the pair-difference curve have been recalculated to exclude Lab 3: they are Lab 3’s version of “the rest of the world”: very popular for impressing the participants’ clients.Note also that the pair-difference curve (yellow), which is exclusive of Lab3, is symmetric about zero and has been artificially placed at the Lab3 defined zero.

  6. Ch 13: 182 QDE Toolkit Pro - Changing to a Lab View QDE2.xls!tk_RVisLab_NewWorksheet creates a new worksheet and explicitly calculates the pair uncertainties and attributes them to the difference (Labi-LabRV). All degrees of freedom and correlation information is used. Correlation coefficients of (Labi-LabRV) vs (Labj-LabRV) are calculated. Again, you can make a separate worksheet for each Lab, as has been done here for Lab 3. Note that the pooled curves (black and blue) and the pair-difference curve have been recalculated to exclude Lab 3: they are Lab 3’s version of “the rest of the world”: very popular for impressing the participants’ clients.Note also that the pair-difference curve (yellow), which is exclusive of Lab3, is symmetric about zero and has been artificially placed at the Lab3 defined zero. Note that the RV is now a delta-function, and the other curves are broader.

More Related