The Museum of HP Calculators

HP Forum Archive 19

[ Return to Index | Top of Index ]

HP 50G Matrix Writer
Message #1 Posted by Benning on 19 June 2009, 6:11 a.m.

Hello

I have to make a Matrix Table in the Matrix Editor to use it with a ANOVA Programm (Statistic). My problem is now that i have Tables with different Lenghts.

eg:

1 2 3 4

5 6 7 8

9 8 7

2 3

If i use this matrix, HP 50g fills in all the empty data points with a 0 (Zero). This makes a wrong result. Can you help me?

grats

      
Re: HP 50G Matrix Writer
Message #2 Posted by Namir on 19 June 2009, 11:32 a.m.,
in response to message #1 by Benning

Sounds like you need to use Excel and the Data Analysis pack.

Namir

            
Re: HP 50G Matrix Writer
Message #3 Posted by Benning on 19 June 2009, 4:18 p.m.,
in response to message #2 by Namir

Okay and where can i find this?

Thanks

                  
Re: HP 50G Matrix Writer
Message #4 Posted by Gene Wright on 19 June 2009, 4:51 p.m.,
in response to message #3 by Benning

Try Google.

Search for "Excel data analysis pack"

and you get lots of hits. Here is the first one:

Link

"The Data Analysis pack is a powerful set of tools used to figure out the variance, correlation and covariance of data as well as other features. Although the Data Analysis pack is a standard feature that comes with Excel, it may not be loaded into Excel. It is usually found under the Tools menu."

To buy Excel, there are lots of options. Amazon, a local store, etc.

      
Re: HP 50G Matrix Writer
Message #5 Posted by Dave Britten on 19 June 2009, 5:58 p.m.,
in response to message #1 by Benning

Arrays are required to have rectangular dimensions. You'll get syntax errors if you try to input ragged dimensions from the command line as well.

Flag -91, when set, will cause the Matrix Writer to output a list containing each row as a list. You're still mostly limited to rectangular dimensions, however blank cells will be returned as NOVAL, and you can write programs to ignore/remove these null values.

Not sure if that helps you any with the ANOVA program, but maybe there's a partial solution in there somewhere.

[ Return to Index | Top of Index ]

Go back to the main exhibit hall