I am trying to calculate R but the number I am getting is really low. Is there a way to increase the forgiveness of R.
I'm not talking about taking the square root of it. Maybe rounding the average to the nearest integer?
I'm trying to measure the consistency of hours per day over a selected period using R.
Example: I have 7 days selected. 8.49, 8.39, 8.46, 8.24, 8.44, 8.13, 8.20, 8.15
R2 = .62
I want that to read 1 or very close to 1 because they are all very close to each other. I'm not sure why.
My next idea is to force a y intercept as the average Hours but I'm having trouble with the expression.
Update: Hours is a variable that is calculating the difference of a clock in to a clock out number.
When I added Floor it did not return anything.