P-value using ranksum function

I want to use ranksum function to the following data in A1 but p value appear NAN why?

Answer 1

[Star Strider]

All your values in the ‘A1.xls’ file are zero.

That will be a problem for ranksum.

D = xlsread('Matlab A1.xls');
Dmin = min(D)
Dmax = max(D)
Dinf = D(~isfinite(D))

Dmin =
     0     0     0     0     0     0

Dmax =
     0     0     0     0     0     0

Dinf =
  0×1 empty double column vector

[Matlab]

What do you mean that is a problem in ranksum ? And how can I solve this problem? All values equal to zero so p value must be 1.

[Star Strider]

Please read the documentation on the ranksum function, and consult a statistics textbook on the Wilcoxon rank sum test.