Forum Discussion

1 Reply

  • Olufemi7's avatar
    Olufemi7
    Iron Contributor
    Mar 17, 2026

    Hello Zane1​,
    The error happens because Excel is not recognizing your Time values as numbers. They are written with commas (0,00; 6,00; etc.), which Excel treats as text. CORREL requires two numeric ranges of equal length.

    To fix it:

    1. Reformat the Time column as Number.
    2. Replace commas with decimal points if needed (0.00, 6.00, etc.).
    3. Confirm both columns have the same number of numeric entries.
    4. Enter the formula:
    5. =CORREL(A2:A10,B2:B10)

    This will return the correlation coefficient correctly once both ranges are numeric and aligned.