
Discussion BoardsOpen MenuDiscussion Boards Open Menu

BlogsOpen Menu
 HP Support Forum Home
 >
 Tablets
 >
 Calculators Handhelds
 >
 Re: HP Prime: Can't import larger data from spreadsheets for...
HP Support Forums
Join in the conversation.
 Subscribe
 Mark Topic as New
 Mark Topic as Read
 Float this Topic to the Top
 Bookmark
 Subscribe
 Printer Friendly Page
HP Prime: Can't import larger data from spreadsheets for statistical analysis
 Mark as New
 Bookmark
 Subscribe
 Subscribe to RSS Feed
 Highlight
 Report Inappropriate Content
06162014 10:40 AM
I just got an HP Prime, but all my work requires importing data from spreadsheets for statistical analysis. I deal with data columns of about 500 entries so entering them by hand is not an option.
Is there a way to import data into the statistical spreadsheet num used buy the 1D and 2D statistical apps?
I looked at the Hp connectivity and emulator options but none of them allow it to import colums of data.
It will be great if one could copy CtrolC data from an excel spreadsheet and CtrlV them into the HP Prime spreadsheet but it seem that that feature has not been implemented.
I saw an hp xcell for other applications that seem to help but I don't see it supported by the HP Prime..
Anybody knows a way to import this type of spreadsheet data?
The HP Prime is a very nice calculator but the innability to import spreadsheet data to it, through a PC or any other means, really kills any serious user that wants to use any real data.
Without it, my HP Prime is just a toy that cannot be used effectively for my real work and could not recommend this calculator to my collegues because of its spreadsheet entry limitations. Such a nice calculator and such a great limitation.. Please HP fix this issue, it is like having a race car with toy tires... thanks...
I am all for hacking if there is a way to do this key enabling data transfer stage...
Re: HP Prime: Can't import larger data from spreadsheets for statistical analysis
 Mark as New
 Bookmark
 Subscribe
 Subscribe to RSS Feed
 Highlight
 Report Inappropriate Content
06162014 11:24 PM
Hello,
Spreadsheet, like Stats columns are manageable as lists...
This means that you can do: D1:={1,2,3,4} or A1:A4:={1,2,3,4}
for you, what it means is that you can copy your data from excel (1 column at a time), paste it in a 'good' text editor, one with real find/replace function, and then replace the cariage return by commas. Add { and } at the begining and end and you have your column transformed into a list...
you can then copy/paste this list from the editor to the calculator.
If you feel so incline, you (or someone) could create a program to transform csv file into lists of lists to automate the process.
Cyrille
Re: HP Prime: Can't import larger data from spreadsheets for statistical analysis
 Mark as New
 Bookmark
 Subscribe
 Subscribe to RSS Feed
 Highlight
 Report Inappropriate Content
06172014 11:54 AM
Thanks Cyrille, that will allow me to import my data.
Is it possible to write an programmatic option in the spreadsheet program up that permits a user to import a .txt or .csv file so that it will ask the file location/name and load the file/data by transforming it to the right syntax and loading it into the spreadsheet program..?
The more I used my HP Prime the more I like it. The logic used in the CAS and in the keys are just great and it really simplifies the usage in a very logical way.
A Micro SD card option will be great, too.
Definitely a Data Management Mgr App will really help with managing the always tedious process of import/export of user data using key popular formats..
Yesterday, I couldn't help noticing that the spreadsheet program accepts the paste of a column from an Excel spreadsheet, but at the end, only the first cell is visible in the calculator. All the other numbers are not transferred. Though, I swear they all transfer one time.. I know, too, that If I paste a multicolumn selection, the HP Connectivity application crashes and goes away.. The most optimal workflow to import data will be if the cut/past spreadsheet program gets to work to import data.
I have and had all kind of highend calculators, but the HP Prime is getting to be my preferred one..
Thanks Cyrille again for your help...
Re: HP Prime: Can't import larger data from spreadsheets for statistical analysis
 Mark as New
 Bookmark
 Subscribe
 Subscribe to RSS Feed
 Highlight
 Report Inappropriate Content
