How to calcule p value if all we have is the confidence valu

How to calcule p value if all we have is the confidence value which is 95.0%, the z value which is 1.960, the E value which is 0.03, and finally the q value which is 0.95 in excel.

How to determine the p value using excel with this information?

p-value depends on direction of hypothesis. This does not seem to be a hypothesis test. Here, I am assuming that you mean to ask value of sample proportion, which is: p = 1-q = 1-0.95 = 0.05