[opensuse] Lies, damned lies and statistics

newer
[opensuse] Re: scanner that works...

older
[opensuse] Re: Periodic problem...

Joop Beris

22 Sep 2009 22 Sep '09

09:42

Hello listmates, Recently we have done a poll around the office. Now, I am supposed to process the results and show it all off with tables and graphs, etc. Now, I can do this by hand, of course. However, I wouldn't be much of an IT person if I did... So, does anyone know of a piece of software under Linux that could do this sort of thing? I've searched the repos, but I haven't been able to find one supplied with openSUSE. I am running 11.1, with KDE 4.3. Any way to do this in OpenOffice perhaps? Any tips are welcome. Regards, Joop -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Show replies by date

Clayton

22 Sep 22 Sep

09:46

...

Recently we have done a poll around the office. Now, I am supposed to process the results and show it all off with tables and graphs, etc. Now, I can do this by hand, of course. However, I wouldn't be much of an IT person if I did...

So, does anyone know of a piece of software under Linux that could do this sort of thing? I've searched the repos, but I haven't been able to find one supplied with openSUSE. I am running 11.1, with KDE 4.3. Any way to do this in OpenOffice perhaps?

Depends on your data types of course, but OOo Calc plus the Charting component will produce all kinds of output... which can all be embedded into Impress. http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc... http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Impr... C. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Adam Tauno Williams

10:21

...

So, does anyone know of a piece of software under Linux that could do this sort of thing? I've searched the repos, but I haven't been able to find one supplied with openSUSE. I am running 11.1, with KDE 4.3. Any way to do this in OpenOffice perhaps?

Absolutely. I produce really great charts and graphs with OOo. -- OpenGroupware developer: awilliam@whitemice.org http://whitemiceconsulting.blogspot.com/ OpenGroupare & Cyrus IMAPd documenation @ http://docs.opengroupware.org/Members/whitemice/wmogag/file_view -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Joop Beris

10:37

On Tue, 22 Sep 2009 06:21:26 -0400, Adam Tauno Williams wrote:

...

...
So, does anyone know of a piece of software under Linux that could do this sort of thing? I've searched the repos, but I haven't been able to find one supplied with openSUSE. I am running 11.1, with KDE 4.3. Any way to do this in OpenOffice perhaps?

Absolutely. I produce really great charts and graphs with OOo.

Thank you for the reply, but maybe I was not clear enough. I am aware of the fact that OpenOffice can produce charts and graphs. :-) However, I am looking for either some software or some help on how to process the poll results. Any ideas? Thanks in advance, Joop -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

phanisvara das

10:49

On Tuesday 22 September 2009 04:07:21 pm Joop Beris wrote:

...

However, I am looking for either some software or some help on how to process the poll results. Any ideas?

since you refered to yourself as an "IT person" earlier, i thought you would be able to open OOo and find out how to do that. i'm not sure if this is the proper place to explain the use of OO applications; i think the openOffice forums (http://www.oooforum.org/) would be a better place, or specifically http://www.oooforum.org/forum/viewforum.phtml?f=3, the OO calc forum. i'm not an expert on charts & graphs, but if somebody else here would like to help you, at least you'd have to be more specific what it is you want to do, i.e., supply some sample data that you want to display. -- phani. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Joop Beris

10:58

On Tue, 22 Sep 2009 16:19:38 +0530, phanisvara das wrote:

...

On Tuesday 22 September 2009 04:07:21 pm Joop Beris wrote:

...
However, I am looking for either some software or some help on how to process the poll results. Any ideas?

since you refered to yourself as an "IT person" earlier, i thought you would be able to open OOo and find out how to do that.

Yes, all IT people know how to process polls and understand statistics...

...

i'm not sure if this is the proper place to explain the use of OO applications; i think the openOffice forums (http://www.oooforum.org/) would be a better place,

...

or specifically http://www.oooforum.org/forum/viewforum.phtml?f=3, the OO

...

calc forum.

Thanks, perhaps I will take my question there. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

