10-14-2015, 09:50 PM
I am making a spreadsheet to show my pupils some probability properties, here alternative hypothesis and I want to set the toplines of used columns from a program as well as fill columns automatically. Most convenient would be something like : fill A with values from µ1 to µ2, B and C with according probabilities and delete all the unnecessary stuff below. I can do that with some FOR-Loops and constructing necessary names like B3.. from strings but I am interested in a more convenient way using the top line of the column like in "select B, then =BINOMIAL(N,p,Ax)"
Arno
Arno