Correct and recalculate

In this lesson you change the glucose repeatability study from your first study: you exclude one result, correct another, recalculate, then tighten the limit until the study no longer meets it. Every earlier calculation stays in the study's history. Open Glucose · repeatability from Studies to begin.

1. Select the Data tab.
2. On row 5 (100.8), select Edit in the Correct / exclude column. The Correct or exclude row 5 dialog opens.
3. Tick Exclude this row from the calculation.
4. Under Exclusion reason, type Clot flagged by analyzer.
5. Select Save row changes. Row 5 now reads Excluded.

1. On row 1, select Edit. The dialog shows the Original entry, 99.2 mg/dL, and where it came from: repeatability.csv · source row 2.
2. Change Result to 99.3.
3. Select Save row changes. Row 1 now reads Corrected.

1. Select Recalculate results in the study header. It saves your corrections, then calculates.

The Results stage reads Criteria met with 19 results analyzed · 2 excluded. The CV is now 0.94% against the limit ≤ 1%, and Key results gives a mean of 100.14 mg/dL and an SD of 0.945 mg/dL. Study notes names the excluded row: Row 5 (100.8 mg/dL) was excluded: Clot flagged by analyzer.

1. Select the Set up tab.
2. Under Acceptance limits, select Edit on the CV limit.
3. Change Largest acceptable CV (%) to 0.8, then select Update limit.
4. Select Save and enter data, then Recalculate results.

The study now reads Criteria not met: the CV, 0.94%, is above the limit, ≤ 0.8%, and its line reads Not met.

1. Select the Report tab. The result reads Criteria not met.
2. Select History. It lists the study's 3 calculations, newest first; the latest is marked (latest) and Shown now.
3. Select Open on the last one in the list, the oldest. A banner reads Showing this calculation as first produced., and the report is your first calculation: Criteria met, with 20 included results and a CV of 0.93%.
4. Select Back to the current report to return.

For your own studies, see Correct or exclude a result. About records and history explains why earlier calculations never change.