How to test significance for Spearman correlation What is the maximum number of pairs allowed in a Spearman correlation to calculate the p-value in order to check the significance of the correlation coefficient?
As per the articles I've found online and their formulae that I tried, I'm getting a p-value of above 1, I want to know where I'm going wrong.
My data sets' sizes vary from 30 data points to 150 data points. I have the Spearman correlation coefficient but I want to test for significance.

There is no maximum sample size allowable for calculating Spearman's rank correlation coefficient.
To test $\text{H}_{0}\text{: }\rho_{\text{S}} = 0$ against $\text{H}_{\text{A}}\text{: }\rho_{\text{S}} \ne 0$, you can use a $t$ test statistic (let's choose $\alpha = 0.01$):
$$t = \frac{r_{\text{S}}-\rho_{\text{S0}}}{\sigma_{r_{\text{S}}}} \approx \frac{r_{\text{S}}}{s_{r_{\text{S}}}}$$
Where $s_{r_{\text{S}}} = \sqrt{\frac{1-r^2_{\text{S}}}{n-2}}$.
For example, of you calculate $r_{\text{S}}=0.6$ in a sample of 20 paired observations, then $s_{r_{\text{S}}}=\sqrt{\frac{1 - .6^2}{20-2}} = 0.1885618$, and so $t = 3.181981$. Therefore $p = Pr(|T_{\nu=18}|\ge |3.181981|) = 0.00258146\times 2 = 0.00516292$.
Because $0.00516292 < 0.01$ (i.e. $p < \alpha$), we reject $\text{H}_{0}$, and can conclude that we found evidence that $\rho_{\text{S}}$ is not equal to 0 significant at the $\alpha = 0.01$ level.