phanisvara das

11:12

On Tuesday 22 September 2009 04:28:01 pm Joop Beris wrote:

...

Yes, all IT people know how to process polls and understand statistics...

to some extent, i thought so. if elaborate statistical analysis and understanding is required, perhaps a "finance-" or "accounting-person" would be better suited...

...

Thanks, perhaps I will take my question there.

please don't take my word for it (that this is not the proper place to ask). i'm very new on this mailing list and don't really understand yet what's going on, or supposed to go on here. i wasn't thinking to 'protect' this forum from your question, but that you would probably find that similar questions have already been asked at OOo forums, making it easier for you to find help. i'm sorry if my reply sounded off; reading it again i realized it might be understood in that way. again, that wasn't my intention. -- phani. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Joop Beris

11:22

On Tue, 22 Sep 2009 16:42:14 +0530, phanisvara das wrote:

...

On Tuesday 22 September 2009 04:28:01 pm Joop Beris wrote:

...
Yes, all IT people know how to process polls and understand statistics...

to some extent, i thought so. if elaborate statistical analysis and understanding is required, perhaps a "finance-" or "accounting-person" would be better suited...

I agree with that, however someone "volunteered" me, if you know what I mean... :-)

...

i'm sorry if my reply sounded off; reading it again i realized it might be understood in that way. again, that wasn't my intention.

Thank you, Phani. Yes, I did read it that way, which probably says more about me than it does about you... Apology much appreciated and accepted. :-) Thanks for your tips, Joop -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

G T Smith

11:31

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Joop Beris wrote:

...

On Tue, 22 Sep 2009 16:19:38 +0530, phanisvara das wrote:

...
On Tuesday 22 September 2009 04:07:21 pm Joop Beris wrote:

...
However, I am looking for either some software or some help on how to process the poll results. Any ideas? since you refered to yourself as an "IT person" earlier, i thought you would be able to open OOo and find out how to do that.

Yes, all IT people know how to process polls and understand statistics...

!? :-) There is the presentation of statistics, there is interpretation of statistics and then there is the presentation of the interpretation of the statistics. Charts do not in themselves perform the interpretative part. Presenting and interpreting survey data depends on the whether the data is quantitative or qualitative... a long time ago we had SPSS for this kind of stuff... might be worth looking at... http://spss.wikia.com/wiki/Free_open_source_statistical_software_links as a starting point... Using a spreadsheet for anything other than basic stats is not really sensible....

...

...
i'm not sure if this is the proper place to explain the use of OO applications; i think the openOffice forums (http://www.oooforum.org/) would be a better place,

...
or specifically http://www.oooforum.org/forum/viewforum.phtml?f=3, the OO

...
calc forum.

Thanks, perhaps I will take my question there.

- -- ============================================================================== I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone. Bjarne Stroustrup ============================================================================== -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.9 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org/ iEYEARECAAYFAkq4tXsACgkQasN0sSnLmgJ7RwCgrj9vl3vT6nYYE6NO1VWkiPLU lJgAoO+t5jMB+1TYnVKfQWS2dSU95rxQ =X9EW -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Clayton

11:37

...

since you refered to yourself as an "IT person" earlier, i thought you would be able to open OOo and find out how to do that. i'm not sure if this is the proper place to explain the use of OO applications; i think the openOffice forums (http://www.oooforum.org/) would be a better place, or specifically http://www.oooforum.org/forum/viewforum.phtml?f=3, the OO calc forum.

The "official" OOo forum is actually here: http://user.services.openoffice.org/ There is een Nederlands talig (may be of interest to Joop) as well English and other language specific forums available. C. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

phanisvara das

11:01

On Tuesday 22 September 2009 04:07:21 pm Joop Beris wrote:

...

I am looking for either some software or some help on how to process the poll results.

here's a tutorial on http://www.tutorialsforopenoffice.org/tutorial/Charting_Data.html from the site "tutorials for openoffice" (http://www.tutorialsforopenoffice.org/index.html). and here you find links to a variety of OOo support sites: http://www.oooforum.org/links.phtml hope this helps... -- phani. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Jay Mistry

