Forum Discussion
Excel Calculation Problem
Hi everyone, can anyone here please help me I want to calculate the correlation coefficient but its giving me this error.
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:
- Reformat the Time column as Number.
- Replace commas with decimal points if needed (0.00, 6.00, etc.).
- Confirm both columns have the same number of numeric entries.
- Enter the formula:
- =CORREL(A2:A10,B2:B10)
This will return the correlation coefficient correctly once both ranges are numeric and aligned.