3.2.1. Manual entry

Entering the Input of the data

The first column A is used to identify the samples by name.

The calibration curve is plotted with the dose (amount) or concentration on the X-axis against a response, which is the measurement of a certain variable, on the Y-axis.

A blank, which is essential for this logit regression, typically represents the response of the dilution buffer or the matrix within which the substance's concentration is measured. The blank's concentration is 0 (zero).

Doses or concentrations for the calibration curve should be entered into column B of the worksheet, labelled "Conc."

The measured values, which are the responses from the calibration curve and samples, should be recorded in column C, under the heading "Resp."

The dilution factor for the sample is recorded in column D, labelled "Dil." This particular column does not contribute to the calculation of the regression line.

Following the regression analysis, the product of the calculated concentration and the dilution factor is recorded in column E.

Ideally, this process should yield the standard's concentration on average.

Samples are logged with their respective names, either as text or numbers, and the measured response at a dilution level that falls below the calibration curve data.

Column A, titled "Name," displays the names of the samples. Column B is designated for the calibration curve and remains blank. The measured response is entered into column C, while the corresponding dilution factor is noted in column D.