For a fixture test, you measured flow at three dial settings. SLOPE tells you how much the fitted flow increases per dial unit across those observations.

Put the dependent values first in the formula

Use dial settings 2, 4 and 6 in A2:A4. Put flow readings 6, 10 and 14 liters per minute in B2:B4. Each row belongs to one test setting.

=SLOPE(B2:B4,A2:A4)

Dial settings 2, 4 and 6 align with flow readings 6, 10 and 14.

Illustrated sample readings. Keep the input and output for each measurement on one row.

Verify both the number and the units

Flow rises by four liters per minute between settings 2 and 4. Divide by the two dial units to get 2 liters per minute per dial unit. The three example points lie on a line. With noisier measurements, the formula estimates a fitted rate over the sampled range.

A rise of four liters per minute across two dial units gives a slope of two.

Illustrated slope check. Label the result with output units per input unit.

If the result has the wrong units, check that you passed the flow values first and the settings second. Plot the pairs to see whether a linear estimate is reasonable for the part of the dial you measured.

Microsoft’s Excel function reference