09072014 08:12 PM
Thanks for the excellent tip! I had no idea that data could be loaded into the Stat app from the command line.
Cheers,
D
p.s. Now how about a hint on how to do something similar with numbers in the matrix function?
Re: HP Prime: Can't import larger data from spreadsheets for statistical analysis
 Mark as New
 Bookmark
 Subscribe
 Subscribe to RSS Feed
 Highlight
 Report Inappropriate Content
09082014 12:14 AM
M1(1) will get you column 1, M1(1) will get you row 1 of a matrice... you can then store that in the spreadsheet like you did for the stats.
For the program to import from csv or txt, yes, it is possible, but at the moment, I am 140% overbooked... I will try to remember it and work on it later, but no garanties...
If someone wants to work on such a program, I can help them providing info on how to generate the binary file for the calculator..
Cyrille
Re: HP Prime: Can't import larger data from spreadsheets for statistical analysis
 Mark as New
 Bookmark
 Subscribe
 Subscribe to RSS Feed
 Highlight
 Report Inappropriate Content
09082014 01:40 PM
Wahoo! That is just what is needed. If I can find a bit of time, I might contribute the formatting algorithim. I'm doing it 'byhand' using Notepad on Win7 and that is easy, but an Excel macro would be better.
I'm using RPN (my experience goes back to the hp45 ca. 1971) and while different, this old dog can still learn a new trick. One thing I found was that using a canned function in RPN, the '()' part should reference the level of the stack, e.g. fX(1) operates on the stack(1); fX(2) takes arguments from stack(1) and stack(2), etc. (I'm guessing at the 'etc.'hope that's true)
Thanks for the tips!
D
Re: HP Prime: Can't import larger data from spreadsheets for statistical analysis
 Mark as New
 Bookmark
 Subscribe
 Subscribe to RSS Feed
 Highlight
 Report Inappropriate Content
09092014 09:40 AM
Stumped (again . . .)
I have 'M4', a 16x4 matrix of data and need to subtract the mean of each column from each of the values in that column. (to get correlation and covariance later)
'M4mean(M4)' doesn't workinvalid dimensionprobably because mean result is a vector
builtin 'correlation' function doesn't do it either.
Do I need to create a 16x4 matrix with the 'means' in each row to subtract or is there a better way?
Re: HP Prime: Can't import larger data from spreadsheets for statistical analysis
 Mark as New
 Bookmark
 Subscribe
 Subscribe to RSS Feed
 Highlight
 Report Inappropriate Content
09092014 03:31 PM
Use the . .+ .* ./ operators to do element wise operations on vectors/matrices. Since the "mean( )" function is a CAS operation, it can return exact results. To make it always work, put in an approx( ) call.
M1(1):=M1(1) . approx(mean(M1(1));
There is probably another way to do it, but this is what comes to mind right now. I think it should work.
TW
Although I work for the HP calculator group, the views and opinions I post here are my own.
Re: HP Prime: Can't import larger data from spreadsheets for statistical analysis
 Mark as New
 Bookmark
 Subscribe
 Subscribe to RSS Feed
 Highlight
 Report Inappropriate Content
09102014 10:22 AM
Thanks for the helpprogram is one step closer to completionbut I've hit another snag: 'CAS.diag' on a square matrix doesn't return the matrix with elements on the diagonal and 0's elsewhere, I get back a vector of the diagonal elements.
Am I missing something?
Thanks,
D
Re: HP Prime: Can't import larger data from spreadsheets for statistical analysis
 Mark as New
 Bookmark
 Subscribe
 Subscribe to RSS Feed
 Highlight
 Report Inappropriate Content
09102014 11:56 AM
Thanks