I am doing a Binominal Distribution. On column A I will put a list of number from 0 to 50 (do I have to type in the number in every cell or is there anyway to do it automatically?). In column B I will put the formular BINOMDIST(x,n,p,false). N and p is already known. Now I want each cell in column B to automatically take the number in the nearby cell in column A as the x value in the formular. How can I do this without copying the formular 50 times and change each A2 to A3...
Thanks a lot!!
2007-09-21
07:18:29
·
3 answers
·
asked by
anne
1