11:05

On Tue, Sep 22, 2009 at 4:07 PM, Joop Beris wrote:

...

On Tue, 22 Sep 2009 06:21:26 -0400, Adam Tauno Williams wrote:

...
...
So, does anyone know of a piece of software under Linux that could do this sort of thing? I've searched the repos, but I haven't been able to find one supplied with openSUSE. I am running 11.1, with KDE 4.3. Any way to do this in OpenOffice perhaps?

Absolutely. I produce really great charts and graphs with OOo.

Thank you for the reply, but maybe I was not clear enough. I am aware of the fact that OpenOffice can produce charts and graphs. :-) However, I am looking for either some software or some help on how to process the poll results. Any ideas?

Thanks in advance,

Joop

R statistics software is available for most Linux distributions; but has a steep learning curve. Being from a programming background would help. http://www.r-project.org/ Jay -- Linux User 483705 | openSUSE 11.1, Ubuntu 9.04 (i686) w/ Windows XP Smolts Profile: http://www.smolts.org/client/show/?uuid=pub_b541a450-9bc1-45fd-beab-d46ee43a... -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Randall R Schulz

13:02

On Tuesday September 22 2009, Joop Beris wrote:

...

Hello listmates,

Recently we have done a poll around the office. Now, I am supposed to process the results and show it all off with tables and graphs, etc. Now, I can do this by hand, of course. However, I wouldn't be much of an IT person if I did...

So, does anyone know of a piece of software under Linux that could do this sort of thing? I've searched the repos, but I haven't been able to find one supplied with openSUSE. I am running 11.1, with KDE 4.3. Any way to do this in OpenOffice perhaps?

Any tips are welcome.

I like Gnumeric for spreadsheets of my own (I pretty much only OpenOffice to open Microsoft documents). I've used R a bit, once upon a time, and it is advised if you need really fancy statistical processing, which it doesn't sound like you do.

...

Regards,

Joop

Randall Schulz -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Mike

15:02

On September 22, 2009, Joop Beris wrote:

...

Hello listmates,

Recently we have done a poll around the office. Now, I am supposed to process the results and show it all off with tables and graphs, etc. Now, I can do this by hand, of course. However, I wouldn't be much of an IT person if I did...

So, does anyone know of a piece of software under Linux that could do this sort of thing? I've searched the repos, but I haven't been able to find one supplied with openSUSE. I am running 11.1, with KDE 4.3. Any way to do this in OpenOffice perhaps?

For analysis there is R I found a package or SuSE but it failed when I tried to install it. LinuxChix have a course on it now. it seems to be similar to SPSS, SAS and BMDP. It's hard to start thinking about the statistics after the survey. I learned the hard way that deciding how the stats were being done needs to be done before you waste too much time in the field. Spent 5 weeks collecting data only to learn that because we shared the collection and pooled the data most statistics could not be used properly. -- Collector of vintage computers http://www.ncf.ca/~ba600 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

David C. Rankin

22:16

On Tuesday 22 September 2009 04:42:07 am Joop Beris wrote:

...

Hello listmates,

Recently we have done a poll around the office. Now, I am supposed to process the results and show it all off with tables and graphs, etc. Now, I can do this by hand, of course. However, I wouldn't be much of an IT person if I did...

So, does anyone know of a piece of software under Linux that could do this sort of thing? I've searched the repos, but I haven't been able to find one supplied with openSUSE. I am running 11.1, with KDE 4.3. Any way to do this in OpenOffice perhaps?

Any tips are welcome.

Regards,

Joop

