10-14-2015, 09:50 PM
Post: #1
 Arno K Senior Member Posts: 432 Joined: Mar 2015
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
10-15-2015, 05:52 AM
Post: #2
 cyrille de brébisson Senior Member Posts: 934 Joined: Dec 2013
RE: Spreadsheet and programming
Hello,

I am not 100% sure that I understand what you are trying to do, but here are some pointers

Have you looked at the Cell command? It allows you to access Cells by their row/column number (Cell(1,1) <=> A1, Cell(0,1) is column A)

You can do A1:AA100(-1):=Cell(0,0) to erase the spreadsheet.
It basically sets all cells content and meta data to the value of Cell(0,0), which is a special 0 which is detected as an empty 0 by the spreadsheet.

Cell(0,1):='Row'; Cell(0,2):='BINOMIAL(20,0.2,A:A)'
might do what you want...

Cyrille

Although I work for the HP calculator group, the views and opinions I post here are my own. I do not speak for HP.
10-15-2015, 07:30 AM
Post: #3
 Arno K Senior Member Posts: 432 Joined: Mar 2015
RE: Spreadsheet and programming
Thank you for your answer, I am going to try that today.
Arno
 « Next Oldest | Next Newest »

User(s) browsing this thread: 1 Guest(s)