1. Home
  2. Measurements - Analysis
  3. Laboratory quality and safety procedures
  4. Determine a model that fits observed data as closely as possible

  5. How do I get by with Excel?

Practical sheet | REF: FIC1412 V1

Determine a model that fits observed data as closely as possible

Author: Morgan GERMA

Publication date: April 10, 2015 | Lire en français

You do not have access to this resource.
Click here to request your free trial access!

Already subscribed? Log in!

Automatically translated using artificial intelligence technology (Note that only the original version is binding) > find out more.

    A  |  A

    6. How do I get by with Excel?

    The question of the significance of coefficients is dealt with by statisticians, but is often overlooked. In the linear case, it relies on a Fisher test (see Some common hypothesis tests [FIC 1439] ), which compares the estimated values of the parameters with a priori values, taking into account the associated uncertainties and their covariances. Although not insurmountable, this test is not trivial and requires a few calculations. The bibliography refers to documents dealing with this issue. The CFM guide also deals with this issue from the angle of the "signature of a calibration process"....

    You do not have access to this resource.

    Exclusive to subscribers. 97% yet to be discovered!

    You do not have access to this resource.
    Click here to request your free trial access!

    Already subscribed? Log in!

    The Ultimate Scientific and Technical Reference

    A Comprehensive Knowledge Base, with over 1,200 authors and 100 scientific advisors
    + More than 10,000 articles and 1,000 how-to sheets, over 800 new or updated articles every year
    From design to prototyping, right through to industrialization, the reference for securing the development of your industrial projects

    This article is included in

    Laboratory quality and safety procedures

    This offer includes:

    Knowledge Base

    Updated and enriched with articles validated by our scientific committees

    Services

    A set of exclusive tools to complement the resources

    Practical Path

    Operational and didactic, to guarantee the acquisition of transversal skills

    Doc & Quiz

    Interactive articles with quizzes, for constructive reading

    Subscribe now!

    Ongoing reading
    How do I get by with Excel?
    Outline