Joop, Depends on what format your data is in now. Generally, for poll results, it is just a matter of summing/dividing the votes for question 1, option A, option B, question 2, etc.. and then displaying them in a way that is meaningful for you. Even if you don't want to use OO for the plots and charts, it might not be a bad idea to at least get your data into calc so that you can manipulate it and export it in just about any format you will need for whatever you decide to use. If you just want to use the IT skills and parse the data from the command line with bash/sed/awk and then produce graphs from that, then spline, graph and plot are great cli tools for that purpose. (shot example cut and pasted from my notes): The following example demonstrates the use of calc to build a X Y string to pass to the curve fitting utility 'spline' and output the graph data file test.meta. GNU 'plot' is then called to display a graph on the screen: ans="" \ for ((i=1;i<=10;i++)); do \ ans="$ans $i $(calc -p $i^3-$i^2) " \ done \ echo $ans | spline | graph > test.meta \ plot -T X test.meta plot has good print handling as well, you'll have to check the man page for that. Otherwise, I can't think of a simpler way to chart, plot, sum, graph, etc. than to use OO. Most other solutions tend to be invent it yourself. Now I have seen some software for analyzing "web-polls", etc., but I don't have a package name handy. You'll just have to google that. Good luck with the project. -- David C. Rankin, J.D.,P.E. Rankin Law Firm, PLLC 510 Ochiltree Street Nacogdoches, Texas 75961 Telephone: (936) 715-9333 Facsimile: (936) 715-9339 www.rankinlawfirm.com -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Kurt Garloff

23 Sep 23 Sep

21:10

Hi, On Tue, Sep 22, 2009 at 11:42:07AM +0200, Joop Beris wrote:

...

So, does anyone know of a piece of software under Linux that could do this sort of thing? I've searched the repos, but I haven't been able to find one supplied with openSUSE. I am running 11.1, with KDE 4.3. Any way to do this in OpenOffice perhaps?

If you want to script it, looking into the gd / gdchart library (and using its perl or python bindings) might be a good choice. For doing things manually, I would indeed think that OOo or some specialized statistics software would be best. Groeten, -- Kurt Garloff, VP OPS Partner Engineering -- Novell Inc. Comme les lois inutiles affaiblissent les lois nécessaires, celles qu’on peut éluder affaiblissent la législation. [Montesqieu -- De l'ésprit des lois, liv. 29, ch. 31]

Roger Oberholtzer

24 Sep 24 Sep

06:20

On Wed, 2009-09-23 at 23:10 +0200, Kurt Garloff wrote:

...

If you want to script it, looking into the gd / gdchart library (and using its perl or python bindings) might be a good choice.

I use gd in a library. But in that case, we are making a very custom graphic. For general plots, I would go with gnuplot. It still does it all. And when scripted, it can make great plots for any device or file type. -- Roger Oberholtzer OPQ Systems / Ramböll RST Ramböll Sverige AB Krukmakargatan 21 P.O. Box 17009 SE-104 62 Stockholm, Sweden Office: Int +46 8-615 60 20 Mobile: Int +46 70-815 1696 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Adam Tauno Williams

10:35

On Wed, 2009-09-23 at 23:10 +0200, Kurt Garloff wrote:

...

Hi, On Tue, Sep 22, 2009 at 11:42:07AM +0200, Joop Beris wrote:

...
So, does anyone know of a piece of software under Linux that could do this sort of thing? I've searched the repos, but I haven't been able to find one supplied with openSUSE. I am running 11.1, with KDE 4.3. Any way to do this in OpenOfficeerhaps? If you want to script it, looking into the gd / gdchart library (and using its perl or python bindings) might be a good choice. For doing things manually, I would indeed think that OOo or some specialized statistics software would be best.

Or a hybrid using something like PyUNO. For several applications [on servers] we run Open Office as a service and applications connect to it to create and modify documents, produce PDFs, etc... You get all the features and quality of Open Office and all the automation of scripting. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

5330

Age (days ago)

5332

Last active (days ago)

List overview

Download

17 comments

11 participants

participants (11)

Adam Tauno Williams
Clayton
David C. Rankin
G T Smith
Jay Mistry
Joop Beris
Kurt Garloff
Mike
phanisvara das
Randall R Schulz
Roger Oberholtzer