Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenMon, 25 Aug 2014 02:37:56 +0200histogram - frequency distribution - discrete datahttps://ask.libreoffice.org/en/question/14398/histogram-frequency-distribution-discrete-data/Hi,
In calc I am wanting to plot a histogram / frequency distribution from discrete data.
[My stats knowledge is "enough to be dangerous"... For this post I would divide data into 3 categories:
Continuous (eg Height, a floating point value)
Discrete (eg Number of people, a numeric integer)
Categorical (eg Make of car, probably a text string)
Anyone want to correct me so that I can use the correct terms, please do!!!
]
All the discussions about this that I can see involve continuous data requiring bins to be set up.
I know what I want can be done by sorting, grouping etc but I am doing many of these charts and am wanting a "low click" method. I also have many different data sets with different data values so I am wanting say a modified "FREQUENCY" function which determines the unique entries in the Data parameter, and therefore does not require a Classes parameter.
Is there a way to do this with LO4?
Do any of the developers / software architects know if it is possible, within the LO framework, to create modified / simplified versions of the existing statistical functions that can be optimised for use with discrete / categorical data? I am not asking for it to be done, just how big a job it would be, and whether it conflicts with the LO design ...
Ta!!Tue, 12 Mar 2013 01:38:35 +0100https://ask.libreoffice.org/en/question/14398/histogram-frequency-distribution-discrete-data/Comment by oweng for <p>Hi,
In calc I am wanting to plot a histogram / frequency distribution from discrete data.</p>
<p>[My stats knowledge is "enough to be dangerous"... For this post I would divide data into 3 categories:
Continuous (eg Height, a floating point value)
Discrete (eg Number of people, a numeric integer)
Categorical (eg Make of car, probably a text string)</p>
<p>Anyone want to correct me so that I can use the correct terms, please do!!!
]</p>
<p>All the discussions about this that I can see involve continuous data requiring bins to be set up. <br>
I know what I want can be done by sorting, grouping etc but I am doing many of these charts and am wanting a "low click" method. I also have many different data sets with different data values so I am wanting say a modified "FREQUENCY" function which determines the unique entries in the Data parameter, and therefore does not require a Classes parameter.</p>
<p>Is there a way to do this with LO4?</p>
<p>Do any of the developers / software architects know if it is possible, within the LO framework, to create modified / simplified versions of the existing statistical functions that can be optimised for use with discrete / categorical data? I am not asking for it to be done, just how big a job it would be, and whether it conflicts with the LO design ...</p>
<p>Ta!!</p>
https://ask.libreoffice.org/en/question/14398/histogram-frequency-distribution-discrete-data/?comment=38795#post-id-38795Although the question [here](http://ask.libreoffice.org/en/question/19816/) was asked later, it now has a decent answer and this one is therefore a duplicate.Mon, 25 Aug 2014 02:37:56 +0200https://ask.libreoffice.org/en/question/14398/histogram-frequency-distribution-discrete-data/?comment=38795#post-id-38795Answer by horst for <p>Hi,
In calc I am wanting to plot a histogram / frequency distribution from discrete data.</p>
<p>[My stats knowledge is "enough to be dangerous"... For this post I would divide data into 3 categories:
Continuous (eg Height, a floating point value)
Discrete (eg Number of people, a numeric integer)
Categorical (eg Make of car, probably a text string)</p>
<p>Anyone want to correct me so that I can use the correct terms, please do!!!
]</p>
<p>All the discussions about this that I can see involve continuous data requiring bins to be set up. <br>
I know what I want can be done by sorting, grouping etc but I am doing many of these charts and am wanting a "low click" method. I also have many different data sets with different data values so I am wanting say a modified "FREQUENCY" function which determines the unique entries in the Data parameter, and therefore does not require a Classes parameter.</p>
<p>Is there a way to do this with LO4?</p>
<p>Do any of the developers / software architects know if it is possible, within the LO framework, to create modified / simplified versions of the existing statistical functions that can be optimised for use with discrete / categorical data? I am not asking for it to be done, just how big a job it would be, and whether it conflicts with the LO design ...</p>
<p>Ta!!</p>
https://ask.libreoffice.org/en/question/14398/histogram-frequency-distribution-discrete-data/?answer=14408#post-id-14408Work through this [answer(s)](http://ask.libreoffice.org/en/question/12278/histogram-questions/) it might have asolution for you.
In General: Calc is a spreadsheet program and I think there is only so much you can squeeze in it. Tue, 12 Mar 2013 02:43:23 +0100https://ask.libreoffice.org/en/question/14398/histogram-frequency-distribution-discrete-data/?answer=14408#post-id-14408