Help needed! Doing a Statistic question on Excel...?

Question

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!!

Thx guys it worked but after i dragged the formular part of the cells turned into things like 8.04026E-06 and 1.36669E-08, instead of a number. Why is that and what should I do?

Answer 1

To fill column A, fill in A1 with 0 and then A2 with 1. Now use the mouse to select both of those cells. Now use the mouse to grab the little black + sign at the bottom right of the box surrounding both of those cells and drag that box down until the value shown is 50 (this will occur in cell A51). Next, go to cell B1 and enter your formula:
"=BINOMDIST(A1,n,p,FALSE)"

Substitute n and p for the numbers that you were given. After you hit enter, use the mouse to select this cell, right click, select copy. Then use the mouse to drag select B2 to B51, right click in the selection and select paste. Excel will automatically change the A1 reference to the correct cell reference for each line.

That's it!

Answer 2

Point the cursor over the lower right edge of the cell where you've already written the formula. The cursor will turn into a cross symbol. Left click on it and drag it down. That will automatically give you the same formula but A2 will now be changed to A3 and so on.

Answer 3

One you enter a formula into a cell, you can then left-click the lower right-hand corner of the cell, hold the mouse button down, and drag to fill a range. The formula will auto-populate into each cell in that range.

You will need to either give N and p into the formula, or cite the cells containing those values. If you cite the cells, make sure to make them static (the cell reference will look like this: $B$4).