Add missing "Histogram" function from Data Analysis Toolkit
*** Bug 82716 has been marked as a duplicate of this bug. ***
changed source and target. Make this bug the duplicate of bug 82716. Best regards. JBF *** This bug has been marked as a duplicate of bug 82716 ***
''Bug 82716 isn't directly related to this one. That bug is about easier creating a histogram chart so you don't have to put extra histogram related data into the sheet - a dedicated histogram chart type. This one is about calculating the histogram from data and putting the results back into the sheet. I'll put this one back to status NEW.
For competitive comparison, MS Office 2016 is going to implement a Histogram chart type: https://blogs.office.com/2015/07/02/introducing-new-and-modern-chart-types-now-available-in-office-2016-preview/
Isn't bug 81530 (which is linked to this page as "See also") actually a duplicate? Both bugs refer to the chart type HISTOGRAM, while this bug refers to its entry in the Data Analysis Toolkit and the other bug in the Insert -> Chart types.
No.. that are 2 exclusive features. You can make a histogram function for the data analysis toolkit without adding a histogram chart type and the other way around.
Setting Assignee back to default. Please assign it back to yourself if you're still working on this issue
(In reply to Tomaz Vajngerl from comment #6) > No.. that are 2 exclusive features. You can make a histogram function for > the data analysis toolkit without adding a histogram chart type and the > other way around. Tomaz, what do you expect from a 'histogram' function that is not available with frequency()? https://help.libreoffice.org/Calc/Array_Functions#FREQUENCY The common understanding of a histogram is the graphical representation of what frequency calculates.
This is not about adding a new HISTOGRAM function. This is all about quickly preparing data to create data for a histogram which will use existing formulas (like FREQUENCY). Bin calculation is the key here, which will be created automatically depending on user input (number of bins) and other options. See how Analysis Toolkit works in Excel..
Feature is available in Excel and Gnumeric, so there isnt any reason not to also have it in Calc.
The design team talked about the request in the meeting. The requested Data > Statistics wizard is generic, so no mockup is needed. First, the bins have to be calculated equidistantly between min and max based on the user input on how many, followed by frequencies() and the histogram generation.
I'm not quite sure I understand what this bug is about. Does LO have a "data analysis toolkit"? Is this asking for some special wizard for many statistical operations which also involves histograms? I'd like like to just be able to generate histograms (= two-column bin, frequency tables) from unbinned data, numerical or categorical. Is this the right bug for that or should I open another one?
(In reply to Eyal Rozenberg from comment #12) > I'm not quite sure I understand what this bug is about. > > Does LO have a "data analysis toolkit"? Is this asking for some special > wizard for many statistical operations which also involves histograms? Yes, we have most functions found in "data analysis toolkit" in Data -> Statistics. And yes - just like Histogram in the "data analysis toolkit". > I'd like like to just be able to generate histograms (= two-column bin, > frequency tables) from unbinned data, numerical or categorical. Is this the > right bug for that or should I open another one? Sounds like the correct place.
BTW.. looking at this - this could be an easy hack with difficulty "interesting"...
(In reply to Tomaz Vajngerl from comment #14) > BTW.. looking at this - this could be an easy hack with difficulty > "interesting"... Adding Hossein
Created attachment 192673 [details] screenshot of results in Gnumeric (data and plot) This is an example output of Gnumeric 1.12.51's Statistics > Descriptive Statistics > Frequency Tables > Histogram dialog. It can generate a chart as well as the underlying binned data, so essentially this report + bug 81530 + bug 82716 all into one dedicated dialog. The dialog has many options in the following tabs: - Input (range can be grouped, and use labels) - Cutoffs (can come from a range too) - Bins (how boundaries are split between bins) - Graphs and Options (chart or not chart, what kind of chart, percentages or fractions, cumulative or not...) - Output (location and formatting) Quite powerful.